Ubuntu:安装MySQL
1. *更换源
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