Agile FAQ

29 11 2007

I now have another website now exclusively for agile definitions apart from my personal blog.

http://AgileFAQ.net

I often get asken similar questions an what a certain term means in Agile practices when i am out teaching / coaching on agile teams. I have started keeping a catalog of these questions that have been asked in teams before instead of thinking or making up something each time.

They are all intentionally small so that you can easily print them out.

Feel free to send me more definitions you want to add.





Connecting from windows to MYSQL on Ubuntu

7 11 2007

When using mysql server on ubuntu, there is a property called  bind-address in the /etc/mysql/my.cnf file. This forces mysql to only listen to localhost.

If you want to connect to mysql from a different box say windows, make sure you comment this line.

Then restrart my sql –  sudo /etc/init.d/mysql restart

Now login to mysql on comand prompt as root  - sudo mysql -u root -p
‘=Enter password

Create a brand new user with this syntax

grant all privileges on *.* TO ‘devuser’@'IP ADDRESS OF WINDOWS’ IDENTIFIED BY ‘NEW PASSWORD’ with grant option;
After this you can use a mysql client like navicat in windows to connect with user devuser, password NEW PASSWORD.

Note that when IP changes you would have to do this all over again.