Mysql8.0 安装及配置指南-linux版

环境Ubuntu 20.04

下载安装MySQL

#自动同步下载:
#mysql-client-8.0 mysql-client-core-8.0 mysql-server-8.0 mysql-server-core-8.0
$ sudo apt install mysql-server

修改root密码

# 第一次登录 in bash
$ sudo mysql -u root
# 进入mysql
> use mysql;
#修改密码
> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your password'

增加用户

# in mysql bash
>use mysql;
# 创建用户
>create user 'someone'@'host' identified with mysql_native_password by 'yourpassword'

用户授权

# 授权
# grant privileges on databasename.tablename to 'someone'@'host' [with grant option];
# privileges: 用户权限, 如 SELECT,INSERT,UPDATE等,所有授权ALL.
#databasename: 数据库名
#tablename: 表名. 所有数据库,可以用*,如*.*
# with grant option 该用户是否授权
> GRANT select,insert,update,delete,create,drop ON mysql.user TO 'test'@'192.168.204.1';
> GRANT ALL ON *.* TO 'test'@'192.168.204.1';
# 刷新
> flush privileges;

删除用户

> drop user 'hive'@'127.0.0.1';