Why do I have to use the keyword [open] in order launch mysql

Question

I have mysql installed on my mac (running OSX Snow Leopard). According to everything I have seen, all I should have to do is type mysql at the command line to bring up the monitor. I do have /usr/local/mysql in my path.

Instead, I have to type open mysql. That opens the monitor. However, I cannot login as root. I tried sudo open mysql. That worked, but it still logs me in as @localhost.

What's up???

Thanks,

John

Answer 1

That /usr/local/mysql is usually the directory where MySQL installs on OS X. Try this command:

/usr/local/mysql/bin/mysql

In addition, I start the local MySQL server using an alias:

alias mysqld="sudo /usr/local/mysql/bin/mysqld_safe"