Monday, October 26, 2009

Reset root password for MySql 5.* - Ubuntu 9.04 Jaunty

user@computer:~$ sudo dpkg-reconfigure mysql-server-5.0

This will pop a "dialog" in your terminal and advise you to set a root password. Verify, tab to <OK> and try logging in again:

user@computer:~$ mysql -uroot -p<password_you_just_set>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



No comments:

Post a Comment