Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Security Assist - Log In, case sensitive ?

Security Assist - Log In, case sensitive ?

Thread began 3/22/2012 7:27 pm by bbifl346249 | Last modified 3/23/2012 1:43 pm by Jason Byrnes | 744 views | 3 replies |

3/22/2012 7:27 pm | #1 bbifl346249

Security Assist - Log In, case sensitive ?

Log In & Log Out seems to work great.

BUT, it seems that the password validation does not seem to be case sensitive and I don't remember seeing that option anywhere in the wizard.

Anyone ?

3/23/2012 1:11 pm | #2 Jason ByrnesWebAssist

case sensitivity of the login is a function of the way the MySQL Database is created. it is determined by the chartacter set and collation settings for the rtable.

the default character set and collation settings in MySql are latin1 and latin1_swedish_ci which result in none case sensitive string searches.

to force case sensitive string searches, the collation will need to be changed to latin1_general_cs or latin1_bin:

case-sensitivity.html

you can edit the collation using PHPMyAdmin or another GUI tool.

In PHPMyAdmin, open the database, select the users table and go to the Operations tab, on the Operations tab you can change the collation used for the table.

next go to the structure tab, and select the username and password columns, click the edit icon to edit them and set the collation for those columns as well.

3/23/2012 1:26 pm | #3 bbifl346249

Thanks

Works perfectly NOW :D

I learn something every day !

3/23/2012 1:43 pm | #4 Jason ByrnesWebAssist

glad to hear it is working.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.