N00b MySQL/WP config question
Hi guys, It's been years since I worked in web hosting - I'm sure the answer is super easy, but it's late and my brain won't grok anymore tonight: https://www.digitalocean.com/community/articles/how-to-install-wordpress-on-ubuntu-12-04 Ok, so (obvious strings have been changed to protect, well, me): CREATE DATABASE my_wp_db; CREATE USER my_wp_db_un@localhost; SET PASSWORD FOR my_wp_db_un@localhost= PASSWORD("mycleverwppw"); GRANT ALL PRIVILEGES ON wordpress.* TO my_wp_db_un@localhost IDENTIFIED BY 'password'; (or is it) GRANT ALL PRIVILEGES ON wordpress.* TO my_wp_db_un@localhost IDENTIFIED BY 'mycleverwppw'; (I've tried it both ways) FLUSH PRIVILEGES; EXIT sudo nano ~/wordpress/wp-config.php // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_wp_db'); /** MySQL database username */ define('DB_USER', 'my_wp_db_un'); /** MySQL database password */ define('DB_PASSWORD', 'mycleverwppw'); /** MySQL hostname */ define('DB_HOST', 'localhost'); Can’t select database We were able to connect to the database server (which means your username and password is okay) but not able to select the my_wp_db database. Are you sure it exists? Does the user my_wp_db_un have permission to use the my_wp_db database? On some systems the name of your database is prefixed with your username, so it would be like username_my_wp_db. Could that be the problem? Do you guys see any notable syntax errors? Are there logs I could look at to help me? Any advice is welcome - thank you!