Creating A Database On Vndv + Uuuq Servers, With pictures and all limitations noted.

[Andrew]

This information is good for uuuq.com and vndv.com servers. If you're on the uuuq server, just replace all instances of vndv.com with uuuq.com and the tutorial is the same.

This tutorial shows you how to create a database on the vndv.com and uuuq.com servers. There are alot of topics about people having problems so I'm hoping this will help clear alot of that up. If you notice anything that needs to be changed, or if I can word something different to make it more clear let me know and I'll fix it right away.

All content categories are colored orange for ease of use.

Table of Contents
Making sure you can create a database
Examples
Making The Database
Deleting a Database
Accessing phpMyAdmin

Making sure you can create a database...

If your site's domain name is longer than 14 characters you will have to make a new domain, mysql on this server has a limit of 16 characters, and that includes your site name, an underscore and your username or database name. (Don't worry after you read this, it will make a bit more sense).

Examples...

Say your sites domain is zymic.vndv.com and you want to make a database. This will work fine because zymic is your site name, and it's only 5 characters long.
Now lets say your sites domain is zymicfreehosting.vndv.com, this will not work, because zymicfreehosting is 16 characters long and doesn't allow for the underscore and database name.

All MySQL usernames and database names are in the following format: sitename_username and sitename_database
(now you understand why I keep saying underscore).

Making the database...

• First off you need to login to your zymic account. http://zymic.com
  
  
  
• Then click control panel home.
  
  
  
• After you login you'll notice all your websites listed in the center of the page, login to the site you want to create a MySQL database for.
  
  
  
• On this page click "MySQL Database Management".
  
  
  
• This next page your at is where everything gets created. The first box you come upon is the database name creation. Go ahead and type your database name, but remember to keep the characters infront of the box and what you type in the box under 16 characters. Note mine is trippin_ then I typed data and add them together to equal 12 characters. I'm under the limit and ready to go. Click the "Create Database Name" button and go to the next step.
  
  
  
• The next step is to create your MySQL username, you will use this to give your scripts access to the database we just created. The same rules apply to this as did the database name, under 16 characters. After you type the username and password click Create Username.
  
  
  
• Now we assign privileges to your username and database you just created. For now leave everything checked unless you have experience with database privileges. If you skip this step then your username won't have any access to the database and therefore won't work with any of your scripts. Click the button labled "Assign Privileges" to continue.
  
  
  
• The next box of information just shows you that your privileges have been assigned. If this part of the page doesn't look exactly like mine, (with your information replaced) then re-read the instructions.
  
  
  
• You are all set with your new database. Go test it out! You can try logging into phpMyAdmin or using it directly in your php script. Good Luck!

Deleting a database...
If for whatever reason you want to delete your whole database or username and start over you this box at the bottom of the MySQL Database Management page. Caution, once you delete a database you CANNOT restore the information it contained. It will be gone forever.

Select the database name or user name and then press the corresponding delete button.



Accessing phpMyAdmin
You have a link to phpMyAdmin in your MySQL Database Management section of the control panel. You can click this link and use the username and password you created above to gain direct access to your databases contents, where you can edit delete backup or restore database information. I will not go through the steps of how to do any of that here. Maybe in another tutorial.

To access phpMyAdmin click the link towards the top of the page in the MySQL Database Management page.

[Andrew]

I have updated the post complete with creating deleting databases and users, and accessing phpMyAdmin. There are the promised pictures, and some colored text to help find the sections better.

Let me know if you find any mistakes or something you think should be added. It's almost 3am and I'm beat, so I wouldn't doubt it if you found some mistakes.