![]() |
|
#1
|
|||
|
|||
Macromedia DWMX and PHP MySQL setupFirst 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
|
||||
|
||||
How to create a database on MySQLHello 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 GIDBlog
Programming ebook direct download available by crystalattice
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The