Create database and database user name
If you are going to install WordPress blog on your VPS, it is important to have a database to store your information. Now that we have installed MySQL on the VPS then, will now proceed to log into MySQL with the following command and enter the password in MySQL.
At this point you should have been in the MySQL command, so you must use SQL language, on the screen, you will see your command are now starting the mysql> # as usual instead of your_server>_
View attachment 788
For example, now you will create a database with the following information:
• Database Name: myblog
• Database User: myuser
• Database Password: mypass
And first, you will need to build a database name, and type.
and create a user database
Code:
CREATE USER@localhost myuser;
Create a password for your new database
Code:
SET PASSWORD = PASSWORD FOR myuser@localhost ("mypass");
Assign database and database user name to work together, otherwise known as the database user granted access to the database you just created by follow this code.
Code:
GRANT ALL PRIVILEGES ON myblog.* Identified BY TO myuser@localhost 'mypass';
Refresh MySQL
And exit MySQL
So, okay, now we've got a database with follow information and you can install your wordpress blog according to information
Code:
• Database Name: myblog
• Database User: myuser
• Database Password: mypass
Good luck!