MySQL|【MySQL】mysql常用命令数据库|服务器|mysql

mysql默认端口3306
服务器登录

mysql -uroot -p

输入密码登录

[mysql@yyq mysql]# mysql -uroot -p Enter password: Welcome to the MySQL monitor.Commands end with ; or \g. Your MySQL connection id is 73 Server version: 8.0.28-commercial MySQL Enterprise Server - CommercialCopyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is 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>

查看数据库列表

show databases;

mysql> show databases; +--------------------+ | Database| +--------------------+ | mysql| | sys| +--------------------+ 2 rows in set (0.01 sec)mysql>

切换数据库

use mysql

mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -ADatabase changed mysql>

查看所有表

show tables;

mysql> show tables; +--------------------+ | Tables_in_ibase| +--------------------+ | a_group| | a_info| | a_log| | a_report| +--------------------+ 4 rows in set (0.00 sec)mysql>

sql文件导入无需指定数据库，初始化导入
123456是密码，init_schema.sql是导入的文件，./指当前目录下

mysql -uroot -p123456 < ./init_schema.sql

指定数据库导入
123456是密码，yyqdb是导入的数据库，yyqdb.sql为导入的文件

mysql -uroot -p123456 yyqdb < ./yyqdb.sql

数据库下导入

source ./yyqdb.sql

需要先登录数据库，然后source

[mysql@yyq mysql]# mysql -uroot -p Enter password: Welcome to the MySQL monitor.Commands end with ; or \g. Your MySQL connection id is 73 Server version: 8.0.28-commercial MySQL Enterprise Server - CommercialCopyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is 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> use yyqdb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -ADatabase changed mysql> source ./yyqdb.sqlQuery OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql>

退出 【MySQL|【MySQL】mysql常用命令】quit与exit均可