import database directadmin in classic mysql

[juliengefi]

hello

i have a probleme when i import directadmin database in classic mysql.

the mysql.user encoding password is special and mysql-cient don't support this.

localhost  	toto002_db1  	*6C01DCDB30B210568D2E8F75401281FB0EC87AA8

when i want to connect in mysqldatabase

Warning: mysql_connect(): Client does not support authentication protocol requested by server;
 consider upgrading MySQL client in ...

And i don't find directadmin mysql config file, where ar they ?


thanks


sorry for my english

 

[nobaloney]

DA doesn't include a mysql config file by default.

You can create on at /etc/my.cnf and restart MySQL. Then MySQL will use your config file.

An example config file can be found in these forums.

Jeff

 

[juliengefi]

hello

i don't want to create or modify mysql config file, i just want to view this, but if it's doesn' t exist ....


Why the mysql.user password encoding is so specials ?

how can i use this special encoding in mysql classic ?

thanks in advance

 

[Mik3yZ]

try:

login to the database with the commandline

UPDATE mysql.user SET Password = OLD_PASSWORD(' newpwd ') WHERE Host = ' some_host ' AND User = ' some_user ';

AND after that

FLUSH PRIVILEGES;

This should do the trick

(Source: http://dev.mysql.com/doc/mysql/en/Old_client.html)

 

[juliengefi]

hello

i don't want to use old password but new password

all password has a new hashage and i want to use it

thanks

 

[juliengefi]

other idea ?