Thank you for explaining. I did try mysqladmin --help. This gave me a list of commands and I understood what each did however the problem was I didn't understand why the error was occuring.
I get the impression you last comment was a little condesending, please remember all people where new to mysql at some point. I personally am having trouble with is as I am very much used to oracle and I am struggling to drop my old methods and embrace new one. I do read the help and man pages and the manual but sometimes things can be a little missleading, more so when you are used to something meaning 1 thing and you find out it means another with mysql. Please bare with me if I am slow on the uptake as I have tried to explain I am struggling to get my head around the basics. Thanks, Matt. -----Original Message----- From: James Cox [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 16:40 To: [EMAIL PROTECTED] Cc: Mysql Subject: RE: As plain as the nose on your face try ./mysqladmin -u root -p create bathjobs and FYI, ./mysqladmin --help Thank you. > -----Original Message----- > From: Matthew Darcy [mailto:[EMAIL PROTECTED]] > Sent: 20 December 2001 03:38 PM > To: [EMAIL PROTECTED] > Subject: As plain as the nose on your face > > > I have set the root password for the mysql install. > > I have read the manual and want to make a new database. I ran > mysql_install_db (see my other mail today) which seemed to do little, then > did what the manual told me with > > [mysqldba@jordan bin]$ ./mysqladmin create bathjobs > ./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: > '@localhost' to database 'bathjobs'' > [mysqldba@jordan bin]$ > > > why is this happening ? I was expecting to get a blank shcema > which I could > create tables, grants etc. > > Thanks, > > Matt > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php