How to get started with MySQL on Mac

MySQLsnow leopardterminal

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?

Best Answer

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.

Related Solutions

How to use the thesql I just installed

If you already are in the /usr/local/mysql/bin directory, just launch:

./mysql

You should consider adding a symbolic link to /usr/local/mysql/bin/mysql to the /usr/bin directory.

MySQL service is grey under Server Admin

The plist which serverAdmin uses to store the status of the service is missing some keys.

take a look at /Library/Preferences/com.apple.MySQLService.plist

it should look like:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>activeDBPath</key>
    <string>/var/mysql</string>
    <key>selectedDBPath</key>
    <string>/var/mysql</string>
    <key>serviceRunning</key>
    <true/>
    <key>serviceStart</key>
    <date>2011-07-27T14:24:23Z</date>
</dict>
</plist>

Probably yours is missing the serviceStart key

I've had this happen before, though I don't know why.