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 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
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
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.1.1', I
should be able to GRANT using either:
mysql> GRANT all ON test.* TO test@'192.168.%' IDENTIFIED BY 'test';
mysql> GRANT all ON test.* TO t
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
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;
when I tried to connect to database using ip address like below on the
server where databas
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
t; Martin Gainty
> SQL Consultant
> USA 001-617-852-7822
>
>
>
>
>
> >From: "John R. Porter" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Subject: Problem with GRANT...WITH GRANT OPTION
> >Date: Wed, 21 Jul 2004 14:54:10 +0100
rom: "John R. Porter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Problem with GRANT...WITH GRANT OPTION
Date: Wed, 21 Jul 2004 14:54:10 +0100
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc2-f16.hotmail.com
with Microsoft SMTPSVC(5.0.2
I created a new user with a GRANT statement like:
GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO 'demouser'@'localhost'
IDENTIFIED BY 'testpwd' WITH GRANT OPTION
If I then log in as 'demouser' I can execute SELECT etc. statements on the
'test' database, but if I try to create another user with
Hello,
I am having a weird problem with some sql that is supposed to set up a
DB for me. When I run the .sql file manually from the command line like
this:
mysql --user=root < DB_init.sql
It works fine. But when I do the same command from a shell script that
is run during the kickstart setup
I have installed MySQL on a PC with Windows NT. As the
MySQL dir is not on c:, I have copied the 'my.cnf'
file to c:, and I have edited it to MySQL work with
InnoDB tables. All has been working fine, but
suddendly, without change any, when I have tried to
start up MySQL with the command "mysqld-ma
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 st
Hello,
I have what I consider to be a very strange problem, I log in into mysql
on my localhost I can select from and manually modify tables using
insert select and delete, but I cannot do Grant. I typed the following
command:
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'my passw
Hello,
I have a mysql (3.23) server running on a linux system. The server has
several databases belonging to the (unix) user who created his database. So
each Student may create his own database and usually only he himself may
access/modify the data in this database. This creation of a new dat
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
Hi
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 Access
Denied @localhost. I have updated the mysql.user table and mysql.host
table, still i can't connect it .
33 matches
Mail list logo
