- 论坛徽章:
- 0
|
登录正常，就是我要用grant修改权限时就出现如下提示：
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
修改密码root密码后还是一样：
$ mysql -h localhost -u root -p # 登录没有问题
Enter password:
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> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.10 sec)
mysql> select user,host,password from mysql.user;
+------+-----------+------------------+
| user | host | password |
+------+-----------+------------------+
| root | localhost | c3b58tud0c7a6wn7i |
+------+-----------+------------------+
1 row in set (0.00 sec)
mysql> grant all on *.* to 'root'@'localhost' identified by 'mypasswd'; # 就是这里总是出错
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysql> update user set password=password("mypasswd") where user='root'; # 用其它方法修改密码，都正常
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> set password for root@localhost=password("mypasswd");
Query OK, 0 rows affected (0.07 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> grant all on *.* to 'root'@'localhost' identified by 'mypasswd'; # 出错
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysql> grant usage on *.* to 'root'@'localhost' identified by 'mypasswd'; # 出错
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
|
重启mysqld也不行，因为要用grant修改权限，所以...，数据库新手，望指点
[ 本帖最后由 wertyu 于 2009-1-5 12:53 编辑 ] |
|
免费注册
发表于 2009-01-04 23:26
发表于 2009-01-05 08:32
