Shulou(Shulou.com)06/01 Report--

The following talk about wdcp to open a MySQL database to achieve remote access simple method, the secret of the text is close to the topic related. So, gossip will not talk about it, we look directly at the following bar, I believe that after reading wdcp open a MySQL database to achieve remote access simple method this article you will certainly benefit.

Log in-Mysql admin-phpmyadmin

Enter Mysql root password to log in

Example code:

update mysql.user set host='%' where user='west263 test';#Note that west263 test needs to be modified to its own database user name before execution

update mysql.db set host='%' where user='west263 test';#Note before execution that west263 test needs to be modified to its own database user name

flush privileges; #This is very important to refresh MySQL's system privileges related table, otherwise access will be denied

After clicking the Execute button, test remotely via the client tool.

For the above wdcp to open a MySQL database to achieve remote access simple method related content, we still do not understand anything? Or if you want to know more about it, you can continue to pay attention to our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.