ubuntu系列之安装mysql
下载mysql并安装
- 1
- 2
- 3
- 4
sudo apt-get install mysql-server
注意: 安装过程会提示设置密码什么的,注意设置别忘了
apt-get install mysql-client
sudo apt-get install libmysqlclient-dev
检查安装是否成功
- 1
sudo netstat -tap | grep mysql
登录mysql
- 1
mysql -u root -p
允许远程用户登录到MySQL
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
$ vi /etc/mysql/mysql.conf.d/mysqld.cnf
Change "bind-address = 127.0.0.1" to "#bind-address = 127.0.0.1"
$ service mysql restart
$ mysql -u root -p
$ GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
$ FLUSH PRIVILEGES;
启动mysql
- 1
service mysql start
停止mysql
- 1
service mysql stop
重启mysql
- 1
service mysql restart
有用记得点个赞吧 🌹