先看看乌班图中有没有mysql数据库
sudo apt search mysql | grep ^mysql
安装mysql
sudo apt install -y mysql-server
启动mysql
sudo systemctl status mysql.service
寻找mysql密码
vim /etc/mysql/debian.cnf
在里面找到user和password的值后输入([user和pass里面的数值])
mysql -u [user] -p [passwd]
之后进入mysql后运行
show databases;
use mysql;
update user set authentication_string=PASSWORD("自定义密码") where user='root';
update user set plugin="mysql_native_password";
flush privileges;
quit;
重启mysql
/etc/init.d/mysql restart;
改允许远程访问
cd /etc/mysql/mysql.conf.d/
vi mysqld.cnf
找到bind-address = 127.0.0.1
选择注释 或者ip改成0.0.0.0
esc+wq
重启mysql
sudo systemctl restart mysql.service