我为何不能通过mysql的命令行管理我的"虚拟主机"呢?
----------------------------------------------------
我又两台机器,都装了mysql,
但是A机可以通过命令行 登陆我的虚拟主机,并且管理我的数据库.
但是B机虽然可以登录我的虚拟主机,但是却不能 use 我的数据库.机登录可以成功,但是什么也不能做,
我不知为什么,
因为A机可以通过命令行管理我的"虚拟主机",所以应该说,主机那边没有问题,所以问题应该出在我这里.
是不是我的mysql客户端配置有问题呢?
一般问题会出在哪里呢?
----------------------------------------------------
我又两台机器,都装了mysql,
但是A机可以通过命令行 登陆我的虚拟主机,并且管理我的数据库.
但是B机虽然可以登录我的虚拟主机,但是却不能 use 我的数据库.机登录可以成功,但是什么也不能做,
我不知为什么,
因为A机可以通过命令行管理我的"虚拟主机",所以应该说,主机那边没有问题,所以问题应该出在我这里.
是不是我的mysql客户端配置有问题呢?
一般问题会出在哪里呢?
GRANT USAGE ON *.* TO 'user1'@'%' IDENTIFIED BY PASSWORD '*D82A3EDBDAD8A87063738A81A554D7ADC2AF49F7'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `user1`.* TO 'user1'@'%'
我是登录我的虚拟主机呀.我的主机,我只有一个用户,我只有一个数据库.
比如用户名是 user1,则.
mysql -h111.222.333.555 -uuser1 -p123456;
都是这样登录的,但是A机可以管理.另一台B机,就不能管理.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `user1`.* TO 'user1'@'%'
现在出问题了,如下所示:
注:我是可以登录的,但是登录后,什么也做不了.Oracle is a registered trade of Oracle Corporation and/or its
affiliates. Other names may be trades of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> status;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2982422
Current database: *** NONE ***ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show grants;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2982471
Current database: *** NONE ***ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
Your MySQL connection id is 2989299
Server version: 5.1.29-rc-communityCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trade of Oracle Corporation and/or its
affiliates. Other names may be trades of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show grants;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2989319
Current database: *** NONE ***ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
ping 是,加上 -t 参数,没有掉包.我想,是不是,主机商加了什么限制了???