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.



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.

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

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

Thanks!

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.

Consider it pinned.

Jacob.

It was already pinned but thanks?

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.

Thanks, glad it helped.

How To login Php My Admin


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

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

swordz

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


Username: kamikazeassassins_yodamaniac

Database Name: kamikazeassassins_forums

This is an unrelated issue.


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

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

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

Here's the url.

swordz

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???

Use the url swordz provided as a workaround.

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

I'm assuming your on the uuuq.com server, right now from what I hear it's broken. You'll have to wait for a fix.

is there any server aside from uuuq.com server... when it will be ok...? plsssssssssssssss

Hey ive created my database and username and password. it wont let me sign into php admin it just keeps popping back up and it wont let me sign in...someone help...database name is onlythestrong_sm and username is onlythestrong_ots

Your user name is 1 character too long. The limit is 16.

swordz

What do I use to access PHPADMIN my user name? or database name?

but, the 16 characters limit is in use with all may table in my database ?

Your username


shouldn't be with your tables, only your username and database name.

I've been trying to access phpmyadmin but no luck until now. Is there a server problem? should i type my username like "site\_username" or "site_username" or "username"?

thx in advance.

site_username

i have the same problem

when i enter "sitename_username" and "pass"

it is thinking for a few seconds and displays the same popup

Please try http://www.uuuq.com/phpmyadmin-new

thaks for info to creat free web hosting

Nevermind T.T I figured it out

Hi,
I m just trying to access my database on uuuq.com but i m not able to access by database name and even user name

usually i try by

xxxxxx_uuuq_com_databasename
$passwordOfUserPrivileged

or

xxxxxx_uuuq_com_user$
$password

And user$ is privileged but i m not able to access.

Some can help me?

Needs to be: DOMAIN_DATABASENAME and DOMAIN_USER

(Miss out the _uuuq_com)

the tutorial on the home page for the database says :


"To login use your database username (e.g. site_99k_org_databasename) and the password assigned to that username."

maybe will be better to change it as the hint above.


Thanks anyway

That applies to some of our older domains which use that format. I assumed seeing as you posted here, you would have followed this tutorial which gives you the correct format.

yes. Sorry. I m now able to use mysql.

Thanks

Hi @all

I have problems...

Step 10: Accessing phpMyAdmin


I have retry my currect password. But access denied error from phpmyadmin??????
I have been created database and username tzhan i can not retry to PhP MyAdmin?
What does your server vndv.com happen?

vndv.com/phpmyadmin was happend because your website was read-only or removed by mysql database?

Look my video from youtube! Sorry same language is german. Do not worry: Look What does it happen.. I have currect password and currect database and currect username: Problem with Php MyAdmin

Regards, Joe Corner Reeve

Video is marked as private, but make sure your username is under or equal to 16 characters in length.

Ops sorry i make public thx..

Regards, Joe Corner Reeve

thanks for explaining so nicely.

but sorry to say that after following all these steps when i try to launch phpmyadmin it is not accepting database username and password

here my url is sainageswar.vndv.com
& i tried as
sainageswar_username then password but still it is not accepting.

plz help me..

I did everything from all the photo tutorials you could find on this forum to install joomla (no problem with phpBB) but still get
Database Error: Unable to connect to the database:Could not connect to MySQL
try:
nikolalu.vndv.com/phpbb - no problem
nikolalu.vndv.com/joomla - problem

hi
I am new user, today I found this website, and make a domain, from 6pm-1am I am trying to make a database and username, but it keep say, you have to login, I login, even I logout and login again, again same, when I press login, straight it say ''invalid ID''.
I am so tired now, I made a new domain, same issue, please help me!

This is what I see: You need to log in to be able to use this page. Make sure you have the cookies enabled or you will not be able to log in.
if I click login, then invalid ID, without any question.

Thanks for this tutorial.
Helped me a lot.

good day guys,kindly help me on how to setup my mySQL database,ive created my database successfull in compliance to the limitations.Im able to access it via phpMyAdmin but the problem is im totally noob in this topic.Dont even know how to execute those scripts that needs mySQL support.Can you please help me how to use my database directly to the SCRIPTS that i have.
My site is datu.uuuq.com

Please help fast!:)
What is the Database host URL ?

localhost

Andrew nice job.. Pls I need to host a site with a database can you help me??
my email is sexymark007@gmail.com

to create a forum like I do, with the thanks button or module thanks