The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.

Articles

Can users be assigned privileges to a certain number of MySQL databases and a different number of PostgreSQL databases? You can set the maximum number of total databases that user can create with packages, as well as... Views: 96

How can I backup a mysql database? Rune either of the following commands: /path/to/bin/mysqldump -u $mysqlusername... Views: 113

How do I configure a MySQL database for remote connection? You will need to add the IP address from which you wish to connect to the databse in the Remote... Views: 123

How do I create a new database in SQL? You will need to use the Databases section and add a database under PostgreSQL Databases or MySQL... Views: 102

How do I import data into MySQL? You will need to import data from the command line into MySQL. The way you will do this depends... Views: 95

How does running a remote MySQL host impact MySQL services? Using a remote MySQL? setup, will be functionally the same a using a local setup. Since you are... Views: 83

Mysql gives error of access denied for root@localhost? Make sure root pass is in /root/.my.cnf. This is usually the first root pass the box was given... Views: 100

Postgres gives an error of 'Password authentication failed for user. Make sure the password is in /var/lib/pgsql/.pgpass The format is as follows:... Views: 127

The mysql version displays a different version in phpinfo that what is installed on the server. The API version you see in phpinfo is the builtin mysql api included in php. If the buildapache... Views: 80

When trying to load a large SQL dump, I get ERROR 2006: MySQL Server has gone away. To begin, visit http://www.mysql.com/doc/en/Gone_away.html Most likely, you will need to... Views: 90

Which port can I use to connect to a MySQL database with some programs directly from my computer? Port 3306 can be used for remote MySQL connections. You will need to configure access in the... Views: 100

Why do I get this MySQL error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0? You should check that mysqld is running first of all. If it is, check to see that it's looking... Views: 97

Powered by WHMCompleteSolution