Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 19 of 19
  1. #16
    cPanel Development cpanelkenneth's Avatar
    Join Date
    Apr 2006
    Posts
    3,768
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    To izmirhost:

    Make certain your SQL statement is:
    Code:
    GRANT ALL PRIVILEGES on *.* to root@host1 IDENTIFIED BY 'password' WITH GRANT OPTION;
    and not
    Code:
    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.

  2. #17
    Member
    Join Date
    Aug 2006
    Posts
    8

    Default

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

  3. #18
    Member
    Join Date
    Aug 2006
    Posts
    8

    Exclamation

    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.

  4. #19
    Technical Product Specialist cPanelDavidG's Avatar
    Join Date
    Nov 2006
    Location
    Houston, TX
    Posts
    10,720
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    Quote Originally Posted by fifawe View Post
    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

Similar Threads & Tags
Similar threads

  1. Automatic cPanel backup (domain & MySQL) with cron & PHP
    By tastaram in forum Data Protection
    Replies: 27
    Last Post: 10-13-2011, 10:13 AM
  2. Backup users & configuration to remote - Workarounds?
    By organic in forum Data Protection
    Replies: 4
    Last Post: 07-28-2011, 05:51 PM
  3. WHM backup with remote mySQL server
    By tavenger5 in forum Data Protection
    Replies: 4
    Last Post: 07-14-2010, 07:50 AM
  4. Incramental Local & Full Remote Backup Plan
    By davetanguay in forum Data Protection
    Replies: 7
    Last Post: 11-26-2009, 10:56 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube