request for a step by step mysql installation in DEBIAN

[neorder]

pls help, i'm having some issue on create a new db, meaning while my mysqld seems running fine.

more details pls refer http://www.directadmin.com/forum/showthread.php?s=&postid=39926#post39926

here is the error msg when i go to sql management

Error connecting to MySQL: Client does not support authentication protocol requested by server; consider upgrading MySQL client


the problem is mysql-client is the newest version now.

debian:~# apt-get install mysql-client
Reading Package Lists... Done
Building Dependency Tree... Done
mysql-client is already the newest version.
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
at: Depends: mail-transport-agent
exim4: Depends: exim4-base (>= 4.34) but it is not going to be installed
Depends: exim4-daemon-light but it is not going to be installed or
exim4-daemon-heavy but it is not going to be installed or
exim4-daemon-custom but it is not installable
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).


what can i do now

 

[jmstacey]

I would suggest installing the mysql-client and other mysql necassary files/libraries that DA provides. I used the libmysqlclient12 provided from http://files.directadmin.com/services/debian_3.0

running "apt-get -f install" to install dependencies and then apt-get install mysql-client might work, but it's probably safer to stick with what DA provides at this time.