A strange error is shown while trying to connect:
"Arithmetic operation resulted in an overflow".
After some searching, I found that this is a bug in MySql connector. It occurs when you use select old authentication (hash) method while creating the database user in MySql.
Command to set password using old method is:
set password for 'oldpassuser'@'localhost' = old_password( '123' )
To solve it, just change the method through admin and use new method (4.1+) while setting the password.
Command to set password using new method is:
set password for 'oldpassuser'@'localhost' = password( '123' )
"Arithmetic operation resulted in an overflow".
After some searching, I found that this is a bug in MySql connector. It occurs when you use select old authentication (hash) method while creating the database user in MySql.
Command to set password using old method is:
set password for 'oldpassuser'@'localhost' = old_password( '123' )
To solve it, just change the method through admin and use new method (4.1+) while setting the password.
Command to set password using new method is:
set password for 'oldpassuser'@'localhost' = password( '123' )
No comments:
Post a Comment