Ubuntu快速安装并配置MySQL8.0

ubuntu 安装 MySQL8.0

一. 安装MySQL8.0

1.1更新软件包

sudoapt-get update

1.2安装MySQL8.0

sudoapt-getinstall mysql-server-8.0

1.3查看MySQL运行状态

systemctl status mysql.service

二. 配置MySQL8.0

2.1 修改配置文件

sudovim /etc/mysql/mysql.conf.d/mysqld.cnf

注释

#bind-address=127.0.0.1#mysqlx-bind-address=127.0.0.1

添加

character_set_server=utf8

2.2登录MySQL

sudo mysql -u root -p

2.3设置远程登录账号密码

use mysql;# 创建用户
create user 'zhangsan'@'%' identified by '123456';# 授权
GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' WITH GRANT OPTION;# 刷新权限
FLUSH PRIVILEGES;# 退出MySQL>quit
sudoservice mysql restart