Many thanks Paul,
I will read and digest tomorrow in normat daylight hours.
Kerry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 20:55
To: Kerry Frater; "MySQL List"
Subject: Re: Creating a New User - What am I doing wrong?
At 20:25 +0
At 20:25 +0100 8/9/04, Kerry Frater wrote:
I am using 4.0.20a Windows version downloaded as the binary file with
Installer built in.
The system was installed with the "defaults". Nothing was run and the
default mysqld was allowed to run at start up. I have tried this using
Windows XP, Windows 2000
On Sun, 2004-08-08 at 07:22, Kerry Frater wrote:
> I am just going through some taching docs and it says that I can create a
> new user with all authority on a new DB using the command
>
> GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword';
>
> yet when I try and run 'mysql' using
> mysql
Here are some commands to add a new user. Do this from the MySQL prompt:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON databasename.tablename
-> TO username@localhost
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
->
RTM: http://www.mysql.com/doc/en/GRANT.html
Also see http://www.catb.org/~esr/faqs/smart-questions.html
-Original Message-
From: Elby Vaz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 10:39 AM
To: [EMAIL PROTECTED]
Subject: [ Creating a new user ]
Hello friends!
Ho
can you give us the command you are getting the error with? Looks like a
syntax error to me. (Which reminds me, when are you guys going to put a
spellchecker in the MySQL client?) :)
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: