Reply
Fastest Way to Create an MySQL Database
Old 05-28-2004, 11:46 PM Fastest Way to Create an MySQL Database
Novice Talker

Posts: 6
Ok well, I just got my server running with PHP and I have MySQL. Right now I'm trying to set up phpBB forums which needs a MySQL database, so I want to know what is the fastest way to make one. I need a password and username for the database, as well. Any help would be much appreciated. Thanks

Evan
coasterfreak55 is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 07-09-2004, 11:57 AM
Average Talker

Posts: 25
Location: UK
You need to use the MySQL monitor but typing:-

mysql

at a command prompt. You should then get:-

mysql>

Now you should be able to create a database as in:-

CREATE DATABASE;

Don't forget the semi-colon. Now try something like:-

grant all privileges on *.* to user-name@domain identified by "password" with grant option;

Hope this helps.

Nick
nickc is offline
Reply With Quote
View Public Profile Visit nickc's homepage!
 
Old 07-10-2004, 10:47 AM
Kyrnt's Avatar
The Post-Mod Years

Posts: 2,536
Location: Western Maryland
I would highly suggest you use phpMyAdmin, which can be found at http://www.phpmyadmin.net/home_page/

It is a great all-around tool for MySQL administration.
__________________
—Kyrnt
Kyrnt is offline
Reply With Quote
View Public Profile Visit Kyrnt's homepage!
 
Reply     « Reply to Fastest Way to Create an MySQL Database
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.12553 seconds with 12 queries