Here we are going to walk through setting up a new MySQL database and associated user. This guide is designed for users who have no existing databases or MySQL users created.
- Login to your cp.purely.website account.
- Using the left menu, click Websites, then click on the website you wish to setup the MySQL database and user on.
- Using the top menu, click Databases, then click Add Database.
- Enter your new database name, then click Create new user.
- Enter the user you want to be associated with your new database, enter a secure password and make a note of it.
- By default the new user will be granted all database privileges, you can adjust this if required, but generally ALL should be fine for most use cases, click Add.
That’s it, your new MySQL database and user has been setup. You can now use these details in your applications connection string file.
The structure would be:
Database: Username_DBname
User: Username_DBusername
Password: TheSecurePasswordYouChose
Host: localhost
