How to get started with MySQL on Mac I'm all very new to mySQL. I've installed it from the Oracle website, and I think I managed to run the server with the command:

sudo ./mysqld_safe --console


But it's impossible to open the client and have the "mysql>" prompt that nobody else seems to have a hard time having. I tried:


./mysql
./mysql -u root -p
./mysql -u root -p root
./mysql -u myusername


etc...(I also tried with 'sudo' first)

I always get the same message:

ERROR 1045 (28000): Access denied for user 'xxxxx'@'localhost' (using password: XX)


As you see, I don't really know what I'm doing. Any tips?
Post Install Set-up

Have you been through the post installation set up?

In particular, Securing the Initial MySQL Accounts is important because it sets up the default users and passwords.

brew

You may want to try installing MySQL via the homebrew project. With brew installed, you can install MySQL using the command:

brew install mysql


MAMP

Alternatively, MAMP offers an application based edition of MySQL. Launching the application starts a preconfigured copy of MySQL for you – and it includes the web-based myphpadmin.

With regard to your comment wanting a free solution, MAMP is free:


  Similar to a Linux-Distribution, MAMP is a combination of free software and thus it is offered free of charge. MAMP is released under the GNU General Public License and may thereby be distributed freely within the boundaries of this license.