How can I access the mysql command line tool when using XAMPP in OS X?

user_240379 0
Viewed 55149

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".

xampp macos mysql
5 Answers

  1. Open your .profile file in Mac. This can be done by entering the terminal and typing

    pico ~/.profile

  2. 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

  3. Open a new terminal window (Recommendation is to quit all terminal windows and then reopen) and type:

    mysql

That is all, isn't easy!!

user_13068540

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.

Admin1

Since I cannot comment on the accepted answer by Pablo Santa Cruz - Here's some additional info. If you're going to modify your PATH environment variable to include XAMPP binaries, make sure you add

/Applications/XAMPP/xamppfiles/bin

and not

/Applications/XAMPP/xamppfiles/bin/mysql

to the /etc/paths file. To do this run the command

sudo nano /etc/paths

then add the path to the file. Save using Ctrl+O and exit using Ctrl+X. Quit terminal and open again.

user_62499560
Related