UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Anyone install MySQL version 5+?

I am trying to install everything. I must say, the documentation seems to be old.

For the past 4 hours I have been working on this and I think I have narrowed down my problem, but I don't know what the solution is.

From what I have been able to look up, the new version of PHP doesn't support MySQL be default. I have tried to use the command line switch, I have added the path to both MySQL and PHP in my path (environment, W2K) and I have gone in to the PHP.ini file and have removed the semicolon in front of the extension. I have tried some other things as well, but I keep getting this:

PHP Warning: PHP Startup: Unable to load dynamic library 'c:\php\php_mysql.dll' - The specified procedure could not be found. in Unknown on line 0

Of course that is setting the extension directory in the php.ini to "c:\php" where the default is "./" which also doesn't work.

Any ideas what the heck to do?

Fred

Threads up to Version 6.5.5 needs mySQL4. Don't wast your time with mySQL5 ... Threads dont like it.

Threads7+ will support MySQL5, however previous versions do not.

As for your error, try copying libmysql.dll into your c:\windows directory (if that doesn't work try the system32 and system folders as well). (This advise was taken from here)

I tried that and it didn't work. I did find that.

So, taking that I will probably be installing 6.5.5, any suggestions on the version of MySQL and PHP to install?

Fred

If someone could publish what versions work I would really, really appreciate it. <img src="https://www.ubbcentral.com/boards/images/graemlins/crazy.gif" alt="" />

I downloaded PHP version 4.1.1 and MySQL version 4.1.20. They seem to install, but now phpmyadmin is giving errors. It is the latest version of phpmyadmin. I assume it wants stuff that isn't in the older versions of PHP or MySQL.

On the help page (here) they have a tutorial of version 2.3.2, but I don't see that listed on the phpmyadmin site.

It would save a LOT of time if they included what versions work in the setup documention. <img src="https://www.ubbcentral.com/boards/images/graemlins/blush.gif" alt="" /> <img src="https://www.ubbcentral.com/boards/images/graemlins/grin.gif" alt="" />

Fred

I'm running:
PHP: 4.3.9
MySQL: 4.1.12
PHPMyAdmin: phpMyAdmin 2.6.4-pl3

I believe that they completely rewrote large chunks of PHPMyAdmin in the latest builds, so be sure you're starting with a *NEW* configuration file vs just trying to throw in an old one.

I think part of this problem is MySQL.

I can't get phpmyAdmin to work and just saying the heck with it and running the install.php file for the board has a fail on the database log in.

Of course, after I installed MySQL, all I did was give root a password and I created a second admin user with a password as well.

Some of the documentation is okay, but if you are installing MySQL and phpmyAdmin from scratch you are kind of stuck.

So, I install php and mysql, anything else I need to do? Is the php install supposed to only have 1 dll in it? the php_mysql.dll that version 5 wanted so badly isn't in there, just what looks to be a singled compiled version.

Honestly, I'm not stupid, but I sure feel that way after today.

Fred

Not sure if theres anymore, I woudln't think; on my home machine I have a webserver using Uniform Server (an "all in one" solution, comes preloaded with PHP/MySQL/Perl/PHPMyAdmin, etc; I used to use EasyPHP for the same thing)

These 2 tutorials might help.

http://adminreports.com/archives/2006/01/24/installing-mysql/
http://adminreports.com/archives/2006/01/23/installing-php/

Both are geared towards Windows Servers.

Thanks.

The MySQL was the easy part, just needed to know which version.

PHP was a little harder, a simple statement in the W2K server docs saying which lines to uncomment and settings to use would have helped.

It turned out to be a small fix, but you have to know what to change.

For phpMyAdmin, never did get that working, I used the MySQL GUIs to set everything up (database & user).

Once I did the install it worked just fine.

Oh, for PHP, for anyone else with these problems:

1) Download the zip package and the installer.
2) Unzip the package into c:\php and set this directory in your path variables.
3) Run the installer and it will take care of all the mundane stuff.
4) Go into the php.ini file (placed in your windows directory) and go to the extension_dir setting and change "./" to "C:\PHP\ext" (if you did step one that is where the extensions are) and then go down to the extension = php_mysql.dll line and remove the semi colon.

I think that is the extent of what you have to do with php, I'm not sure, I had to mess with it for a few hours today, but again, I think that is the extent of it. This is with PHP 5.

Fred