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
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
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:
$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: