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

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.
>From what I've read and understand, I need to set a password for the
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

On 19 Feb, 16:13, lee.ho...@gmail.com wrote:
> 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.>From what I've read and understand, I need to set a password for the
>
> 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

> From what I've read and understand, I need to set a password for the
> root user since, by default, the root account initially has no
> password.
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.

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" <paul_laut...@yahoo.com>
wrote:
> On 19 Feb, 16:13, lee.ho...@gmail.com wrote:
>
>
>
> > 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.>From what I've read and understand, I need to set a password for the
>
> > 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
> > From what I've read and understand, I need to set a password for the
> > root user since, by default, the root account initially has no
> > password.
>
> 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.