Install mysql under Ubuntu 16.04
System information (lsb_release -a)
Distributor ID: Ubuntu
Description: Ubuntu 16.04.2 LTS
Release: 16.04
Codename: xenial
- Check whether it is installed:
sudo netstat -tap | grep mysql - Install mysql:
sudo apt-get install mysql-server mysql-client//server + client - Y - Enter password - Confirm password
- Start the mysql service:
sudo service mysql start - Test whether the installation is successful:
sudo netstat -tap | grep mysql - Local connection:
mysql -u root -ptype the password
Remote access settings##
1. Binding wildcard address 0.0.0.0
Necessary steps. If there is an error mysql.service failed because the control process exited with error code, check whether the path is correct. The paths of some articles seem to be different, maybe the system/version is different
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnfmodifybind-address=127.0.0.1tobind-address=0.0.0.0- Restart mysql service
sudo service mysql restart
Demonstration of bug fixes (I already did the second step when recording the gif)
2. Modify the client IP that can be connected remotely
- Query whether the host value of the root user is correct (host column is the ip specified for login)
select user, host from user where user='root'; - Modify host to
'%',%in the host column is a wildcard. After modifying to%, all IPs can be accessed. You can also specify the IP segment like this:192.168.1.% flush privileges;//Refresh MySQL system privilege related tables
Error repair demo
If it is not set, an error message will be displayed: 1103 -Host '192.168.1.233' is not allowed to connect to this MySQL server
Related
Client tool navicat download###
Download link: http://pan.baidu.com/s/1qXKpZgK
. Net connection mysql connection string###
Server=192.168.1.233;Database=testdb;Uid=root;Pwd=123456;charset=utf8;pooling=true;
Recommended Posts