这里谈到是mysql的root用户的密码。如果你的VPS安装了mysql数据库服务器,然后你又把密码给忘记了,那该怎么办呢?

1) 先修改配置文件

# vim /etc/my.cnf 
[mysqld] 
datadir=/var/lib/mysql 
socket=/var/lib/mysql/mysql.sock 
user=mysql 
# Default to using old password format for compatibility with mysql 3.x 
# clients (those using the mysqlclient10 compatibility package). 
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks; 
# to do so, uncomment this line: 
# symbolic-links=0
[mysqld_safe] 
log-error=/var/log/mysqld.log 
pid-file=/var/run/mysqld/mysqld.pid

在[mysqld]下增加skip-grant-tables, 让mysql跳过权限验证。

2) 然后登录MySQL,修改root密码。注意以下代码中的<New Password>

# mysql 
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 3 
Server version: 5.0.95 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql; 
Reading table information for completion of table and column names 
You can turn off this feature to get a quicker startup with -A
Database changed 
mysql> update user SET Password = password('<New Password>') where user='root'; 
Query OK, 2 rows affected (0.00 sec) 
Rows matched: 2  Changed: 2  Warnings: 0
mysql> flush privileges ; 
Query OK, 0 rows affected (0.00 sec)
mysql> quit 
Bye

3) 修改密码完毕。把刚才修改的配置恢复回来。然后重启mysql服务

# service mysqld restart

现在可以用<New Password>来登录mysql了

把数据库data 拷贝到linux 下运行程序提示 “mysql中Table is read only”  。

解决方案如下: mysqladmin -u root -p flush-tables
Enter password: 输入ROOT密码回车