Sunday 15 December 2013

MySQL database not appearing in cPanel but exists in the server

If a database exists but is not displayed in cPanel it likely is not being tracked by the db mapping system.

Check to see if database is listed in user.yaml by running the following command:
#cat /var/cpanel/databases/user.yaml 

If the result is as follows : 
No databases tracked:
root@server [~]# cat /var/cpanel/databases/tacct.yaml
---
MYSQL:
dbs: {}
dbusers: {}

Follow the below steps : 

To map missing databases and users run the following:

#/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql --databasename

#/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql –databaseuser

#/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql –databasename cpanelusername_databaseuser

After the above steps are executed check with the following command if the database has been mapped in the db mapping system.
#cat /var/cpanel/databases/abc.yaml
The result should be as follows : 
---
MYSQL:
dbs:
tacct_testdb: IP Address
dbusers: {}
owner: tacct
server: IP Address

No comments:

Post a Comment

ERR_CONTENT_DECODING_FAILED

If you are getting the error as ERR_CONTENT_DECODING_FAILED while accessing the domain then add the below extension in php.ini  ++++++++...