Re: “Arithmetic operation resulted in an overflow” error upon MySQLConnection.Open()

[Fernando Gonzalez]

Hi Fabricio,

What you need is to issue some SQL code to change your password,

Originally you would have reproduced the problem like this:

create user 'oldpassuser'@'localhost'
grant all on *.* to 'oldpassuser'@'localhost'
set password for 'oldpassuser'@'localhost' = old_password( '123' )


(provided "show variables like 'old_passwords'" returns 0, if not you can change it to zero).

At this point you get the error, to fix you issue:

set password for 'oldpassuser'@'localhost' = password( '123' )

(that fact you are using password function & old_passowords=0 guarantees you will be using 4.1 authentication).

Thanks.