On my servers i'm using the 'user'@'localhost' for PHP apps.
running on the local web-server. Those users allocated for
web-apps can only connect to their specific DB from localhost.
On Tue, May 22, 2007 03:19, Miguel Cardenas wrote:
>> Localhost is indeed a special value that isn't include in '%'
> Hm, I didn't know that! I thought it was only a special value to the
> client tools, which I know will try to connect via socket on UNIX machines
> when they see 'localhost' but will try to connect via TCP/IP when they see
> '127.0.0.1'. Thanks for pointing this out!
>
> Baron
In fact that was
> Localhost is indeed a special value that isn't include in '%'. It's a
> feature not a bug ;)
>
> Regards,
Bingo! That was the point! If i connect to the server ip or server name it
works perfectly, but if I try to connect to localhost it fails unless I add a
new user specific to localhost :D
> If you don't specify a hostname in SHOW GRANTS, '%' is assumed. My mistake
> for not telling you this before. If you enable networking, and connect
> with
>
> mysql -h 127.0.0.1
>
> instead of
>
> mysql -h localhost
Well, in fact 127.0.0.1 and localhost produce the same effect but
Hi,
Miguel Cardenas wrote:
Remember to quote the user and host carefully. So,
The quoting is okay, I tested again
If you have doubts about what you actually granted, do this:
SHOW GRANTS FOR 'user'
I've sent this command:
grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass';
You are still missing the GRANT for 'myuser'@'localhost'
On Mon, May 21, 2007 03:06, Miguel Cardenas wrote:
>> Remember to quote the user and host carefully. So,
>
> The quoting is okay, I tested again
>
>> If you have doubts about what you actually granted, do this:
>> SHOW GRANTS FOR 'user'
>
>
> Remember to quote the user and host carefully. So,
The quoting is okay, I tested again
> If you have doubts about what you actually granted, do this:
> SHOW GRANTS FOR 'user'
I've sent this command:
grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass';
Then tested the show grants
Mathieu Bruneau wrote:
Baron Schwartz a écrit :
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES
Baron Schwartz a écrit :
> Hi,
>
> Miguel Cardenas wrote:
>> Hello list
>>
>> I have a problem adding a user with host '%' ...
>>
>> *** If I add a user with host '%' when trying to connect get this error:
>> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
>> password: YES)
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
*** If I add the same user with localhost it
Hello.
It looks very weird for me. I don't have an access to AIX machine, so I
suggest you to use gdb and research where MySQL is getting such an
interesting result. See sql/hostname.cc file from the source
distribution and:
http://dev.mysql.com/doc/refman/4.1/en/debugging-server.html
Hello.
Enable a General log and find out what is MySQL thinking about the host
from you're connecting to it.
Ben Clewett wrote:
> Dear MySQL,
>
> A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
>
> Connecting from foreign server 'pho.com' with IP of '192.168.
A little more information:
If I use --skip-name-resolve then I get an odd error:
ERROR 1045 (28000): Access denied for user 'me'@'0.0.0.0' (using
password: YES)
This seems to suggest that MySQL thinks my client is from '0.0.0.0' and
hence cannot match any GRANT syntax I use. Why would MySQL
Anil wrote:
Michael,
Just I want to know if we grant privileges with '%' wild card character will
it accept connection from 127.0.0.1. when I tried it is showing connection
request is coming from [EMAIL PROTECTED] and connection is not establishing . to
my knowledge '%' means it should accept co
cept connection from any host . please
clarify
Thanks
Anil
DBA
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 11:22 PM
To: Anil
Cc: mysql@lists.mysql.com
Subject: Re: problem with grant
Anil wrote:
> HI,
>
> I have grante
Anil wrote:
HI,
I have granted all privileges to a user to connect from any host like below
grant all on *.* to [EMAIL PROTECTED] identified by 'password';
flush privileges;
Verify this worked with
SHOW GRANTS FOR [EMAIL PROTECTED];
By the way, giving all privilege
n R. Porter [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 21, 2004 11:09 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Problem with GRANT...WITH GRANT OPTION
>
> 'GRANT GRANT ON table_or_database_name ...' gave a syntax error.
> 'GRANT GRANT OPTION ON table_or_da
nt tables, and if so, what are the minimum privileges
required?
Regards,
John R. Porter
I.T. Services
University of Strathclyde
Faculty of Education
76 Southbrae Drive
Glasgow
G13 1PP
e-mail: [EMAIL PROTECTED]
Tel. 0141 950 3289
-Original Message-
From: aman [mailto:[EMAIL PROTECTED]
S
Also, if you have any doubts whether your changes took the right effect,
check the mysql database on your server and check out the tables that
store privileges assigned by your GRANT query.
Aman Raheja
http://www.techquotes.com
On Wed, 2004-07-21 at 11:11, Martin Gainty wrote:
> John-
>
> GRANT
John-
GRANT privilege ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY
'password'
in this case you need to
GRANT GRANT ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY
'password'
Hope this helps,
Martin Gainty
SQL Consultant
USA 001-617-852-7822
From: "John R. Porter"
7;s University
Phone: (902)420-5893
Fax: (902)420-5035
-Original Message-
From: Vasoczki Ferenc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:35 PM
To: 'Andrew Dumaresq'; [EMAIL PROTECTED]
Subject: RE: Problem with Grant command
It's correct, just insert a
It's correct, just insert at the end of line:
WITH GRANT OPTION;
rtfm
Vaso
-Original Message-
From: Andrew Dumaresq [mailto:[EMAIL PROTECTED]]
Sent: 2002. január 22. 19:31
To: [EMAIL PROTECTED]
Subject: Problem with Grant command
Hello,
I have what I consider to be a very strange pro
Yes i did that , after that i restart my server, But still it didn't load
the new settings.
Kindly help.
Thanks
Damnish
- Original Message -
From: "oltra jean-michel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 2:52 AM
Subject: Re: pr
Have you tried 'flush privileges' after having set root password?
jean-michel
On Thu, 31 May 2001, Damnish wrote:
> I am using MySql on linux.
> I can start mysqld by "safe_mysqld --user=mysql --skip-grant-tables &
> But when i try to start it withour --skip-grant-tables, it said A
24 matches
Mail list logo
