Setting up the beast!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Gen-ik
DevNet Resident
Posts: 1059
Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.

Setting up the beast!

Post by Gen-ik »

I've got a PC (windows) running Apache, PHP, and I've just downloaded and dumped MySQL on to my hard-drive... and now I'm stuck.

Does anyone know of any good tutorials (or even know yourself) about getting MySQL 'plugged in' to Apache or PHP. I've been through as much of the default MySQL manual as I can stomach but there's no info telling me how to get it working...... well there probably is but I can't find it.

There's no reference to the PHP or Apache conf files so I don't know what I'm supposed to change in either of them.

Help would be good as always :)
Cruzado_Mainfrm
Forum Contributor
Posts: 346
Joined: Sun Jun 15, 2003 11:22 pm
Location: Miami, FL

Post by Cruzado_Mainfrm »

well u have to run the file in the mysql/bin directory called winmysqladmin.exe, i think that's the one that installs mysql as a system service, after that mysql will be always running, u can see if it's running by openin winmysqladmin.exe again...

u can access right away by using:
mysql_connect('localhost','root');

go and download phpmyadmin from http://www.phpmyadmin.net so u can access it, but in there u have to change the privileges so the root has a password, or u might want to create a new user that can access a certain db and select only, so u can use that one if ur website or project doesn't need to to inserts or deletes, etc
Gen-ik
DevNet Resident
Posts: 1059
Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.

Post by Gen-ik »

Thank-you. I will try it out now :)
Gen-ik
DevNet Resident
Posts: 1059
Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.

Post by Gen-ik »

Woohoo... it's now working fine, thanks.

The only reason I wanted to get it running on my home PC is so I can create my websites 'off-line' before I upload them to the server, and having MySQL working was the final piece of the puzzle. Thanks again.
User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post by nigma »

Well guess who has returned... Gen-ik ;)
Post Reply