# 数据库SQL

# 创建数据库

mysql> CREATE DATABASE menagerie;

# 切换数据库

mysql> USE menagerie
Database changed

1
2

# 登录到指定的数据库

shell> mysql -h host -u user -p menagerie
Enter password: ********

1
2

# 查看数据库

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| leichu             |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.02 sec)

1
2
3
4
5
6
7
8
9
10
11

# 查看数据库的数据保存在哪个目录下

mysql> SHOW VARIABLES LIKE 'datadir%'
    -> ;
+---------------+---------------------------------------+
| Variable_name | Value                                 |
+---------------+---------------------------------------+
| datadir       | E:\database\mysql-5.7.28-winx64\data\ |
+---------------+---------------------------------------+
1 row in set (0.02 sec)

1
2
3
4
5
6
7
8

# 为root 用户添加远程访问权限

-- % 代表任意地址，也可以指定特定ip地址
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by '密码' with grant option;
FLUSH PRIVILEGES;
show grants for root@'%';

1
2
3
4

← 常用SQL 数据表SQL →