user@machine:~$ sudo /etc/init.d/mysql [start, stop, restart]
~Fin
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
Wednesday, October 28, 2009
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.
mysql>
~Fin
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.
mysql>
~Fin
Subscribe to:
Posts (Atom)