Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    root
    Posts
    870

    Remote MYSQL (cPanel) small error

    Hello,

    I have been reading these forums and quiet a few others for about two days now.

    I have create a remote mysql database in whm for another server on my network. Now my problem is that the remote mysql in fact works as the data is still being pulled from it with mysql disabled on the main server. I did however put in the root password during the remote mysql server setup. Now the only problem I seem to be having is the databases dont show up in any cpanel accounts and phpmyadmin doesnt work. but all sites using a database made before this change still work.

    Any assistance will be greatly appreciated.
    Nick Rose | BudgetVM
    BudgetVM Xen VPS with Solus
    Asia and Europe Hosting Specialists
    LA to Asia <150MS | Amsterdam within Europe <60MS

  2. #2
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,743
    try connecting to the database with the cpanel username from the remote server where mysql runs. If not try granting the privileges for the cpanel user to the database in the remote server. Actually sites uses the database user and password that you make, but the phpmyadmin shows the databases only if the cpanel username have privilege over the database.
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

Related Posts from theWHIR.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •