Tjenare, har försökt att få detta å funka ett tag nu, sökte på forumet en del också och fick fram lite bra gerjjer. Men jag vettefan hur jag ska göra. Hur som helst, när jag försöker ansluta till PHPMyAdmin så står det bara:
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Och här är resultatet av min sökning som jag inte riktigt förstår mig på.
A.2.4 Client does not support authentication protocol error
MySQL 4.1 uses an authentication protocal based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to a it with an older client may fail with the following message:
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
To solve this problem you should do one of the following:
Upgrade all client programs to use the 4.1.1 or newer client library.
Use a user account with an old password when connecting from a pre 4.1 client.
Reset the user that needs a pre-4.1 client to use an old password:
mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Tell the server to use the older password hashing algorithm:
Start mysqld with --old-passwords.
Set the password for all users that has a long password. You can find these users with:
SELECT * FROM mysql.user WHERE LEN(password) > 16;