安装sql
sudo apt-get install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev
查看是否安装好
sudo lsof -i -P -n | grep LISTEN
打开mysqld.cnf
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1
进入到etc/mysql 目录下,查看debian.cnf文件
用户名:debian-sys-maint
密码:xedvSNKdLavjuEWV
mysql -udebian-sys-maint -pxedvSNKdLavjuEWV
登陆后修改root@localhost 为root@%
grant all on *.* to root@'%' with grant option;
flush privileges;
然后执行quit命令退出mysql服务,执行如下命令重启mysql:
sudo service mysql restart