mysql_修改密码

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

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

1.

sudo vi /etc/mysql/my.cnf [mysqld]## * Basic Settings#user            = mysqlpid-file        = /var/run/mysqld/mysqld.pidsocket          = /var/run/mysqld/mysqld.sockport            = 3306basedir         = /usrdatadir         = /var/lib/mysqltmpdir          = /tmplc-messages-dir = /usr/share/mysqlskip-external-lockingskip-grant-tables

2.

sudo /etc/init.d/mysql stop

3.

sudo /etc/init.d/mysql start 

4.

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