Linux下操作MySQL数据库

//开启MySQL服务

[root@************ ~]# service mysqld start 

Starting MySQL                                             [  OK  ]
[root@************ ~]# 2017-12-21T03:08:21.201104Z mysqld_safe A mysqld process already exists

[root@************ ~]# cd /usr/local/
[root@************ local]# cd mysql/

[root@************ mysql]# cd bin/

//输入用户名及密码登录MySQL

[root@************ bin]# ./mysql -uroot -p123456   
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.7.19 MySQL Community Server (GPL)

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

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> create database db_jwkj;
Query OK, 1 row affected (0.00 sec)

//使用某个文件下导入的数据库

mysql> use db_jwkj

Database changed

//导入数据

mysql> source /root/db_jwkj.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected, 1 warning (0.00 sec)

Database changed
Query OK, 0 rows affected (0.02 sec)

Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.03 sec)

Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)

Query OK, 96 rows affected (0.01 sec)
Records: 96  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 12 rows affected (0.00 sec)
Records: 12  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.06 sec)

Query OK, 16 rows affected (0.01 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 7 rows affected (0.00 sec)
Records: 7  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.06 sec)

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 19 rows affected (0.06 sec)
Records: 19  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.06 sec)

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

//导入后查看生成的数据表

mysql> show tables;
+----------------------+
| Tables_in_db_jwkj    |
+----------------------+
| tb_auth_group        |
| tb_auth_group_access |
| tb_auth_rule         |
| tb_banner            |
| tb_img               |
| tb_log               |
| tb_menu              |
| tb_message           |
| tb_navimg            |
| tb_newsarticle       |
| tb_newsclassify      |
| tb_newsimage         |
| tb_users             |
+----------------------+
13 rows in set (0.01 sec)

//退出MySQL

mysql> quit

Bye

附加：删除数据库（drop database db_jwkj;）