[Resolved] MySQL Problems!

nathanpdaniel

I'm having all sorts of issues getting MySQL to work. I installed MySQL 4.1 first, then PHP 4.3.10. I run a simple script like:

<?php $link = mysql_connect("localhost", "user","pass"); ?>

I've also changed localhost to "127.0.0.1". It still says this connection is not allowed or supported. I then checked to see if there was even a "mysql" server running - when I checked there was none running. When I tried to log into the command prompt client mysql thing (not sure what it's called) it wouldn't let me log in - I think the error was 2003 - probably bad password - but I'm not sure - it'd kill the window before I could read the thing. I reconfigured the mysql server, and when I did that, it would not go past the "setting security paramaters" (the last step). I unchecked the box to update security paramaters and then it would not start the MySQL server at all. So then I uninstalled MySQL and reinstalled it and got the same problem again when I tried to start/configure the MySQL server. What do I do now?!?!

kireol

what OS are you running?

Your problem is most likely that you need to start the MySQL deamon.

windows

mysqld start

on my linux box

/sbin/service mysqld start
or
/etc/rc.d/init.d/mysqld start

nathanpdaniel

I am running Windows XP Pro. I did find out there was no MySQL daemon running. I've gotten 'that' problem fixed. Now, if I run my script and the server is NOT running it says: Cannot connect to MySQL Server on 'localhost'....
If I run my script with the server on, it says: client does not support authentication protocal requested by server, consider upgrading MySQL Client in c:\inetpub.....

These same errors occur with and without the username and password in the mysql_connect() function. I also input the SQL : GRANT ALL ON . TO root and it was a successful query.

So how do I fix my problem, or where do I go from here? Thanks!
Nathan

tsinka

Hi,

the client api of MySQL 4.1 has changed. The main problem is that the password hashing algorithm has changed.

The manual contains a chapter about what you can do

http://dev.mysql.com/doc/mysql/en/old-client.html

Thomas

nathanpdaniel

Well that solved the problem! Thanks for all the help!