How can I access the mysql command line tool when using XAMPP in OS X?
Solution 1
XAMPP is installed in Mac OS X in the following directory:
/Applications/XAMPP/
You can look what's inside that directory and run mysql command line tool providing the full path to it:
$ /Applications/XAMPP/xamppfiles/bin/mysql
If you need, you can modify your PATH environment variable to include XAMPP binaries and you won't need to specify the whole path all the time.
Solution 2
Open your .profile file in Mac. This can be done by entering the terminal and typing
pico ~/.profile
Add the following line to your ./profile file. Replace the path where you installed Xampp, however by default this is the route and should work:
export PATH=/opt/local/bin:/opt/local/sbin:/Applications/xampp/xamppfiles/bin:$PATH
Open a new terminal window (Recommendation is to quit all terminal windows and then reopen) and type:
mysql
That is all, isn't easy!!
Solution 3
Before using the mysql
command, make sure that you start up the server first by running
$ mysql.server start
Then you will be able to use the commands mysqladmin
and mysql
.
To shut it down, run
$ mysql.server stop
and to restart just use
$ mysql.server restart
Very intuitive.
Solution 4
Open terminal and Follow this bellow step to add mysql to your mac environmental variable
step 1:
sudo nano ~/.bash_profile
step 2:
export PATH=/opt/local/bin:/opt/local/sbin:/Applications/xampp/xamppfiles/bin:$PATH
save it by control+x and then y and hit return. That's it!! now close the terminal and reopen
mysql --version
this will tell you which MySQL version you are using with xampp
Related videos on Youtube
Jim
Updated on July 09, 2022Comments
-
Jim almost 2 years
I've got a vanilla install of XAMPP in OS X. How can I access the mysql command line tool? I've tried typing "mysql" at the command line, and it spits back "-bash: mysql: command not found".
-
Capy almost 10 yearsAfter these steps you need logout or run 'source ~/.profile' command to reload your .profile file.
-
Erik Kaju over 9 yearsTogether with Capy's comment - great answer!
-
Chris Johnson over 9 years@tq, don't type the
$
-- that's a stand-in for the bash prompt -
Tristanisginger almost 5 yearsthis should be added ~/.profile rather than ~/.bash_profile as it is an enviromental variable and has nowt to do with bash. superuser.com/questions/789448/…
-
Berlian about 3 yearsI've tried all of the recommendation here, but still I got a "command not found: mysql"