Mac OS X Newbie - Having difficulty setting a pw for root - MySQL

[lee.hogan@gmail.com]

Hi,

*Please assist a unix/Mac OS X newbie ~
I just installed the MySQL 5.0.27 binary package for Mac OSX 10.4 and
am having a lot of difficulty with the post-installation processes. 
root user since, by default, the root account initially has no
password. Using a bash shell on Mac OS X 10.4.8, I've tried setting
the password using this command:

/usr/local/mysql/bin/mysqladmin -u root password mynewpassword

Nothing happens after I press enter. However, when I try to login to
mysql as the root user like this:

/usr/local/mysql/bin/mysql -u root

I get the following error message:

ERROR 1045 (28000): Access denied for user 'root''localhost' (using
password: NO)

I'm extremely new to all of this and installed MySQL to follow along
with a book I'm reading. I'm trying to familarize myself with creating
fast and efficient databases for my company.

Any assistance would be greatly appreciated~
Thank you~

- a MySQL newbie

[Captain]

On 19 Feb, 16:13, com wrote: 
 
No you don't. If you're just using it on your own local machine for
test purposes and no one else has netrowk access to it then you can
quie happily run with no PW.

[lee.hogan@gmail.com]

But when I run mysql using this command:

/usr/local/mysql/bin/mysql

and then try creating a database:

mysql> create database mydatabase;

I get the following error msg:

ERROR 1044 (42000): Access denied for user '''localhost' to database
'mydatabase'

On Feb 19, 11:24 am, "Captain Paralytic" <com>
wrote: 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
> No you don't. If you're just using it on your own local machine for
> test purposes and no one else has netrowk access to it then you can
> quie happily run with no PW.[/ref]