MySQL只有information

  • 时间:
  • 浏览:0
  • 来源:彩神大发UU直播现场_神彩大发UU直播现场官方

| performance_schema |

affiliates. Other names may be trademarks of their respective

affiliates. Other names may be trademarks of their respective

bash-3.2# mysql -uroot -p

Your MySQL connection id is 75

2 rows in set (0.00 sec)

| test               |

mysql> 

这里可不需用都看哪此数据库是存在的,可是我权限的显示哪此的间题。在项目中url和用户名密码输入正确就可不需用连接上使用了。

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

Server version: 5.6.27 MySQL Community Server (GPL)

可是我连接数据库:mysql -u root -p

| test               |

owners.

Your MySQL connection id is 76

安装好数据库时,连接MySQL,查看数据库时,发现只十个 多多多数据库。

MBP:~ gegongxian$ mysql

| Database           |

MBP:~ gegongxian$ sudo -s

| Database           |

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

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

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

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

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

应该是权限的哪此的间题,切换到root用户:sudo -s

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

owners.

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

| mysql              |

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

| information_schema |

| information_schema |

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

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

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

Server version: 5.6.27 MySQL Community Server (GPL)

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

6 rows in set (0.00 sec)

mysql> show databases;

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

mysql> show databases;

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

mysql> 

Enter password: