Configure the remote access permission for mysql ~, Mysql Remote Access

Configure the remote access permission for mysql ~, Mysql Remote Access

 

1 InternetTechnical practitioners, or roughly speaking: as a programmer, TestIf practitioners do not fall into some pitfalls, they are embarrassed to say that they have been involved in the technical circle. 2 today's focus: MysqlEnable the pitfalls of Remote Access Permissions ~ For mysql to enable remote access ArticleI will focus on the following: BaiduSearch for "mysql Remote Access" and you can see many articles you need-body-3 after installing mysql, you must first enable remote access. Otherwise, every time you perform operations on the mysql server ~ In addition, remote access is disabled, and the program cannot be accessed (normally: Application Server & DatabaseThe server will be deployed separately) 4. There are several ways to enable the access permission: -- modify Database Table update -- grant Method 5 many users often fail to access the database remotely After configuring the database according to the online tutorial. 6 common problems are as follows, you must refresh the permission flush privileges -- firewall not disabled -- configuration file my. cnf hasn't been modified-Write it at the end-What else have you fallen ~ Welcome to supplement and exchange