I am quite new to the Macintosh, I have Mac OS 10.6 installed.
I downloaded the mysql-5.4.3-beta-osx10.5-x86.dmg file and installed all the files properly.
I have got MySQL server started in system preferences.
Now I want to access MySQL from the terminal but I am unable to do it.
I have tried mysql -u root.
It shows "-bash: mysql: command not found".
How can I make it work?
Is there any tool like phpMyAdmin for Mac?
解决方案
It sounds like you have a path problem in the current shell. Some steps to check/do are:
Can you get to the MySQL prompt from the installed location ? Let's assume that you have installed MySQL in /usr/local/mysql. Then if you change directory (cd /usr/local/mysql/bin) you should be able to execute the mysql command: ./mysql
Check the path settings via env command in your current shell. What you are looking for is the value of PATH where you want to have something along the lines of:
PATH=/usr/local/bin:/bin:/usr/bin:/usr/sbin..... with some reference to mysql's installled path
Reset your current path to include /usr/local/bin. This can be done in the instance of the current shell via export PATH=/usr/local/mysql/bin:/usr/local/bin:$PATH
Test that you can then access the mysql binary from any path on your system.
In terms of the tools for accessing MySQL you can take a look at:
- SequelPro
- MySQL Tools