Website woes - How to get MySQL going?

I've got my site up and running with Apache and PHP in windows, I'm building a server so it might go on there with Linux. But I can't for the life of me get the site to use SQL.

Installed a MySQL client, worked fine in the console. Could add and delete entries et cetera.....


When I added the (what i though were the correct) libraries for Apache to use, it still said "undefined function: msql().." like it did the first time i tried it.

so I uncommented the line in php.ini for it to work but it then said "Internal Server Error."

On advice of fellow geek, I tried a bundled package but I couldn't get it to run any page at all so I bit the bullet and clean-slated everything. PHP, Apache, MySQL, PHPtriad, phpmyadmin, all gone.


The Challenge:

Fix this:

New install of Apache and PHP and works fine. From that, what is a good MySQL client to install and how the hell do I get PHP and Apache to run MySQL code?

Currently installed:
Apache: apache_2.0.48-win32-x86-no_ssl.exe
PHP: php-4.3.4-installer.exe

Running on a windows system.

For the sake of argument Apache is installed on c:\program files\web\apache2

Apache is in c:\php\

Please help

Go for appserv-

http://appservnetwork.com

Preconfigured package that includes all the basics. Very little technical knowledge is required, and it's a breeze to set up.

Search the forums for "appserv" to find my noobie server guide with links to everything you will ever need.

create a php page with the following:


then surf to that page and do a find for mysql, if you cannot find anything then php hasn't be built with mysql support.

Ah, of course, forgot about that.

There is a MySQL bit:

Fixed it. In case this comes up in a search later on if someone else has this problem:
Download the PHP libraries, unzip a file called php_msql.dll, send it to C:\Windows\system32

Open php.ini in C:\Windows and add this line:

Save and restart Apache.

Ugh not that file. It took me forever to find php.ini in windowz because almost all the help files on the net were for linux. I had the problem of defining the correct SMTP server.

The line you mentioned should already be in there, just not active. Do a search for it with wordpad and remove the ; that preceeds it so it isn't read as a comment. Then save and restart apache and your all set.

Glad to hear its working! Sorry appserv didn't work .

diggingforgold said:

The line you mentioned should already be in there, just not active. Do a search for it with wordpad and remove the ; that preceeds it so it isn't read as a comment. Then save and restart apache and your all set.

Glad to hear its working! Sorry appserv didn't work .

Click to expand...

Yeah, that's what I did, took a while to work out I was using the wrong library, that's what the "Internal Server Error." was

Ok, more problems. PHP now recognizes MySQL commands but MySQL won't start.

It's a fresh install. Mysqld will not run. I uninstalled it, then re-installed it, no luck.

Anyone know how to make it run?

Have you check that the service is running in control panel > admin tools > Services.

Look for mysql, make sure it is loaded and set to autoload at startup.

Let us know how you get on.