xin2v 发表于 2010-8-30 22:33:53

要疯了 mysql的DB不见了！！！！！高手入内 很诡异

# mysql -u root -port=3306 -h 10.87.0.44 -p
Enter password:
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database         |
+--------------------+
| information_schema |
| mysql            |
| test               |
| zabbix             |
+--------------------+
4 rows in set (0.06 sec)
mysql> exit
Bye
#mysql -u root -port=3306 -p
Enter password:
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database         |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)
mysql> exit
Bye
#


当我加IP登陆 就能看到 zabbix这个数据库 不然就看不到-----因为监控软件 连部上DB
DB报错如下

# cat mysqld.log
100823 21:01:14 /usr/libexec/mysqld: Normal shutdown
100823 21:01:17InnoDB: Starting shutdown...
100823 21:01:19InnoDB: Shutdown completed; log sequence number 0 404361395
100823 21:01:19 /usr/libexec/mysqld: Shutdown complete
100823 21:01:19mysqld ended
100823 21:01:21mysqld started
100823 21:01:21 option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100823 21:01:21 option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100823 21:01:22InnoDB: Started; log sequence number 0 404361395
100823 21:01:22 /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'socket: '/var/lib/mysql/mysql.sock'port: 3306Source distribution
#

kider 发表于 2010-8-31 11:46:59

用户权限问题
select host,user,password from mysql.user;
检查下权限是否有问题。

hm3030 发表于 2010-9-8 15:11:57

这问题还问。。

leal402 发表于 2010-9-21 18:06:12

'root'@'10.87.0.44'对库 zabbix是否有Show_db_priv权限？
select user,host,Show_db_priv from mysql.user;

sissiyam 发表于 2011-4-12 15:53:47

你可以查看mysql.host和mysql.db这两个表
或者用下面的语句查看
mysql>show grants for root;
mysql>show grants for root@localhost;
页: [1]
查看完整版本: 要疯了 mysql的DB不见了！！！！！高手入内 很诡异