Re: Access Denied for... - Guillaume - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: Access Denied for...

From	Sent On	Attachments
Martin Jeremic	01 Feb 2001 17:51
Andres Lopez	02 Feb 2001 14:38
Guillaume	02 Feb 2001 17:44

Subject:	Re: Access Denied for...
From:	Guillaume (webm...@dwam.com)
Date:	02/02/2001 05:44:49 PM
List:	com.mysql.lists.win32

If you want user2 to be able to login from localhost you have to indicate it.

% as host means all hosts BUT localhost.

so user2 must be twice in the users list : user2@localhost user2@%

Note you can have different rights being local or not. Note also that a global strategy for local users can be defined with @localhost
settings.

|when i create user with following rights : | |user = user1, Host = Localhost, Pass = Some_Password, Select_priv = |true | |everything is OK. but this : | |user = user2, Host = %, Pass = Some_Password, Select_priv = true | |returns : Access denied for user : 'user2@localhost' (using password : |YES). | |I'm trying to login at mysql database. Can somebody help me ? |-- |Martin Jeremic - JSoft | |http://jsoft.webjump.com/ |mailto:mart...@eunet.yu | | | | |--------------------------------------------------------------------- |Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before |posting. To request this thread, e-mail win3...@lists.mysql.com | |To unsubscribe, send a message to the address shown in the |List-Unsubscribe header of this message. If you cannot see it, |e-mail win3...@lists.mysql.com instead. |