1.下载安装:(可视化的安装)
sudo apt-get install mysql-server
2.自己设置用户和密码:
3.给root授予在任意主机(%)访问任意数据库的所有权限。SQL语句如下:
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
4.进入到这个目录:
vim /etc/mysql/mysql.conf.d/mysqld.cnf
5.在末尾添加这句:(OK了)
skip-grant-tables