phpmyadmin for remote and local

mahdy_sharifi

• July 18, 2015 05:49

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;[/PHP] but this method not work, when customers that database locate on remote can't access them . Regards

• 

  cPanelMichael

  • July 21, 2015 17:24

  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.

  0

Please sign in to leave a comment.