GIDForums  

Go Back   GIDForums > Computer Programming Forums > MySQL / PHP Forum
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 16-Mar-2004, 01:24
soulja90 soulja90 is offline
New Member
 
Join Date: Mar 2004
Posts: 2
soulja90 is on a distinguished road
Unhappy

Macromedia DWMX and PHP MySQL setup


First I would like to thank erniegerdie and dsmith for their help! I'm a total newbie to php and they helped me get started.

I figured out how to setup stuff (it was pretty easy as u said) but I'm now trying to attach a mysql database and its not working. It says i have to create one first or something. I'm a total newbie to this and would really appreicate some help!

answer me like you are talking to the dummest girl in the world! lol

Like a total walkthrough

I'm using easy php 1.7

Thanks!

love these forums!

April!
  #2  
Old 17-Mar-2004, 05:50
JdS's Avatar
JdS JdS is offline
Senior Member
 
Join Date: Aug 2001
Location: KUL, Malaysia
Posts: 3,371
JdS will become famous soon enough

How to create a database on MySQL


Hello April,

Sorry I missed replying to your thread sooner but here goes something...

There are a few ways to setup a database on your development server but instead of suggesting you to download and setup phpmyadmin like I usually do, I'll suggest you learn how to use the MySQL monitor instead.

You didn't say if you're on Windows (but I'll assume you are) or which version of Windows even. I'll just tell you how I'd do it with my Windows ME...

Before that we'll assume a few other things as well - let's say you wanted to create a database named aprildb. You want to give the user named benji, access to this database but he'd have to use a password, which is sdfwerk.

When you've started the MySQL server and Apache, open a MS-DOS Prompt window. On windows ME, that's Start > Programs > Accessories > MS-DOS Prompt.

Type the following inside this window:

cd \mysql\bin hit Enter.
mysql -uroot -pYOUR_ROOT_PASSWORD mysql hit Enter.

... now creating the database -
CREATE DATABASE aprildb; hit Enter.

... granting permission to the user
GRANT ALL ON aprildb.* TO benji@localhost IDENTIFIED BY 'sdfwerk'; and hit Enter.

Guess what April, you've just created your first database!

To close the DOS prompt window, just type exit and hit Enter twice.
 
 

Recent GIDBlogProgramming ebook direct download available by crystalattice

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

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 Off
HTML code is Off
Forum Jump

Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 15:54.


vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.