Setting up a wordpress site on Ajenti v- for Ubuntu 14 . When running the wordpress configuration I get the following error message :
Can’t select database We were able to connect to the database server (which means your username and password is okay) but not able to select the xxxxx_database database.
Are you sure it exists? Does the user xxxx_user have permission to use the xxxxx_database database? On some systems the name of your database is prefixed with your username, so it would be like xxxxx_xxxxx_database. Could that be the problem?
I don’t see a way of assigning the user to a specific database as I would normally do with mySql. When creating a user all I get asked is the name , the hostname and the password.
P_
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.
You’ve hopefully seen it by now, but I found that there are two db user management interfaces in Ajenti. The one under Software > MySQL where we found ourselves pulling out our hair, and the one under Websites > [a domain] > MySQL. On this screen you get the db creation, user/password creation, and Grant permissions.