The way you create a database on a your Pickaweb VPS depends on the control panel you are running on your server.
If you have not got a control panel you would need to do it via command line or CLI.
To create MySQL database in a VPS with cPanel
Follow the instructions on this tutorial.
To create MySQL database in a VPS with Plesk
- Login to your Plesk user panel.
- Go to Databases section.
- Click on Add Database.
- In the add databases page, just add the database name, the default MySQL user who has the privilege to access the database and also assign the related website from the drop down you can see in the screenshot above.
- Click Ok.
To create database in a VPS with no control panel
In this case you need to do this via Command line or CLI. MySQL server should be installed in the server. How to install MySQL can be found here.
- Login to the server via SSH/Shell.
- Run the following commands.
mysql -u root -p
Type in password when prompted and press ‘Enter’. This will open up a MySQL shell which looks like this.
In the MySQL Shell, run:
mysql>CREATE DATABASE db_name;
Create a MySQL user user who can access the database.
mysql>CREATE USER db_user@localhost;
Grant permissions for the MySQL user to access the database.
mysql> GRANT ALL ON db_name.* TO db_user@localhost IDENTIFIED BY ‘your_password’;
Replace db_name, db_user. your_password with the actual database name, MySQL user who an access the database and its password.
If you run into any problems, just click on the Chat box below and talk to one of our support tech.
Other useful resources:
- How to create a MySQL database on Windows
- How to create mysql database from shell command?
- MySQL server – Official Ubuntu Documentation
We hope you have found this tutorial useful on how to create a MySQL database on your VPS.
Thanks for reading and leave your questions below to keep the conversation going.