MAMP Sequel Pro unable to connect to database

  • heathersaker

    (@heathersaker)


    11 years, 1 month 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 !

Viewing 2 replies - 1 through 2 (of 2 total)
  • Clayton James

    (@claytonjames)

    11 years, 1 month 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’);

    Thread Starter heathersaker

    (@heathersaker)

    11 years, 1 month 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’);

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MAMP Sequel Pro unable to connect to database’ is closed to new replies.