Ubuntu：安装MySQL

Ubuntu：安装MySQL

1. *更换源

Ubuntu更换源

2. 安装mysql

sudo apt-get install mysql-server -y

3. 检查是否安装成功

1) 安装netstat

sudo apt-get install net-tools

2) 检查是否安装成功

netstat -tap | grep mysql

备注：如果在使用netstat 命令时出现以下错误：

(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)

解决：

# 切换root用户
sudo su
# 修改权限
chmod +s /bin/netstat

4. 登录mysql

# 默认没有密码，直接Enter即可
sudo mysql -u root -p

5.查看用户

select user, plugin from mysql.user;

6. 重置root密码

# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourPassword';
# 刷新权限
flush privileges;
# 退出
exit

7. 配置远程访问mysql

# 进入mysql数据库，然后进入数据库“mysql”
mysql -u root -p
use mysql
# 查询user表中的user和host信息
select user, host from user;

可以看到以下信息

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+

将root的host修改为%

update user set host='%' where user='root';

开启远程访问权限可以使用赋权操作

# 使用赋权操作：
grant all on *.* to 'root'@'%';

8. 重启mysql服务

# 重启mysql
sudo systemctl restart mysql
# 查看mysql状态
sudo systemctl status mysql