Can I connect to MySQL remotely?

Yes, you can connect to your MySQL database remotely using a client such as MySQL-Front at http://www.mysqlfront.de or MySQL Administrator at http://dev.mysql.com/downloads/administrator/

Please remember to enter your own IP address or % for a wildcard in the Access Hosts area in Cpanel's MySQL databases.

Additionally, you must create a database as well as a user and then add the user to the database prior to establishing a connection. Your database name and username will be Cpanelusername_databasename and Cpanelusername_databaseuser respectively. The password will be the password for the user you created. The hostname should be your domain name. The port is 3306

  • 0 کاربر این را مفید یافتند
آیا این پاسخ به شما کمک کرد؟

مقالات مربوطه

Can I backup my MySQL database? How do I backup my database?

You can backup your database two ways. 1. Click on Backup in Cpanel then click on the database...

How do I export and import a mysql db using PHPMyAdmin?

Step 1: Open phpMyAdmin and select the database from where you want to export data and/or...

How do I rename a table in phpMyAdmin?

Here is a step-by-step for renaming a table: 1. Log into cPanel 2. Click on "MySQL Databases"...

Does your MySQL server support extended character sets, foreign character sets, and collation sets?

In the control panel's left-hand side of the page, there should be a MySQL version for your...

Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...