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 '%'.
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
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
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
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
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:
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:
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
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';
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 connects and works fine...
My
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
11 matches
Mail list logo
