# ubuntu安装MySQL
# 下载安装
wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
# 更新数据源
sudo apt-get update
# 安装mysql
sudo apt-get install mysql-server mysql-client
1
2
3
4
5
2
3
4
5
# 安装后配置
# 用debian.cnf里面的用户名和密码来登录
sudo cat /etc/mysql/debian.cnf
1
2
2
# 登录数据库
mysql -u root -p
# 切换到mysql默认配置库
use mysql;
# 更新mysql root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'sunbt666';
# 刷新配置
FLUSH PRIVILEGES;
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
# 重启MySQL
sudo service mysql restart
# 使用新密码登录
mysql -u root -p
1
2
3
4
2
3
4
# MySQL设置远程访问
# 选择数据库
use mysql
# 查询用户访问情况
select Host,User from user;
# 设置root用远程访问
update user set Host='%' where User='root';
# 刷新配置
FLUSH PRIVILEGES;
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
# 修改MySQL的配置文件
默认安装位置
/etc/mysql/mysql.conf.d/mysqld.cnf
1
因为默认3306端口只允许本地访问的，注释掉这行
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
1
2
3
4
2
3
4
然后重启MySQL
service mysql restart
1
