Question

How to use Managed MySQL with OpenLiteSpeed WordPress

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!


Submit an answer

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!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.