By Bryan Bowman
I am trying to connect my new OpenLiteSpeed WordPress (created from 1-Click image) to a managed MySQL database. So far, I have successfully connected to my managed DB but I am receiving a “Can’t select database” error from WordPress. This suggests my username and password are correct.
I have a MySQL user with privileges to my ‘wordpress’ database so it would seem this should not be the issue. Here are the grants:
mysql> show grants for ‘wordpress’@‘%’; ±---------------------------------------------------------------------------+ | Grants for wordpress@% | ±---------------------------------------------------------------------------+ | GRANT USAGE ON . TO “wordpress”@“%” | | GRANT ALL PRIVILEGES ON “wordpress”.* TO “wordpress”@“%” WITH GRANT OPTION | ±---------------------------------------------------------------------------+
I appreciate any help!
Thanks!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hello, @techroller
Can you please double check the database details in the wp-config.php file and make sure everything is correct? Sometimes there might be an extra character added or just a white space added between the quotes.
Let me know how it goes.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.