Insecure Authentication

[Xmaily]

Hello everyone!

So i'm using and older outdated version of arcemu because I guess i'm used to it and don't want to change and have to relearn trinity/mangos. The problem I'm having is that i'm trying to make a website but it keeps giving me this error saying...

SQL ERROR [ mysqli ]

mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file [2000]

So... I do what it tells me and I put SET PASSWORD = PASSWORD('your_existing_password') into the database and nothing happens.... How do i fix this problem?