被要求加个用户,但是因为基于php4连接数据库的
要用OLD_PASSWORD来设置用户密码
方法:
1. 先创建数据库帐户
mysql> grant Select on *.* to kuja@'1.1.1.1' identified by 'kuja';
Query OK, 0 rows affected (0.00 sec)
2. 将密码置为OLD_PASSWORD
mysql> set password for 'kuja'@'1.1.1.1' = old_password('oigwpofmn');
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
或者
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13379967/viewspace-586742/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13379967/viewspace-586742/