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@%
IDENTIFIED BY password;
The command
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
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@%
IDENTIFIED
]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- 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
- 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 as user
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 am