Support » Installing WordPress » Installation with AWS RDS 5.6.23

  • We are very new to WordPress and are having install issues with AWS RDS MySQL 5.6.23.

    We are trying to do a clean install of WordPress 4.5.1 using an AWS RDS Mysql 5.6.23 instance. The installation says it completes successfully, tables are created, our admin user account even receives an email. Our user account has full privs on the blog database:

    GRANT USAGE ON *.* TO 'blogapp'@'%' IDENTIFIED BY PASSWORD 'our encrypted password';
    GRANT ALL PRIVILEGES ON <code>BLOGPROD</code>.* TO 'blogapp' @'%' WITH GRANT OPTION;

    However, when we try to login we receive an “Error establishing a database connection” error. Upon, checking the database wp_users table there are no users after the install says it completes successfully.

    We can say with 100% certainty it is not a db_host, username, password issue. The install creates the tables, but our hunch is it is erroring when trying to insert records and the installer is not throwing the errors and reporting them.

    We believe this has to do with some specific AWS RDS MySQL environment variables that are not compatible with WordPress?

    Is there any way to turn on debugging during the install process? We turned on WP_DEBUG true, before creating the admin user but that also didn’t do anything. Also, no errors in our php error log or MySQL error log.

    We even tried the simple code segment below, and received “Connection succeeded”.

    $db = @mysql_connect('host', 'username', 'password');
    if (!$db) echo "connection failed";
    else echo "connection succeeded";

    Thanks, Matt

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Installation with AWS RDS 5.6.23’ is closed to new replies.