mysql_修改密码

对于一些记性不是太好的人,我又把mysql的密码给忘记了。

以下修改密码以ubuntu上安装的mysql为例

1.

sudo vi /etc/mysql/my.cnf 

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
skip-grant-tables

2.

sudo /etc/init.d/mysql stop

3.

sudo /etc/init.d/mysql start 

4.

mysql
use mysql;
update user set Password=password('root') where user = 'root';