Exports MySQL Users and Privileges using PDO

exportMySQLUsersPDO.php

<?php
# vim:sts=4:sw=4
/*
 * Feel free to improve it.
 * Original by Janich: https://gist.github.com/janich/6121771
 *
 * @requires PHP 5.3+ MySQL 5.6+
 * @package ExportMySQLUsers
 * @author Zaid Daba'een
 * @license http://www.dbad-license.org/ DBAD license
 *
 *
 * Modified for AWS RDS
 */
// Set up database root credentials
$host = 'hostname';
$user = 'root';
$pass = 'your super secret password';
// ---- Do not edit below this ----
// Misc settings
header('Content-type: text/plain; Charset=UTF-8');
// Final import queries goes here
$export = [];
// Connect to database
try {
  $link = new PDO("mysql:host=$host;dbname=mysql", $user, $pass);
}
catch (PDOException $e) {
  printf('Connect failed: %s', $e->getMessage());
  die();
}
// Get users from database
$statement = $link->prepare("select `user`, `host`, `authentication_string` FROM `user` WHERE `user` NOT IN ('root','rdsadmin','mysql.sys','mysql.session')");
$statement->execute();
while ($row = $statement->fetch()) {
  $user = $row[0];
  $host = $row[1];
  $pass = $row[2];
  $export[] = 'CREATE USER \'' . $user . '\'@\'' . $host . '\' IDENTIFIED BY \'' . $pass . '\'';
  // Fetch any permissions found in database
  $statement2 = $link->prepare('SHOW GRANTS FOR \'' . $user . '\'@\'' . $host . '\'');
  $statement2->execute();
  while ($row2 = $statement2->fetch()) {
    $export[] = $row2[0];
  }
}
$link = NULL;
echo implode(";\n", $export);
echo "\n";