WHM & CPANEL 11 Remote MySQL and Backup

[cpanelkenneth]

To izmirhost:

Make certain your SQL statement is:

GRANT ALL PRIVILEGES on *.* to root@host1 IDENTIFIED BY 'password' WITH GRANT OPTION;

and not

ALL PRIVILEGES on *.* to root@host1 IDENTIFIED BY 'password' WITH GRANT OPTION;

as you specified in your post. Also, I assume you are replace the generics I used in the statement with values specific to your setup.

cPanel 12 will have much improved support for clustering in general. The features and design are still being hammered out and likely won't receive full attention until EA3 reaches the Stable branch. However, one thing that is already known is removing the current MySQL database naming convention, since this is a current stumbling block to 'real' clustering. the how is not know, only that it must happen.

[fifawe]

do I have to tell my customer to modify their configuration files to user db_ip instead of localhost?

[fifawe]

I have already added Remote MySQL server, but I'm facing a lot of
problems.
I need your advice to solve these problems.

1- I can't open PhpMyAdmin from WHM it said "Wrong username/password.
Access denied."

2- my users can't see their DB from "MySQL Databases" but they still
can manage it from PhpMyAdmin.

3- cpanel can't count the number of Db's that user is already using
"0/x" although php is showing 1 or more DB.

4-Error in Fantastico "Fantastico is unable to connect to your MySQL
server at this time. Please contact your host for assistance".

5-the server keep sending the following message
mysql failed @ Sun May 18 15:30:00 2008. A restart was attempted automatically

6- every time I added the configuration of my remote sql server it works fine for about 15-30min then the configuration disappears
and I have to add it again to make the server work.

[cPanelDavidG]

Originally Posted by fifawe

I have already added Remote MySQL server, but I'm facing a lot of
problems.
I need your advice to solve these problems.

1- I can't open PhpMyAdmin from WHM it said "Wrong username/password.
Access denied."

2- my users can't see their DB from "MySQL Databases" but they still
can manage it from PhpMyAdmin.

3- cpanel can't count the number of Db's that user is already using
"0/x" although php is showing 1 or more DB.

4-Error in Fantastico "Fantastico is unable to connect to your MySQL
server at this time. Please contact your host for assistance".

5-the server keep sending the following message
mysql failed @ Sun May 18 15:30:00 2008. A restart was attempted automatically

6- every time I added the configuration of my remote sql server it works fine for about 15-30min then the configuration disappears
and I have to add it again to make the server work.

I recommend submitting a support ticket: http://tickets.cpanel.net/submit