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

xin2v

[root@mklzabbixmonotor ~]# 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
[root@mklzabbixmonotor ~]#  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
[root@mklzabbixmonotor ~]#


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

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

kider

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

hm3030

这问题还问。。

leal402

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

sissiyam

你可以查看mysql.host和mysql.db这两个表
或者用下面的语句查看
mysql>show grants for root;
mysql>show grants for root@localhost;