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.34-en

About this Entry

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

Install unix2dos on Ubuntu was the previous entry in this blog.

BIRT WebSphere 6.1 Deployment is the next entry in this blog.

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