Ubuntu中,安装MySQL
1.sudo apt-get install mysql-server
2.sudo apt install mysql-client
3.sudo apt install libmysqlclient-dev
4.查看是否安装成功:sudo netstat -tap | grep mysql
5.设置mysql允许远程访问
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉:bind-address = 127.0.0.1
然后ESC,:wq保存退出
6.进入MySQL,设置密码
mysql -u too -p 没有密码,直接回车
设置密码:set password for 'root'@'localhost' = password('123456');
退出:exit
7.重新登录,然后授权任何用户都可以连接数据库-->刷新,--->退出
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新:flush privileges;
8.重启MySQL并查看状态:
service mysql restart
service mysql status
9.Navicat连接数据库
10.看本地项目连接数据库,启动报不报错