Skip to content

Instantly share code, notes, and snippets.

@anandsunderraman
Created September 30, 2014 13:51
Show Gist options
  • Save anandsunderraman/cb19e990f7ab6cc89362 to your computer and use it in GitHub Desktop.
Save anandsunderraman/cb19e990f7ab6cc89362 to your computer and use it in GitHub Desktop.
phpmyadmin add remote mysql server
<?php
$i++;
//add remote server hostname or ip
$cfg['Servers'][$i]['host'] = 'hostname or ip';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['auth_type'] = 'config';
//add credentials
$cfg['Servers'][$i]['user'] = 'THE MYSQL USER NAME';
$cfg['Servers'][$i]['password'] = 'THE MYSQL USER PASSWORD';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment