Please login to your control panel and follow these steps to create the database, user and its password: Once you login into your control panel, please click on "MySQL Databases" under "Database" section and then a) Use the option "Create MySQL database" to create the database, say "dbname". The...

Yes! it is possible. For this you have to allow remote access from your control panel, by adding your IP to the access hosts in mysql screen there. If you do not have a fix IP at your end you can use % as wild card and allow remote access from anywhere. Then for remote connection you have to use the server IP or your domain IP or

If you get this error message when trying to use mysql command line utility from shell: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' It means you need to access the mysql using -h 127.0.0.1 e.g. mysql -h 127.0.0.1 -u yourdbuser -p yourdatabase If you get this error message from a web script, please...

There are two main ways to back up or restore a MySQL database on our servers: via SSH or the phpMyAdmin interface. If you need SSH Telnet access, just send us a ticket with your request to be enabled for it. To access the phpMyAdmin interface, click on the "phpMyAdmin" on your control panel. How create a backup a MySQL...

All administration of your MySQL databases and users can be done through our convenient web based control panel interface. This program is provided to all of our hosting customers.

This feature is not supported by cpanel but you can ask support to add File_priv to your db user that needs to import csv files. After that you can use this format on mysql command line utility via ssh: LOAD DATA LOCAL INFILE 'upload.txt' INTO TABLE mydatabase.mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n'

MySQL is a very robust database server. It is often used to deliver dynamic content to sites such as forums. The languages most often used to interface with the database server are Perl and PHP, however, C, C++, and Python among others may also be used. The official MySQL Web site may be found at:

On our shared/sdx/reseller server, we have setup 4.1.x which is the most popular version and is supported by most web applications. Unfortunately we can not upgrade this to 5.x as this will break a lot of customer's websites. However if you need to use newer version i.e. 5.x, you can get a VPS or Dedicated Server and we can install it for you...