MYSQL Error when using wordpress

May 28, 2014 1.6k views
mark.a.everhart
By:
mark.a.everhart
Trying to create a gallery and I get this error: Access denied for user 'root'@'localhost' (using password: NO)insert into wp_gallery set gallery_name= Hod do I fix it?
Log In to Comment
1 Answer
asb MOD May 28, 2014
Make sure that the correct database name and user are set in your wp-config.php file. Using the DigitalOcean one-click app, it is locate at /var/www/wp-config.php The DB_NAME and DB_USER should both be wordpress: 
define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', 'XXXXXXX');
Reply
Have another answer? Share your knowledge.