Ok thank you, I think I have it now. Now to get my Client application
working.
On Nov 6, 2005, at 1:16 PM, Björn Persson wrote:
söndagen den 6 november 2005 18:39 skrev Bruce Martin:
However, even though I specified 'test.*' my test user can access the
mysql database.
That's because this s
söndagen den 6 november 2005 18:39 skrev Bruce Martin:
> However, even though I specified 'test.*' my test user can access the
> mysql database.
That's because this statement:
> UPDATE user SET
> Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_p
> riv='Y' WHERE user.User='t
Ok thank you for your replies. I finally got it working, but as you
stated I granted too many permissions. I found that in the user table
my testUser had N for every column with the exception of the last few
which where 0.
I first logged into the database using:
shell>mysql -u root -p mysq
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: zondag 6 november 2005 6:26
> To: Mark
> Cc: 'Bruce Martin'; mysql@lists.mysql.com
> Subject: Re: Add New User
>
> > Because, afterwards, you forgot to say:
>
"Bruce Martin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> When I log in as root using:
> mysql -u root -p mysql
> I get the mysql prompt:
> mysql>
>
> I then issue this command or statement:
>
> mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
> 'some_password'
Mark wrote:
-Original Message-
From: Bruce Martin [mailto:[EMAIL PROTECTED]
Sent: zaterdag 5 november 2005 3:58
To: mysql@lists.mysql.com
Subject: Add New User
When I log in as root using: mysql -u root -p mysql I get the
mysql prompt:
mysql>
I then issue this command or statement:
mys
Bruce Martin wrote:
When I log in as root using:
mysql -u root -p mysql
I get the mysql prompt:
mysql>
I then issue this command or statement:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
'some_password' WITH GRANT OPTION;
First, your hostname is blank. That won't work.
> -Original Message-
> From: Bruce Martin [mailto:[EMAIL PROTECTED]
> Sent: zaterdag 5 november 2005 3:58
> To: mysql@lists.mysql.com
> Subject: Add New User
>
> When I log in as root using: mysql -u root -p mysql I get the
> mysql prompt:
> mysql>
>
> I then issue this command or statement