My SQL problem
 

ok... im using:

Mysql installed using these RPM's MySQL-client-4.1.0-0.i386.rpm & MySQL-server-4.1.0-0.i386.rpm

When i first installed everything was fine..

Then i installed apache (apache_1.3.27.tar.gz)

Then PHP (php-4.3.2.tar.gz)

Everything worked fine (even MyPhpAdmin)...

Then i decided 2 set-up the root password for mysql.... That worked fine...

logged in

[root@localhost james]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 89 to server version: 4.1.0-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

See all fine...

But if i try and log in using a web interface (ie phpmyadmin) i get this error

Welcome to phpMyAdmin 2.5.1


Error

MySQL said:


Client does not support authentication protocol requested by server. Consider upgrading MySQL client

Any clues on what 2 do... i need to get this sorted ASAP... thanks for any help!

I don't know much about phpMyAdmin but it doesn't like your MySQL client. Are those the latest versions? Maybe its looking for SSL support.

Hmmmm... I don't know much about Mysql, but with other RDMS systems out there, the application logging into the dbms uses a login other than the admin user, for security reasons. What user is php trying to use?

i got everything working again...... But i kinda screwed up... he he (messed up the root password) i dont want 2 reset the root password.. i want 2 remove Mysql and remove the database that has the password init (the database is called mysql)

is there a way of doing this?

Download and run MySQLCC from the MySql website. It's a great GUI tool to help with MySQL. Try to connect with that. Sometimes MySQL doesn't like "remote" connections. There is edit I had to do with the my.conf file to get phpadmin to work. I can't remember what it is though. I'll look.

i got everything working just deleted and reinstalled... all works fine now!

MySQLCC would be useful if there was a moniter on my linux box... im doing everything though telnet from my win machine!

There is a windows version. It's in a .zip extension, and of course like everything Windows, it's easy to install. It's at the site, and defenitly worth the download. Try it out.

I can't find a stable version of that thing. It crashes randomly(Segmentation Fault)