DbVisualizer ，有上下文，我还是有一点看不懂。。。

ruochen

原帖由 TOADLover 于 2009-9-23 16:13 发表
mysql> select user,host,password from mysql.user;
+------+-------------+----------+
| user | host        | password |
+------+-------------+----------+
| root | localhost   |          |
| ro ...

mysql不允许除本机外的其他机器连接

ruochen

原帖由 TOADLover 于 2009-9-23 16:13 发表
mysql> select user,host,password from mysql.user;
+------+-------------+----------+
| user | host        | password |
+------+-------------+----------+
| root | localhost   |          |
| ro ...

不是/etc/hosts的问题

TOADLover

原帖由 ruochen 于 2009-9-23 16:14 发表



mysql不允许除本机外的其他机器连接

-------------------
那我加了
192.168.65.67           MySQLServer
这行也不行啊，应该怎么办呢？

TOADLover

我要下线了，明天上午结贴，麻烦ruochen。。。。。

ruochen

刷新用
mysq>flush privileges;

TOADLover

正在测试。。。。

TOADLover

mysql> update mysql.user set host="%" where user=root and host=localhost;
ERROR 1054 (42S22): Unknown column 'root' in 'where clause'
mysql>
--------------------------------------------------------------------------------------------------------------
mysql> update mysql.user set host="MySQLServer" where user=root and host=localhost;
ERROR 1054 (42S22): Unknown column 'root' in 'where clause'
mysql>
---------------------------------------------------------------------------------------------------------------
mysql> update mysql.user set host="MySQLServer" where user=root and host=MySQLServer;
ERROR 1054 (42S22): Unknown column 'root' in 'where clause'
mysql>

[ 本帖最后由 TOADLover 于 2009-9-24 08:33 编辑 ]

TOADLover

mysql> show user
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user' at line 1
mysql>

[ 本帖最后由 TOADLover 于 2009-9-24 08:35 编辑 ]

TOADLover

mysql> use test;
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 * from t;
+------+----------+
| id   | stu_name |
+------+----------+
|    1 | zh       |
+------+----------+
1 row in set (0.01 sec)

mysql> show user
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user' at line 1
mysql>
----------------------------------------------
mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

mysql>

[ 本帖最后由 TOADLover 于 2009-9-24 08:39 编辑 ]

ruochen

原帖由 TOADLover 于 2009-9-24 08:33 发表
mysql> show user
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user' at lin ...

select user();