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.

[Sugarblossoms]

Nice. This should be a sticky or be more prominent. Good work.

[IamShipon1988]

Nicely written, simple and easy to follow. Now people can stop asking this kind of questions.

[L. Kaiserblazer]

Thanks!

[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.

[Jacob]

Consider it pinned.

Jacob.

[Andrew]

It was already pinned but thanks?

[Andrew]

Updated stating it's the same information for uuuq server.

[calvin2]

Updated stating it's the same information for uuuq server.

Thanks for this post, it was very helpful, they should state this when you are creating your database name.

[Andrew]

Thanks, glad it helped.

[sameerpatra]

How To login Php My Admin


Plz Say What is The User Name & password Also...................

[swordz]

You need to set up the user/password. Just follow this tutorial.

swordz

[Yodamaniac]

I am not sure what the correct format for logging in for is. Here is my info:


Username: kamikazeassassins_yodamaniac

Database Name: kamikazeassassins_forums

[Andrew]

I see: 'You have no hosted websites' not the list like above (
my site: nhantdn.uuuq.com

This is an unrelated issue.

I am not sure what the correct format for logging in for is. Here is my info:
Username: kamikazeassassins_yodamaniac

Database Name: kamikazeassassins_forums

Did you read the beginning? There is a limit of 14 characters for your username. kamikazeassassins is 17.

[Kronus]

hay, i'm new in zymic.com
and I can't crete db suer. I do all whath is in this tutorial

MySQL users: 4/5

but this users dont are in choose of asign privilegis

please help me and sorry for my terible eanglish

[Andrew]

It's broken right now, jump on IRC and look for swordz, he's got a workaround until they fix the control panel.

[swordz]

swordztesting.uuuq.com/database.php
swordz

This post has been edited by zpcs: Dec 20 2012, 04:44 AM

Reason for edit: Broken URL Link Removed then Broken URL Link allowanced for Descriptive URL Link so as not to disturb content

[serpico]

heyy... i am having a problem with creating a database..

wt it does is that after i create a database and a user then it doesnt show up in the drop-down menu while assigning the privileges...

can ny1 tell me why the username is not showing up in the drop down menu???

[Andrew]

Use the url swordz provided as a workaround.

[Frag2Respawn]

Heeyy,

Great tut. Everything what I did is according to this tut. But when I try to login in into phpmyadmin with the username and password I gave it I can't log in. Every time I put in my username with password it keeps coming back. And I can't log in.

Please help!

Greetings,

Frag2Respawn Aka Johnny