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

TOADLover

mysql> update mysql.user set host="MySQLServer" where user="root" and host="localhost";
ERROR 1062 (23000): Duplicate entry 'MySQLServer-root' for key 1
mysql>

TOADLover

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

mysql>

TOADLover

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 mysql.user set host="%" where user="root" and host=localhost;
ERROR 1054 (42S22): Unknown column 'localhost' in 'where clause'
mysql> update mysql.user set host="%" where user="root" and host="localhost";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>

ruochen

==

ruochen

原帖由 TOADLover 于 2009-9-24 08:45 发表
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 mysql.user  ...

ok
记得刷新下

TOADLover

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>

ruochen

原帖由 TOADLover 于 2009-9-24 08:46 发表
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>

再看能不能连接数据库
然后用你那个软件看下

TOADLover

感谢ruochen!

TOADLover

DBVis的内部界面：

ruochen

原帖由 TOADLover 于 2009-9-24 08:54 发表
DBVis的内部界面：
350345

看界面很不错的说