To address this issue, perform the following steps:
/etc/my.cnffile with your preferred text editor.
#with a number.
For more information, read the Version 5.5 or Version 5.6 documentation.
3306 to connect to a remote MySQL server.
You can add a database in cPanel's Databases section (Home >> Databases).
To avoid this issue, ensure that the MySQL
root password is in the
/root/.my.cnf file on the
password line. If the MySQL
root password is not in the
/root/.my.cnf file, chose one of the following methods to reset the
Only perform one of the following methods.
In the WHM interface:
Click Change Password.
In the terminal:
tailwatchd daemon and temporarily disable it:
touch /etc/tailwatchddisable killall tailwatchd
Change the MySQL
mysql -u root mysql -e "UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; FLUSH PRIVILEGES;"
Kill all of the server's current MySQL processes:
Restart your MySQL server:
tailwatchddisable file that you created:
No. However, packages allow you to set the maximum number of total databases that a user can create regardless of the type.
For example, if you set the Max Databases option in WHM to
10, users can have any of the following database configurations:
Run any of the following commands:
/path/to/bin/mysqldump -u root -p my_database > my_database_backup.sql
rootuser's password before you back up the
my_databasedatabase to the
/path/to/bin/mysqldump my_database > my_database_backup.sql
~/.my.cnffile to connect before you back up the
my_databasedatabase to the
mysqldump -u $user -p database > backup_file
This command prompts you for the MySQL
root user's password before you back up the
my_database database to the
Use the command line to import data into MySQL. The type and format of the data that you want to import determines how you import it.
To determine the best method, use one of the following MySQL manuals:
To avoid this issue, verify that the
mysqld daemon is functional. If it is, verify that the
mysqld daemon points to the correct Unix socket.
# netstat -ax |grep mysql unix 2 [ ACC ] STREAM LISTENING 362783486 /var/lib/mysql/mysql.sock
If you have one socket and an application points to the other socket, make a symbolic link to point it to the correct socket.
phpinfofile than what is installed on the server?
The API version that you see in the
phpinfo file is the built-in MySQL API that PHP includes.
buildapache application used the MySQL libraries and headers on the server itself, and you change the MySQL version, Apache cannot function correctly. Because cPanel & WHM updates MySQL RPMs whenever Red Hat releases updates, this could automatically break thousands of servers in a matter of a few hours. For this reason, cPanel always builds Apache and PHP with the
Password authentication failed for usererror?
To resolve this issue, ensure that the password is in the
/root/.pgpass file. PostgreSQL passwords use the following format:
If the password is not in the
/root/.pgpass file, you must modify the
To do this, perform the following steps:
touch /etc/tailwatchddisablecommand to disable the
killall tailwatchdcommand to stop all
tailwatchdprocesses on the server.
/var/lib/pgsql/data/pg_hba.conffile to change
/scripts/restartsrv_postgresql restartcommand to restart PostgreSQL.
Run the following commands:
postgres=# alter user postgres with encrypted password =new_pass postgres=# \q
/var/lib/pgsql/data/pg_hba.conffile and change
/scripts/restartsrv_tailwatchdcommand to restart the
Previously, the system stored passwords in the
If you run a remote MySQL host, you will experience little to no impact.
If you only use
MyISAM-formatted databases in MySQL, disable InnoDB to reduce the amount of memory that MySQL uses.
To remove InnoDB support, you must make changes to MySQL and RoundCube. As the
root user, perform the following steps:
/scripts/convert_roundcube_mysql2sqlite accountscript, where
accountis the cPanel account username.)
[mysqld]section of the file:
To confirm that InnoDB is disabled, perform the following steps:
If you cannot access your PostgreSQL databases, reset your cPanel account's password with the Allow MySQL password change option checked.
To reset your account's password, performs the following steps:
Some versions of PostgreSQL are ANSI SQL-92 compliant and do not support recursive grants, wildcard grants, or future grants. To allow multiple users to access your PostgreSQL tables, click Synchronize Grants in the PostgreSQL Databases interface (Home >> Databases >> PostgreSQL Databases) after you add a table.
The maximum number of databases setting represents the number of databases that an account can create of each available type of database. Therefore, if a system administrator sets this value to 5 and allows MySQL and PostgreSQL databases, the account may create up to 5 MySQL databases and up to 5 PostgreSQL databases.