How to connect to a MySQL server?

Auto Backup for MySQL Standard Edition SwordSky Software http://www.swordsky.com Return to Content

Auto Backup for MySQL connect to a MySQL server via TCP/IP protocol.

Please use the MySQL host name or IP address, MySQL server port, MySQL username and password to connect to your MySQL server.

If you connect to the local MySQL server on your computer, the MySQL host name is "localhost" or "127.0.0.1", the default port is 3306.

If you connect to the remote MySQL server on your Internet web hosting or the virtual hosting, the MySQL host name is the domain name or IP address of your hosting, and the default port is 3306.

Please grant your MySQL user to access your remote MySQL database at anywhere or
your computer, for example:

If you use the CPanel, please add a host as '%' for MySQL user login.

If you use the phpMyAdmin, please grant the user login at % or your computer IP address.

If you use the MySQL command line, please execute the MySQL command below:

GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'%' IDENTIFIED BY 'your_password';

If you do not have right to grant the MySQL user, please contact your hosting Administrator to solve the problem.



Product Information

Web Site: http://www.swordsky.com

Support E-mail: support@swordsky.com

Purchase the software on-line at: http://www.swordsky.com/purchase.html