How to use Managed MySQL with OpenLiteSpeed WordPress

Posted September 29, 2019 1.1k views
OpenLiteSpeed WordPress 1-ClickDigitalOcean 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!


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.

Submit an Answer
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.