installing MySQL in ubuntu16.10

1. Install MySQL:

[Email protected]:~# sudo apt-get install mysql-server[email protected]:~# apt isntall mysql-client[email protected]:~# A PT Install Libmysqlclient-dev

2. Turn on remote access:

Edit the configuration file for MySQL: root@ubuntu: ~# vi/etc/mysql/mysql.conf.d/mysqld.cnf, find bind-address = 127.0.0.1 line, comment on the line

Enter Mysql:root@ubuntu: ~# mysql-u root-p123456

In MySQL, execute the following command:

Grant all on * * to [email protected]'%'123456'; flush privileges;

Exit Mysql:exit;

Finally, restart MySQL in the terminal:

[Email protected]:~#/etc/init.d/mysql Restart

installing MySQL in ubuntu16.10