The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpmyadmin for remote and local

Discussion in 'Database Discussions' started by mahdy_sharifi, Jul 18, 2015.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    175
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello :

    I am going move our server database to remote mysql server , because we have too many server (over 1000dbs) this movement need few days to completed . so we need access phpmyadmin for local and remote databases .
    is it possible config phpmyadmin to access remote and local ?
    I was modify phpmyadmin config file like :


    PHP:
    /* Authentication type */
    //cpanel:$cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['auth_type'] = 'cpanel';

    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysql if your server does not have mysqli */
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['AllowNoPassword'] = false;

    $i++;

    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['auth_type'] = 'cpanel';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'remoteserverip';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysql';
    $cfg['Servers'][$i]['AllowNoPassword'] = false;

    but this method not work , when customers that database locate on remote can't access them .


    Regards
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The method cPanel supports for setting up a remote MySQL server automatically utilizes the remote MySQL server when customers access phpMyAdmin. You'd have to wait to setup the remote MySQL server in cPanel until all databases are copied over, or disable phpMyAdmin locally until you have transferred over all databases.

    Thank you.
     
Loading...

Share This Page