mantis apache mysql_Linux系统下搭建MantisBT环境以及Apache+PHP+MySql的安装

[root~]# mysql

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

Your MySQL connection idis 3153Server version:5.7.19MySQL Community Server (GPL)

Copyright (c)2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

mysql>

查看有哪些数据库：

mysql>show databases;+--------------------+

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sys |

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

5 rows in set (0.02sec)

mysql>mysql>

切换数据库：

mysql>use mysql;

Database changed

mysql>mysql>

查看某个数据库中的所有表：

mysql>show tables;+---------------------------+

| Tables_in_mysql |

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

| columns_priv |

| db |

| engine_cost |

| event |

| time_zone_transition_type |

| user |.......+---------------------------+

31 rows in set (0.00sec)

mysql>

如果此时想远程连接该数据库的话，还不行。需要改一点数据：

mysql> select Host,user from user where user='root';+----------+