GA_googleFillSlot("THN-ARTICLE-Automation");
Web Hosting Automation content is sponsored by: cPanel
MySQL is a relational database management system open source among the most popular on the web. Typically, web hosting users accessing MySQL via a web-based control panel or through a free web application, such as phpMyAdmin. More advanced users can also manage MySQL from the command line via SSH.
The third option for MySQL management is remote administration. With this method, You can access MySQL from software on the remote computer. Some web development tool includes options for remote administration, MySQL and MySQL Workbench also provides this functionality. Another reason to allow a remote host to access the MySQL is when You have a web server on a different IP address from your database server.
By default, the remote machine is not allowed to access MySQL. This is a security measure. If computers are not on localhost tried to access it, your computer will be denied. Fortunately, cPanel makes it easy to add to the list of trusted hosts MySQL administrator accepted. Follow these instructions:
In addition to a full IP addresses, You can also use wildcards. For example: 192.68.0.%. All IP addresses that match a wildcard which will be allowed, so be careful with it. Also, if you try to access from home and have a dynamic IP address, You will need to change these settings each time you change your IP address. In addition, if You access the database from a web site on a shared hosting account, it can share IP addresses to other sites. In this case, use the domain name.