[Ubuntu MySQL安装] #在Ubuntu上安装MySQL并可以远程访问 #mysql
在Ubuntu上安装MySQL并设置可以远程访问
sudo apt-get install mysql-server
sudo apt-get install mysql-client #可选
sudo apt-get install libmysqlclient-dev #可选
sudo netstat -tap | grep mysql
打开数据库:
mysql -u root -p 123456
PS:如果在安装的过程中没有出现设置密码的界面的需要先设置密码:
sudo mysql
set password for 'root'@'localhost'=password('123456')
mysql -u root -p 123456
进入mysql后进行授权:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
在mysql中刷新授权:
flush privileges;
退出mysql,并重启mysql
sudo service mysql restart
sudo ufw allow 3306