- Joined
- Jul 17, 2007
- Messages
- 665
- Reaction score
- 104
example the old 5.x vs new mysql server
old mysql when i do
username: pista13
password: pista13
salt=bb62766c2a721a4dbd119bbd3e4ed8f7
generated password in users in old mysql: C2BB62766C2A721A4DC2BD11E280BAC2BD3E4EC398C3B7 | pista13 |
add user will fail with same sql and call adduser (doens't like the non string value with 0x when passwd is varchar, if i change to binary then it will be: BB62766C2A721A4DBD119BBD3E4ED8F71 which is different than the older version)
[Issue]
Utf-8 not support it and now the mysql server by default create utf-8 db's
[Solution]
create dp with latin1
CREATE DATABASE pw CHARACTER SET latin1 COLLATE latin1_swedish_ci;
and must use MySQL 5.7 because with 8+ the authd not works
old mysql when i do
username: pista13
password: pista13
salt=bb62766c2a721a4dbd119bbd3e4ed8f7
Code:
call adduser("pista13", 0xbb62766c2a721a4dbd119bbd3e4ed8f7, "0", "0", "", "0.0.0.0", "pista13@gmail.com", "0", "0", "0", "0", "0", "0", "0", "1970-01-01 08:00:00", " ", 0xbb62766c2a721a4dbd119bbd3e4ed8f7);
generated password in users in old mysql: C2BB62766C2A721A4DC2BD11E280BAC2BD3E4EC398C3B7 | pista13 |
add user will fail with same sql and call adduser (doens't like the non string value with 0x when passwd is varchar, if i change to binary then it will be: BB62766C2A721A4DBD119BBD3E4ED8F71 which is different than the older version)
[Issue]
Utf-8 not support it and now the mysql server by default create utf-8 db's
[Solution]
create dp with latin1
CREATE DATABASE pw CHARACTER SET latin1 COLLATE latin1_swedish_ci;
and must use MySQL 5.7 because with 8+ the authd not works
Last edited: