Re: Problem with GRANT ... 'user'@'%'

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 '%'.

Re: Problem with GRANT ... 'user'@'%'

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 by using

Re: Problem with GRANT ... 'user'@'%'

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

Re: Problem with GRANT ... 'user'@'%'

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 the

Re: Problem with GRANT ... 'user'@'%'

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) *** If I add

Re: Problem with GRANT ... 'user'@'%'

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:

Re: Problem with GRANT ... '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:

Re: Problem with GRANT ... 'user'@'%'

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' I've sent

Re: Problem with GRANT ... 'user'@'%'

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';

Re: Problem with GRANT ... 'user'@'%'

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

Re: Problem with GRANT not working.

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

Re: Problem with GRANT not working.

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

Re: Problem with GRANT not working.

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

Re: problem with grant

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

RE: problem with grant

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 granted all privileges to a user

Re: problem with grant

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

RE: Problem with GRANT...WITH GRANT OPTION

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

RE: Problem with GRANT...WITH GRANT OPTION

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

RE: Problem with GRANT...WITH GRANT OPTION

PROTECTED] Tel. 0141 950 3289 -Original Message- From: aman [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 17:17 To: [EMAIL PROTECTED] Subject: RE: Problem with GRANT...WITH GRANT OPTION Also, if you have any doubts whether your changes took the right effect, check the mysql database

RE: Problem with GRANT...WITH GRANT OPTION

] 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_database_name ...' worked, but the result was as before, i.e. the new user still

RE: Problem with Grant command

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. janur 22. 19:31 To: [EMAIL PROTECTED] Subject: Problem with Grant command Hello, I have what I consider to be a very strange

RE: Problem with Grant command

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 at the end of line: WITH GRANT

Re: problem with Grant

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

Re: problem with Grant

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: problem with Grant Have you