- 查看有没有安装MySQL:
dpkg -l | grep mysql
- 安装MySQL:
sudo apt install mysql-server
- 安装完成之后可以使用如下命令来检查是否安装成功,如果看到有 mysql 的socket处于 LISTEN 状态则表示安装成功:
netstat -tap | grep mysql
- 重点:找到ubuntu安装mysql时默认生成的默认账户用户名密码,去登录mysql:
sudo cat /etc/mysql/debian.cnf
5. 用上边查到的用户名密码进行登录
6. 接下来进行修改密码的操作:
use mysql;
update user set authentication_string=PASSWORD("你设置的新密码") where user='root' and Host ='localhost';
update user set plugin="mysql_native_password";
- 设置mysql远程访问的权限
select user,Host from user;
update user set Host='%' where user='root';
select user,Host from user;
grant all privileges on *.* to 'root'@'%' identified by '你设置的新密码' with grant option;
flush privileges;
exit
- 退出mysql后去重启mysql服务,然后用root和新密码去登录mysql:
sudo systemctl restart mysql.service
mysql -uroot -p
但此时去用Navicat去连接mysql,显示如下:
61 "Connection refused"
- 修改ubuntu上mysql配置文件
cd /etc/mysql/mysql.conf.d
sudo vim mysqld.cnf
找到:bind-address = 127.0.0.1
改为:bind-address = 0.0.0.0
:wq保存后出来重启mysql
sudo systemctl restart mysql.service
此时远程连接成功: