MariaDB社区

标题: 要疯了 mysql的DB不见了！！！！！高手入内很诡异 [打印本页]

作者: xin2v 时间: 2010-8-30 22:33
标题: 要疯了 mysql的DB不见了！！！！！高手入内很诡异
[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 时间: 2010-8-31 11:46
用户权限问题
select host,user,password from mysql.user;
检查下权限是否有问题。

作者: hm3030 时间: 2010-9-8 15:11
这问题还问。。

作者: leal402 时间: 2010-9-21 18:06
'root'@'10.87.0.44'对库 zabbix是否有Show_db_priv权限？
select user,host,Show_db_priv from mysql.user;

作者: sissiyam 时间: 2011-4-12 15:53
你可以查看mysql.host和mysql.db这两个表
或者用下面的语句查看
mysql>show grants for root;
mysql>show grants for root@localhost;

欢迎光临 MariaDB社区 (http://123.56.88.72/)