1.  数据库安装

sudo apt update
sudo apt install mysql-server

2. 查询服务状态

sudo systemctl status mysql

3. 数据库初始化配置

sudo mysql_secure_installation

4.  以root身份登录

sudo mysql -uroot -p

5.  进到数据库后查询所有用户

use mysql;
select * from user;

6. 创建数据库

create database xxx;

7. 创建用户

CREATE USER 'james'@'localhost' IDENTIFIED BY 'tiger';

8. 给用户赋权限

grant all on mydatabase.* to 'james'@'localhost';
grant select,update,delete,create,drop on mydatabase to 'james'@'localhost';

9. 刷新使权限生效

flush privileges;

10. 切换用户看看权限是否生效

exit;

sudo mysql -ujames -p

use xxx;
create table table1(id int);
insert into table1(id) values(1);
select * from table1;
update table1 set id = 2 where id = 1;
select * from table1;
drop table table1;

11.  修改配置文件，使mysql监听外部ip端口

配置文件在 /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address            = 127.0.0.1

修改为

bind-address            = 0.0.0.0

重启mysql

systemctl restart mysql

(这块没测试)