There are two scenarios: 1, MySQL does not assign access to the format:grant permissions on database name. Table name user @ Login host identified by user password; Grant select,update,insert,delete on *.* to [email protected] '% ' identified by ' 123456 '; or all rights grant all privileges on *.* to [email Protected] '% ' IDENTIFIED BY ' 123456 '; then execute flush privileges; make authorization effective Finally we need to modify the MySQL configuration file sudo vim /etc/mysql/my. cnf 2, the My.ini configuration does not turn on the network access feature found in the previous version skip-networking, just comment it out. #skip-networking in the new version:# instead of skip-networking The default is now to listen only on# localhost which is more compatible and is not less secure. Find :bind-address = 127.0.0.1 this line to comment out #bind-address = 127.0.0.1
cannot be accessed outside the MySQL database