Adding a user problem

2003-01-27 Thread Devin Miller
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

Re: Adding a user problem

2003-01-27 Thread Paul DuBois
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

Re: Adding a user problem

2003-01-27 Thread Thomas Kvamme
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

Re: Adding a user problem

2003-01-27 Thread Stefan Hinz, iConnect \(Berlin\)
] 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

Re: Adding a user problem

2003-01-27 Thread Mark
- 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

Re: Adding a user problem

2003-01-27 Thread Doug Thompson
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