MacOS – MySQL not working on mountain lion

macosMySQLterminal

I'm using mountain lion, I have installed MySQL.

mysql server

It shows MySQL is running, but when I type

mysql --version

It gives error "mysql: command not found"

Best Answer

export PATH="/usr/local/mysql/bin:$PATH"

in .bashrc or .bash_profile file (cd ~/.bash_profile)

This will tell your terminal where to find mysql command.

Related Solutions

Cannot start MySQL server with AppleScript – Snow Leopard

PROBLEM SOLVED!

I found the way around it. Just create an AppleScript with sudo inside for mysql server startup

do shell script "apachectl start" password "mypassword" with administrator privileges
do shell script "sudo /usr/local/mysql/bin/mysqld_safe > /dev/null 2>&1 &" password "mypassword" with administrator privileges

MacOS – Will Lion install MySQL with it

You probably need to reset the root MySql password, there's a guide on how to it on HowToForge. You only need to have it happen once, back up the config files before tinkering with them

Best Answer

Related Solutions

Cannot start MySQL server with AppleScript – Snow Leopard

MacOS – Will Lion install MySQL with it

Related Question