Hello.
Reading these parts of the manual could answer a lot of questions: http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html http://dev.mysql.com/doc/refman/5.0/en/GRANT.html Xiaobo Chen wrote: > Hi, all > > I am trying to find out how to check which user is connecting to the > server from which host. > > I have a database, data_A; I wrote a simple java code to connect this > database as user 'root', then it just waits there for input from the > keyboard. Before I type anything, it should keep connecting to the > database. > > But when I type 'select current_user()' in mysql prompt, it always says: > [EMAIL PROTECTED] > > Can any one help me figure out this? > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]