Pantheon WordPress Database Management without phpMyAdmin

Most WordPress developers are pretty familiar with phpMyAdmin and utilize it frequently for database management. Not having access to things like phpMyAdmin can be nerve-wracking to developers who are used to performing administrative tasks for their database via mouse clicks instead of writing SQL queries.

One of the most frequent tasks we use phpMyAdmin for is to move around databases. Fortunately, this is pretty easy to do on Pantheon without phpMyAdmin:

Migrate a Database to Pantheon

  • Don’t forget to use WP-CLI or a script like interconnect/it offers to edit your site URL’s in your database before import otherwise you won’t be able to login to your admin dashboard.

  • Log in to your site dashboard and navigate to ‘Database / Files’ on the left-hand side.

  • Upload your sql file in the MySQL database field

  • Click ‘Import’

Pantheon dashboard screenshot

Access to the Pantheon Database

You still have direct database access on Pantheon. If you aren't comfortable connecting on the command line, programs like Sequel Pro, MySQL Workbench or phpMyAdmin are great. For detailed instructions on how to do this, see our Accessing MySQL Databases documentation. If you are using phpMyAdmin and want to connect to your Pantheon database you can also do that with a custom config file that includes your Pantheon database credentials.

Create a new file titled ‘config.inc.php’

Navigate to the Pantheon dashboard to obtain your database credentials

And include the following code snippet in your config.inc.php file:

$i++;

$cfg['Servers'][$i]['host']          = 'your host here';

$cfg['Servers'][$i]['port']          = '18336';

$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';

$cfg['Servers'][$i]['user']          = 'pantheon';

$cfg['Servers'][$i]['password']      = 'your password here';

 

Open your phpMyAdmin instance

Click the database titled ‘Pantheon’

Managing and accessing your database may feel initially different on Pantheon, however you still have the ability to utilize your favorite tools to get your work done!


You may also like:

Topics Development, WordPress