MySQL安装和步骤

发表于 | 分类于

1 MySQL 安装

1.1 下载MySQL YUM包

1
# wget http://repo.mysql.com/mysql80-community-release-el7-10.noarch.rpm

1.2 安装软件源

1
# sudo rpm -Uvh mysql80-community-release-el6-n.noarch.rpm

1.3 安装MySQL

1
# sudo yum install mysql-community-server

1.4 MySQL服务管理

1
2
3
4
5
6
7
8
//启动服务
# sudo service mysqld start

//重启服务
# sudo service mysqld restart

//查看服务
# sudo service mysqld status

2 配置MySQL

2.1 生成临时密码

1
# sudo grep 'temporary password' /var/log/mysqld.log

2.2 登录MySQL

1
2
3
4
5
//登录
# mysql -uroot -p

//修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

2.3 用户管理

1
2
3
4
5
6
7
8
9
10
11
12
13
14
//创建用户
mysql> CREATE USER username IDENTIFIED BY 'password';

//分配权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password';

//管理权限
mysql> EVOKE ALL PRIVILEGES ON *.* FROM 'username'@'%';
mysql> GRANT ALL PRIVILEGES ON wordpress.* TO 'username'@'%' IDENTIFIED BY 'password';

mysql> GRANT SELECT, UPDATE ON wordpress.* TO 'username'@'%' IDENTIFIED BY 'password';

//刷新权限
mysql> FLUSH PRIVILEGES;

2.4 开启远程连接

1
2
3
4
5
mysql> USE mysql;

mysql> ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

mysql> FLUSH PRIVILEGES;

重点: 创建用户格式有‘username‘@’%’、‘username‘@’localhost’，其中%可以允许用户远程连接，localhost则不行。

3 常见指令

1
2
3
4
5
mysql> show databases;

mysql> use database;

mysql> show tables;