WordPress.org

Ready to get started?Download WordPress

Forums

MAMP Sequel Pro unable to connect to database (3 posts)

  1. heathersaker
    Member
    Posted 1 year ago #

    I am using MAMP and Sequel Pro and am unable to connect my database with wordpress for local theme development. In MAMP my lights are green . Inside Sequel Pro, I seem to be able to connect via socket using localhost, root, and my password that I reset in the terminal ( root was not giving me access).
    When I try to load in the browser
    http://localhost:8888/wordpress/

    with 'wordpress' as my database name in sequel pro, I get
    "Error establishing a database connection"

    Iv'e been googling all night trying all sorts of avenues with no luck....any idea what's up?

    I was doing fine with MAMP until I recently upgraded to Pro and was prompted to reset the password....since then, no dice despite efforts to reset in the terminal.

    thanks !

  2. ClaytonJames
    Member
    Posted 1 year ago #

    I was doing fine with MAMP until I recently upgraded to Pro and was prompted to reset the password

    Did you change the MySQL user password in the wp-config file to reflect the password change?

    /** MySQL database password */
    define('DB_PASSWORD', 'yourpasswordhere');

  3. heathersaker
    Member
    Posted 1 year ago #

    Hi Clayton

    I did, yes :

    define('DB_NAME', 'wordpress'); ( as I assigned in sequel pro)

    /** MySQL database username */
    define('DB_USER', 'root');

    /** MySQL database password */
    define('DB_PASSWORD', 'my password');

    /** MySQL hostname */
    define('DB_HOST', 'localhost');

Topic Closed

This topic has been closed to new replies.

About this Topic