How to create Mysql DB

**galleryseek** · 01-21-2003, 11:23 AM

i remember once having to install apache/php/mysql on win2k(i think)... it wasn't too hard i remember... there'll be tons of matches on google that'll help you if you type in the right keywords depending on the version / os n' such.

**JFPdude** · 01-21-2003, 11:26 AM

Originally posted by juicylinks
How can i create this myself on my box with out asking my host to.

I went into my bos typed mysql at the prompt and set permission denied any advice or online resources?

mysql is usually run with mysql or root permissions.

If your on shared hosting you need to contact your host about a mysql database.

However if you have dedicated hosting you may have access to do these tasks yourself.

**Juicy D. Links** · 01-21-2003, 11:30 AM

Yeah i am on my own box with root access ill browse google see what i hit

**xroach** · 01-21-2003, 11:32 AM

# mysql -u root -p

mysql> create database [databasename];

(make a superuser)
mysql> grant all privileges on [databasename] to [username]@localhost identified by '[password]';

mysql> reload privileges;

**JFPdude** · 01-21-2003, 11:35 AM

A good tutorial on mysql can be found at vtc.com

you will need the root mysql password

prompt# mysql -p <enter>
Password: <enter password here>

blahblahblah mysql header:

mysql> create database databasename;
mysql> grant [permissions you want here] on databasename.* to usernamehere identified by 'passwordherekeepthesinglequotes';
mysql> flush privileges;

those commands are all on one line btw.

Hope this helps you.

**JFPdude** · 01-21-2003, 11:38 AM

yeah what xroach said.

both ways of doing the commands will result the same.

**Ludedude** · 01-21-2003, 05:53 PM

Or just go here http://phpmyadmin.sourceforge.net/

**d0se** · 01-21-2003, 06:11 PM

If you cant administer a mySQL db from the command prompt u need to leave it to the people with a clue. Hire a programmer it will be cheaper and easier for you in the long run. Not having a go at u or nething but if DBs aint your thing ur better off getting someone in the know to get it sorted for you.

**picindex** · 01-21-2003, 07:54 PM

phpMyAdmin

This tool rocks

**Cogitator** · 01-21-2003, 07:56 PM

JuicyLinks: You are either a woman or very gay. Which is it?

**Juicy D. Links** · 01-21-2003, 07:57 PM

I already created them guys i aint stupid thanks for the tips

**Juicy D. Links** · 01-21-2003, 07:58 PM

Originally posted by Cogitator
JuicyLinks: You are either a woman or very gay. Which is it?

Next time your in NY come over and youll find out

**Carrie** · 01-21-2003, 08:02 PM

That's it. Show us yer tits!
(Especially if it's a nicely built set of pecs covered in warm soft hair. Mmm.)

**JimW** · 01-21-2003, 08:06 PM

Originally posted by picindex
phpMyAdmin

This tool rocks

definately!!!

How to create Mysql DB

How to create Mysql DB

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment