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!