… de personas y sistemas.
Software Development
Adding auto increment columns
01 year ago
I’m currently working on a demo/tutorial on Evolutionary Database Development techniques and tools.
Since yesterday we installed a mysql in a client for some software configuration management operations, I decided to use mysql for the tutorial / demo at hand.
I found something strange when trying to add an auto-incremental column to an existing table.
Given this table:
create table program ( required_solo_hs int not null, required_inst_hs int not null, int not null required_hs )
I tried to add a column id:
alter table add column program id int not null auto_increment
Getting the following error;
Script line: 1 Incorrect table definition;
There Can be only one auto column and it must be defined as a key
The solution is simply to indicate that the auto increment column is also primary key:
alter table add column program id int not null auto_increment key,
Again .. someone might find it useful.
Windows Vista 64bits & MySQL: ERROR 1045 (28000): Access denied for user ‘root’@'localhost’
61 year ago
Today -at Kleer- we went through the experience of installing MySQL 5.1 for the first time in Vista 64bits. Far from being a pleasant installation, as we’re used to, this made us sweat bullets sweat.
After downloading the 64bit installer, install and configure, the setup wizard wouldn’t stop giving the error:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost'
We tried many solutions but none worked. Except for the following:
1. Stop the service “MySQL” from “Control Panel-> Administrative Tools-> Services”
2. Go to “C:\Windows\System32″
3. Find the file cmd.exe, right click with SHIFT down and select “Run as administrator”
4. Run the following command:
mysqld - skip-grant-tables
5. Leave that window running
6. Open another terminal window, this time NOT as administrator: “Start-> Run-> cmd” ENTER
7. Run the following command:
mysql-u root mysql
8. Wala! We are inside. Run the following statement, changing a password mypass real you want setear:
UPDATE user SET Password = PASSWORD ('mypass') WHERE USER = 'root';
FLUSH PRIVILEGES;
9. Exit:
exit
10. Close the window
11. Close the window that was running as administrator
12. Open task manager and kill all processes named “mysqld” (there should be one, of another user “Administrator”)
13. Start the service from “Control Panel-> Administrative Tools-> Services”
14. Log in again, this time as we are used to:
mysql-u root-p
With this last step, you should be connected without problems. I hope this solution can serve someone and save some time.
Agile in Action! – March 2010 – Review
01 year ago
From March-16th trough March-26th the workshop named Agile en Acción! took place in Buenos Aires City.
This edition was delivered to 15 participants, who through a serie of workshops based on real requierements created EPICs and User Stories, estimated and prioritized them, created the Product Backlog, defined Velocity, put together the Release Plan, and ended with a series of retrospective execices.
There was a great dynamic between the participants and between the teams that were built. We all have fun during those 4 days. I took some photos that you can access here: http://bit.ly/alQC2j
Greetings!
There will be a new Agile in Action! in April-2010: http://bit.ly/agile-en-accion–abril-2010
Agile Roles
01 year ago
This article is a Spanish direct translation of the “Programmers” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
Agile User Experience Designers
01 year ago
This article is a Spanish direct translation of the “Programmers” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
Agile Testers
01 year ago
This article is a Spanish direct translation of the “Programmers” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
Agile Programmers
01 year ago
This article is a Spanish direct translation of the “Programmers” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
Agile Functional Managers
02 years ago
This article is a Spanish direct translation of the “Functional Managers” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
Agile Architects
02 years ago
This article is a Spanish direct translation of the “Architects” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
Agile Project Managers
02 years ago
This article is a Spanish direct translation of the “Project Managers” section from the InfoQ Article named “Book Excerpt: Succeeding with Agile: Software Development Using Scrum“, which is about Mike Cohn’s book “Succeeding with Agile: Software Development Using Scrum“.
You can access the Spanish version of this article following this link.
Since the original article is written in English, I see no need to translate it. Please visit the original article here: http://www.infoq.com/articles/cohn-chapter8
