Assuming you logging in from the same server on which mysqld is
running, you need a dmiller@localhost user. The "%" wildcard is valid
only for tcp connections. This is thoroughly explained in the MySQL
manual, chapter 4.3.5.
hth,
Doug
On Mon, 27 Jan 2003 15:03:35 -0500, Devin Miller wrote:
>I
- Original Message -
From: "Devin Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 9:03 PM
Subject: Adding a user problem
> I am pretty new to mysql and have been teaching myself slowly how
> to use it. I am however stuck on a problem. I login to mysql a
Devin,
> GRANT ALL PRIVILEGES
> ON devin.*
> TO dmiller@"%"
> IDENTIFIED BY "password";
>
> The command returns a Query ok and 0 rows affected. However, when I
try to
> login with dmiller (mysql -u dmiller -p) I get a 1045 Access denied
error.
With "mysql -u dmiller -p", the hostname will be "loc
Devin Miller wrote:
>
> I am pretty new to mysql and have been teaching myself slowly how to use
it.
> I am however stuck on a problem. I login to mysql as user root and created
a
> database named devin. I then issue the following commands:
>
> GRANT ALL PRIVILEGES
> ON devin.*
> TO dmiller@"%"
> I
At 15:03 -0500 1/27/03, Devin Miller wrote:
I am pretty new to mysql and have been teaching myself slowly how to use it.
I am however stuck on a problem. I login to mysql as user root and created a
database named devin. I then issue the following commands:
GRANT ALL PRIVILEGES
ON devin.*
TO dmill
