SQL Installation - Increasing Security (MD5)

[xeNium]

Increasing Security

Use MD5 to encrypt your password

• WARNING: This will turn your passwords gibberish, just numbers and letters, making them unreadable so be sure to note down your password, either in a text file on your C drive, or on a piece of paper. In MySQL Workbench, click edit, then preferences, then click the SQL Queries tab. Uncheck "(Safe Updates) Forbid UPDATE and DELETE statements without a WHERE clause...", then click OK. Make ragnarok your default schema, by right clicking its name and clicking "Set as Default Schema", now click File, then Open SQL script, and open convert_passwords.sql. Then click the execute icon.

 

I already done that but as the results. Server cannot login and client also cannot login, it says the password is wrong.

 

As a note, I am using xampp 1.8.1 not MySQL itself.

[jaBote]

So, I see you've set to MD5 the passwords when the users register, right?

 

Have you checked this other setting in login_athena.conf?

// Store passwords as MD5 hashes instead of plaintext ?
// NOTE: Will not work with clients that use <passwordencrypt>
use_MD5_passwords: no

Change it to yes if you want to use MD5 passwords.

[xeNium]

Oh, that's why! The wiki don't tell us about that. I think the wiki seriously need a updates.

Thank you for your response.

 

Once again, thanks alot.

Edited March 30, 2013 by xeNium

[jaBote]

A quick check on all conf files is always recommended.

[xeNium]

A quick check on all conf files is always recommended.

 

I am too lazy, lulz.