How to use Managed MySQL with OpenLiteSpeed WordPress

September 29, 2019 243 views
OpenLiteSpeed WordPress 1-Click DigitalOcean Managed MySQL Database

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!

1 Answer

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.

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!