: MySql List
Subject: RE: command mysql -u $user without typing it
Try this:
mysql grant all privileges on *.* to test2@localhost
also read manual about the grant command.
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:04 AM
-
From: Ho, Kam [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 16:10
To: '[EMAIL PROTECTED]'; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
Try this:
mysql grant all privileges on *.* to test2@localhost
also read manual about the grant command
Kam; MySql List
Subject: RE: command mysql -u $user without typing it
Matt:
I don't remember you saying what machine you're running mysql on.
Try adding another copy of the same user only @localhost. My win32
installation requires that for a dos box. The hosting
service I use doesn't seem
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 7:31 AM
To: Carl Troein; [EMAIL PROTECTED]
Subject: RE: command mysql -u $user without typing it
Carl,
great attempt, but that would be far to easy, I have removed the localhost
entry and the jordan.no-dns.co.uk entry, the only place
PROTECTED]'; Carl Troein; [EMAIL PROTECTED]
Subject: RE: command mysql -u $user without typing it
Matt:
Can you check and see if you have more than 1 entry for user in your user
table? I wonder if there were more than 1 entry in the user table for user,
MySQL might pick the first one which do
.
Quentin
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 11:10 p.m.
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it - getting shafted
and annoyed now.
I must be going so wrong here.
I deleted
PROTECTED]'; Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it - getting shafted
and annoyed now.
Hi Again
I just did this to check what you did:
SKYROAD#mercury1:/mercury/home/quentin:mysql --user=mercury -p mysql
Enter password:
mysql grant all privileges
Matthew Darcy wrote:
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
but I would like test1 2 and 3 to be able to
Matthew Darcy writes:
If I want to connect to the database as root then I understand I must do
mysql -u root -p
Unless you're logged in as root, in which case mysql -p is enough.
but I would like test1 2 and 3 to be able to type mysql and be either
logged
in as their unix username, ie
: command mysql -u $user without typing it
Matthew Darcy wrote:
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
Subject: RE: command mysql -u $user without typing it
I read similar notes on this in the manual, saying that invoking mysql
without the username will try to take the unix username if it exists in the
database.
I tried this with test2, it opened an mysql session no problem, but when I
did
: Wednesday, January 09, 2002 11:51 AM
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
tired that but I am getting
Query OK, 0 rows affected (0.00 sec)
don't understand why it is not granting to the user ?
Matt.
-Original Message-
From: Ho
]]
Sent: Wednesday, January 09, 2002 11:51 AM
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
tired that but I am getting
Query OK, 0 rows affected (0.00 sec)
don't understand why it is not granting to the user ?
Matt.
-Original Message
)
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 2:26 PM
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
query ok I would expect to see, but no rows affected ??? this must mean it
has
Are you doing 'flush privileges' are documented?
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 8:26 a.m.
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
query ok I would expect to see
learning.
Matt.
-Original Message-
From: Ho, Kam [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 16:57
To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
The Query OK, 0 rows affected indicate
.
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 19:43
To: Matthew Darcy
Cc: Ho Kam; Gerald Clark; MySql List
Subject: RE: command mysql -u $user without typing it
You must do a FLUSH PRIVILEGES after making any changes to the user
permissions before
; MySql List
Subject: RE: command mysql -u $user without typing it
You must do a FLUSH PRIVILEGES after making any changes to the user
permissions before they will actually take effect. This is documented.
james montebello
On Wed, 9 Jan 2002, Matthew Darcy wrote:
query ok I
:[EMAIL PROTECTED]]
Sent: 09 January 2002 21:33
To: Matthew Darcy
Cc: Ho Kam; Gerald Clark; MySql List
Subject: RE: command mysql -u $user without typing it
The mysql user permissions are just a table in the mysql database. Whenever
you do a GRANT, you're really just doing an INSERT or UPDATE
: 09 January 2002 19:43
To: Matthew Darcy
Cc: Ho Kam; Gerald Clark; MySql List
Subject: RE: command mysql -u $user without typing it
You must do a FLUSH PRIVILEGES after making any changes to the user
permissions before they will actually take effect. This is documented.
james montebello
Matthew Darcy writes:
I was aware of the user table as a standard table.
I did a select on it and it all looked fine. Loads of Y's and % for host
Yet this user still cannot connect. The only explaination is corruption.
It sounds to me like you haven't removed the @localhost entry,
but you
21 matches
Mail list logo