Ubuntu快速安装并配置MySQL8.0_ubuntu安装mysql8.0

一. 安装MySQL8.0

1.1更新软件包

sudo apt-get update
1

1.2安装MySQL8.0

sudo apt-get install mysql-server-8.0
1

1.3查看MySQL运行状态

systemctl status mysql.service
1

二. 配置MySQL8.0

2.1 修改配置文件

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
1

注释

#bind-address=127.0.0.1
#mysqlx-bind-address=127.0.0.1
1
2

添加

character_set_server=utf8
1

2.2登录MySQL

sudo mysql -u root -p
1

2.3设置远程登录账号密码

use mysql;
# 创建用户
create user 'zhangsan'@'%' identified by '123456';
# 授权
GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' WITH GRANT OPTION;
# 刷新权限
FLUSH PRIVILEGES;
# 退出MySQL
>quit
sudo service mysql restart
1
2
3
4
5
6
7
8
9
10