Yes, you can connect to your MySQL database remotely. Remember to enter the IP address or hostname of the remote machine connecting, to the access hosts list in the MySQL manager in cPanel. The default MySQL port is 3306.

Here are a few initial things (common mistakes) to take a look at: - Make sure that after you created your database and database user that you didn't forget to ADD the database user to the database (at the bottom of the "Databases" section in Control Pan...

Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. 1. Connect to the MySQL server Use the following statement to connect to the database server. Substitute the username, and password for ones who have ...

Use the following outline to connect and begin querying the MySQL server from a SSH session. 1. Connect To The MySQL Server bash$ mysql -u USERNAME -p Enter Password: PASSWORD 2. Connect To The Database bash$ use DATABASENAME; 3. Receving Help bash...

How to back up a mySQL database using phpMyAdmin: You can backup your database using the PHPMyAdmin feature in your control panel. In PHPMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wi...

To create a mysql database, log into your cPpanel and select the 'MySQL Databases' link. Enter in the name of the database you want to create and submit it. Once you have created a database you must create a database user and then grant that user acces...

****Must have SSH Access on your account**** In Telnet/Shell type: "mysql" This will load the mysql command line. Next type: GRANT ALL PRIVILEGES ON [database].* TO [username]@[domain] IDENTIFIED B '[password]'; (where "[database]" is the database you...

****Must have SSH Access on your account**** If you need SSH access, it is only available on Professional, Corporate, or Premium accounts and you must open a support ticket with a request to enable SSH. Remember to include a qualified reason of why you r...

MySQL databases are not like regular files, so rather than being placed into a directory like regular files, they must be imported into mysql via valid SQL files. Most backups of databases use utilities such as mysqldump to generate a SQL insert statemen...

MySQL has a feature that allows you to log slow running queries to a file. To enable you just need to add some lines to your my.cnf file, and restart. Add the following: log-slow-queries = /var/log/mysql/mysql-slow.log long_query_time = 1 The above w...

DROP – This feature is used to remove a table and its contents from the database. The structure and the data is deleted or dropped permanently and can only be restored using a backup dump file, if exists. DUMP – This feature is used to create a backu...

3306 is the default mysql port.

Always use 'localhost' whenever asked.