MySQL Server

[alacritous]

MySQL said:

#2003 - The server is not responding

I've tried running every program in the mysql\bin folder. What the hell is going on? I installed Apache 2.0.52 and PHP 4.3.10. The MySQL version is 4.1.8. If I could run the server, then it will work, but I can't... I havn't configured anything and now that I look around google and other pages it looks like I need to. Last time I installed this I didn't need to do crap. All I did was install and start.

I know I posted a topic about this, but it's pretty obvious after formatting that it's a MySQL problem and not an Apache/PHP/MySQL problem.

Thanks

[visualAd]

Haver you started the server? You can either have it as a Windows service or run it in the command prompt. If you run it in the command pormpt you must keep it open for the duration you make connections to it.

The server program is called mysqld.exe. When yourun this program it should stay open and eagerly await connections. To make a connection you need to run the mysql.exe program.

[alacritous]

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

At least it started. This is using mysql 4.1.8. I've tried changing it to http (the auth type) and it still won't allow me to login.

[visualAd]

At least it started. This is using mysql 4.1.8. I've tried changing it to http (the auth type) and it still won't allow me to login.

Are you connecting through PHP?

Here is the reason for that error:

http://dev.mysql.com/doc/mysql/en/Old_client.html

[Stefan Raab]

I have been adjusted by aliens

[alacritous]

Yes, PHP. (phpMyAdmin)

I'm sorry I'll read that later I am really busy. I think that is the solution now that I think about it.

[alacritous]

Wow, I hate this.

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function: mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.

I goto \mysql\bin\ and type "mysql SET PASSWORD FOR root@localhost = OLD_PASSWORD(mynewpassword);". It doesn't say anything like "invalid parameter" but it acts like it by showing all the parameters, like -s blabla. Well I continue to finish it by typing UPDATE bla and FLUSH bla, but it still says that the client does not support bla. I also tryed the other methods.