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

有用记得点个赞吧 🌹

本文于 2018/3/23 上午 发布在 编程 分类下,当前已被围观 2202 次

相关标签:ubuntumysql

永久地址:https://blog.pandashuai.com/article/11