- 论坛徽章:
- 0
|
原帖由 ruochen 于 2009-9-24 13:31 发表 ![]()
再将下面行的host改为localhost,刷新权限
root Mysqlserver
记得修改权限和添加用户操作后都要刷新权限
----------------------------------------------------------------------
mysql> update mysql.user set host="localhost" where user="root" and host="MySQLServer";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select user,host,password from mysql.user;
+-------+-----------+------------------+
| user | host | password |
+-------+-----------+------------------+
| root | % | |
| root | localhost | |
| test1 | % | 7cd2b5942be28759 |
| test2 | localhost | 7cd2b5942be28759 |
+-------+-----------+------------------+
4 rows in set (0.01 sec)
mysql>
---------------------------------------------------------------------------------
这里的localhost也可以不改吧?
-------
因为我的/etc/hosts有两条记录(一个是localhost,一个是MySQLServer):
[root@MySQLServer ~]# more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.65.67 MySQLServer
[root@MySQLServer ~]#
[ 本帖最后由 TOADLover 于 2009-9-24 13:59 编辑 ] |
|