How do I set up a database on my SmartVPS?

How to setup a Database on a SmartVPS

To set up a database on your Smart VPS, you will need to use phpMyAdmin. The procedure is very simple. First, you need to know your root password for MySQL.

Get your root password for MySQL:

1. Log in to your Dashboard
2. Navigate to VPS HOSTING
   
3. Select your VPS: yourvpsname.com 
   -> Click Manage (green button)
   
4. Go to Databases
   
5. Click the "eyeball" next to the Password field to view the MySQL root password
6. Click the phpMyAdmin link and login with user name root and the password you just viewed.
   

Continue setting up a new Database in MySQL:

Now that you have phpMyAdmin open, the easiest way to get your database set up is to create a new user and database at the same time:

1. Click Users in the main menu
2. Click Add user

Now you just need to fill out some basic fields. Here's what to do:

1. Enter a username. Can be anything you want, but should be all lowercase, and must not have any spaces or special characters.
2. Select "Local" from the drop-down menu for "Host". The word "localhost" will automatically appear in the text box.
3. Click the Generate Password button. It will randomly create a strong password. You will likely use this password only once or twice, so it should be strong, not memorable. If your MySQL password were cracked it would be bad news for your website. Use a strong password.
4. Check the box labeled "Create database with same name and grant all privileges"
5. With your mouse, highlight the password shown in the text box, right click it, and pick "Copy" from the context menu.
6. Right click in an empty notepad, MS Word document, etc and pick "Paste". You'll want to paste this password into your application's setup page. (Joomla, Wordpress, etc.)

Now scroll to the bottom, and click the "GO"button in the bottom right corner.

 

Your database name, and username will now be exactly the same, and you're good to go!