PDA

View Full Version : Need help getting MySQL running...


Win2Kuser
05-28-2004, 4:58 PM
Hi, I have been running a web server for about a month or so now without any probs, I have now decided to take it 'up a level' and install php and Mysql.

I have Apache 2.0.49 running on my Win2K adv server box and have installed php v4.3.6 and setup the various settings in the http.conf apache file. Php seems to be running fine...

By creating a test.php file <?php phpinfo(); ?> and browsing to it, it gives all the info it should do including the section on MySQL.

According to the limited info I have got from the net, if I can see the mysql section in the phpinfo, then mysql is installed.

I am under the impression that I have to open up port 3306 which I have in my router settings and now points to the static IP 10.0.0.7 which I have setup on the server. When browsing to grc.com, it shows that port as closed (not stealth), and I have read on the net that it has to be binded to the local port to open it up :~

This is where I am having problems. I have 2 other servers running, one on port 80, the other on port 7172, I have set this one up on 8080 until I get it running and then switch it to 80.

In the php.ini file, there is a mention of
mysql.default-sock= and also
mysql.default-port=

What would I need to put in there in order to get it to work?
Also, there is talk of usernames and passwords, what would these be, and where would I put them?
Is it for example the info I use to login to the Windows server?

I have seen several 'howto's' on the net and they talk about my.ini files and what not - I don't have these as it's not a separate install of mysql as it's contained in php4 - looking at the system, there are no mysql directories anywhere to be found - is this right?

Please dumb it down a bit though, I am struggleing to get my head round this stuff - too much to take in all at once :)

TIA

Win2Kuser
05-28-2004, 6:18 PM
Right, ignore everything above, with some thanks from Woz, I have it running :)

If anyone is reading this, don't bother messing around with the built in MySQL, download the full version from mysql.com and install it. Once installed, go into the c:\mysql\bin folder and run winmsqladmin it will ask you for a username and password - enter what you like, then click next.

It will create a my.ini file in your %systemroot%\system32 folder and run the mysql service.

This will then bind to port 3306 and open it up :D

Thanks for that Woz :D