(Sorry if this is a duplicate post, email issues w/multiple accts)

I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of
knowledge of computer systems, but haven't setup or worked with mySQL
before. (usually use it preinstalled on my hosting service). I
downloaded the package and installed it via the automated setup that
comes for the MacOS. It started fine. The MySQL Sys prefs tool shows
the status of the server as running. However, I want to now setup
Wordpress on my localhost. I need to create a database on mysql. I
opened the shell and navigate to the location of mysql. I have been
using the instructions as shown below.

$ mysql -u adminusername -p
Enter password:


This is where I'm stuck. No matter what account I use, I am unable to
login to the database. My personal account is the only account on the
machine, while it's not root, it has full admin privs, and I've tried
everything to login, including no password, my account's password,
etc. Since I've not activated root on this machine (I understand that
Apple, by default disables it), perhaps there's something I'm missing
in my lack of knowledge of the way the Mac OS uses root?

I'm sure this is a stupid newbie issue, but I'm a bit wrapped around
the axle here. Do I need to use sudo? (I've even attempted this with
no success). I've searched on a few lists to see if anyone has had
this problem, but not seen it yet.

Should I just reinstall? Am I just missing something that passed by in
install (I don't remember adding a password other than entering the
password that I use to admin the machine.

Thoughts? Thanks in advance for any .

On Dec 13, 2007 12:11 PM, Al <albergstein@gmail.com> wrote:
> (Sorry if this is a duplicate post, email issues w/multiple accts)
>
> I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of
> knowledge of computer systems, but haven't setup or worked with mySQL
> before. (usually use it preinstalled on my hosting service). I
> downloaded the package and installed it via the automated setup that
> comes for the MacOS. It started fine. The MySQL Sys prefs tool shows
> the status of the server as running. However, I want to now setup
> Wordpress on my localhost. I need to create a database on mysql. I
> opened the shell and navigate to the location of mysql. I have been
> using the instructions as shown below.
>
> $ mysql -u adminusername -p
> Enter password:
>
>
> This is where I'm stuck. No matter what account I use, I am unable to
> login to the database. My personal account is the only account on the
> machine, while it's not root, it has full admin privs, and I've tried
> everything to login, including no password, my account's password,
> etc. Since I've not activated root on this machine (I understand that
> Apple, by default disables it), perhaps there's something I'm missing
> in my lack of knowledge of the way the Mac OS uses root?
>
> I'm sure this is a stupid newbie issue, but I'm a bit wrapped around
> the axle here. Do I need to use sudo? (I've even attempted this with
> no success). I've searched on a few lists to see if anyone has had
> this problem, but not seen it yet.
>
> Should I just reinstall? Am I just missing something that passed by in
> install (I don't remember adding a password other than entering the
> password that I use to admin the machine.
>
> Thoughts? Thanks in advance for any .
>
>
No idea about the particulars of OSX, however
http://dev.mysql.com/doc/refman/5.0/...rmissions-unix
should work.