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_
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.