MySQL只有information

  • 时间:
  • 浏览:0
  • 来源:大发快3APP下载—大发时时彩登录地址

mysql> show databases;

Welcome to the MySQL monitor.  Commands end with ; or \g.

owners.

| performance_schema |

Copyright (c) 800, 2015, Oracle and/or its affiliates. All rights reserved.

+--------------------+

Oracle is a registered trademark of Oracle Corporation and/or its

| Database           |

+--------------------+

Enter password: 

Oracle is a registered trademark of Oracle Corporation and/or its

Server version: 5.6.27 MySQL Community Server (GPL)

只发现 information_schema,test数据库,并未mysql,performance_schema数据库。

MBP:~ gegongxian$ sudo -s

安装好数据库时,连接MySQL,查看数据库时,发现没办法另三个数据库。

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

而且连接数据库:mysql -u root -p

Server version: 5.6.27 MySQL Community Server (GPL)

| information_schema |

affiliates. Other names may be trademarks of their respective

| information_schema |

| test               |

| test               |

Your MySQL connection id is 75

affiliates. Other names may be trademarks of their respective

2 rows in set (0.00 sec)

| Database           |

| mysql              |

6 rows in set (0.00 sec)

mysql> 

mysql> 

+--------------------+

Your MySQL connection id is 76

mysql> show databases;

+--------------------+

bash-3.2# mysql -uroot -p

Welcome to the MySQL monitor.  Commands end with ; or \g.

Copyright (c) 800, 2015, Oracle and/or its affiliates. All rights reserved.

这能不还还可以就看哪此数据库是所处的,要是 权限的显示大问题。在项目中url和用户名密码输入正确就还还可以连接上使用了。

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

owners.

应该是权限的大问题,切换到root用户:sudo -s

+--------------------+

+--------------------+

MBP:~ gegongxian$ mysql