remote databases are not shown in phpmyadmin

behinam

• November 26, 2017 10:06

Hi, I have set WHM to connect to a remote mysql server. here's the /root/.my.cnf of the cPanel server: [client] user=root password="xxxxxx" port=3306 host=dbs When I restore a backup the databases are created properly and I can see them in phpmyadmin. But when I login to cPanel directly and create a new database I cannot see it in phpmyadmin while it is shown in Mysql Databases. If I go to the cPanel account from WHM I can see the database in phpmyadmin. I think one more GRANT query should be run in mysql for the user. Because when I run the following query the problem is solved. grant all on database_name.* to cpanel_user@'cpanel_server_ip' identified by 'xxxx'; flush privileges; I believe that the last queries seems to be run automatically by cPanel while creating a new database. Any help is appreciated.

• 

  cPanelMichael

  • November 29, 2017 17:02

  I have set WHM to connect to a remote mysql server.

  
  Hello, Can you verify that you used "WHM >> Home >> SQL Services >> Manage MySQL Profiles" when setting up the remote MySQL server? If so, could you let us know which version of cPanel is installed on this server? Thank you.

  0
• 

  behinam

  • December 02, 2017 09:36

  Yes i attache MySQL Profiles setting image my cPanel & WHM version is 64.0 Hello any idea? :confused:

  0
• 

  cPanelMichael

  • December 04, 2017 15:30

  Hello, Could you open a support ticket using the link in my signature so we can take a closer look? Note that cPanel 64 is at end-of-life status so it's a good idea to first update to a supported version (cPanel 68) to determine if the issue persists. Thank you.

  0

Please sign in to leave a comment.