Re: Access control for mysql database

2005-11-04 Thread Gleb Paharenko
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]



Access control for mysql database

2005-11-03 Thread Xiaobo Chen
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?




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]