Resetting mysql root password in Ubuntu

| No TrackBacks

After install mysql in Ubuntu, you should reset root password, those steps in below:
1.Stop Mysql, sudo /etc/init.d/mysql stop
2.sudo su
3.mysqld --skip-grant-tables &
4.After blank line, type mysql -u root mysql
5.UPDATE user SET Password=PASSWORD('XXXXXXXX') WHERE User='root';
6.exit
7.Stop Mysql, sudo /etc/init.d/mysql stop
8.exit su
Then, try new password with mysql -u root -p

No TrackBacks

TrackBack URL: http://server.everfine.com.tw/blog/mt-tb.cgi/217

March 2010

Sun Mon Tue Wed Thu Fri Sat
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      

Archives

Powered by Movable Type 4.33-en

About this Entry

This page contains a single entry by philipz published on October 29, 2008 11:45 PM.

Find recent content on the main index or look in the archives to find all content.