How to use Managed MySQL with OpenLiteSpeed WordPress

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

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.