3 messages in com.mysql.lists.javaRE: authentication
FromSent OnAttachments
Kevin Fonner09 May 2001 15:10 
Artigas, Ricardo Y.09 May 2001 17:28 
Daevid Vincent12 May 2001 11:25 
Subject:RE: authentication
From:Artigas, Ricardo Y. (ry@easycall.net.ph)
Date:05/09/2001 05:28:54 PM
List:com.mysql.lists.java

I don't think it's advisable to modify mysql's user table. Although you can use it for authentication. Just make your program try to connect to mysql using the user's username and password. If access was denied then username / password is unauthorized but if the volume of users whos' going to use mysql is very large, then that would not be advisable. You can just create another database and a users table for that purpose and use connection pooling or a fixed connection to mysql and query your own users table to authenticate users. Hope this helps.

:^) "A chain is only as strong as its weakest link." Ricky Y. Artigas Analyst/Programmer Information Technology Division Easycall Communications Phils., Inc. - Easycall Internet - 418 Arayat St., Mandaluyong City 1550, Philippines Personal WAP Site: http://www.buzzed.co.uk/mobile/?rya Company Website: http://www.easycall.com.ph Tel.no: (+632) 5338001 ext.6574 Mobile:(+63) 0917-8951783 Pager: 141-002955 Email: ry@easycall.net.ph

------------------------------- IMPORTANT NOTICE:

I am writing a java program that authenticates itself with a database in mysql. Is it possible to use the actual mysql user table to authenticate against? Is this wise? And if so can I add additional columns for my own purposes?