Articles

 can users be assigned privileges to a certain number of mysql databases and a different number of postgresql databases?

No. However, packages allow you to set the maximum number of databases an user can create...

 how can I backup a mysql database?

Run one of the following commands:   /path/to/bin/mysqldump -u $mysqlusername...

 how can I search the databases?

Write what are you looking for in the Search field. Click Go.

 how do I add a user to a mysql database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

 how do I configure a mysql database for remote connection?

Determine the IP address that you will use to connect to the database. Add this IP address to...

 how do I create a mysql database?

Login to cPanel. Locate and click on the "MySQL Databases" icon in the "Databases" category....

 how do I delete a mysql database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

 how do I delete a mysql user?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

 how do I export a mysql database?

Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....

 how do I import a mysql database?

Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....

 how do I remove a mysql user from a database?

Login to cPanel. Locate and click on the "MySQL Databases" icon within the "Databases"...

 I want to use applications directly from my computer to connect to a mysql database which port can I use to connect to database?

You should use port 3306 to connect to MySQL server

 my application is asking for database information - where do I get it?

Nearly all web applications have a database back-end that require a MySQL database. During the...

 what is mysql?

MySQL is a database management system based on SQL – Structured Query Language. The app is used...

 what is phpmyadmin?

phpMyAdmin is a graphical user interface (GUI) used for managing data within a MySQL database....

 when I try to load sql dump, I receive the following: error 2006: mysql server has gone away?

To address this issue, perform the following:   Open the /etc/my.cnf file with your preferred...

 why do I see: error at line 2: unknown command '\_'. when I list mysql databases?

You have MySQL version 4.0.12 which has a bug that causes this error. Upgrade to a later version...

 why does mysql give an access denied error for root@localhost?

To avoid this issue, ensure that the MySQL root password is in the /root/.my.cnf file on the...

 why the mysql version shows a different version in phpinfo than installed on the server?

The API version you see in phpinfo is the built-in MySQL API that is included in PHP. If the...