Ubuntu16.04中MySQL安装配置

1、安装mysql

root@ubuntu:~# sudo apt-get install mysql-server 1 1 root@ubuntu:~# apt install mysql-client 1 1 root@ubuntu:~# apt install libmysqlclient-dev 1 1

期间会弹出设置root账户的密码框，输入两次相同密码。

---

2、查询是否安装成功 root@ubuntu:~# sudo netstat -tap | grep mysql 1 1 root@ubuntu:~# netstat -tap | grep mysql tcp6 0 0 [::]:mysql [::]:* LISTEN 7510/mysqld 123 123

---

3、开启远程访问mysql

编辑mysql配置文件，注释掉“bind-address = 127.0.0.1” root@ubuntu:~# vi /etc/mysql/mysql.conf.d/mysqld.cnf 1 1 #bind-address = 127.0.0.1 1 1 进入mysql root账户 root@ubuntu:~# mysql -u root -p123456 1 1 在mysql环境中输入grant all on . to username@’%’ identified by ‘password’;或者grant all on . to username@’%’ identified by ‘password’ with grand option; root@ubuntu:~# grant all on *.* to xxx@'%' identified by '123456'; 1 1 刷新flush privileges;然后重启mysql，通过/etc/init.d/mysql restart命令 root@ubuntu:~# flush privileges; 1 1 root@ubuntu:~# /etc/init.d/mysql restart 1 1 远程连接时客户端设置：

---

4、常见问题

1045 access denied for user ‘root’@’localhost(ip)’ using password yes 1、mysql -u root -p; 2、GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 3、FLUSH PRIVILEGES;