Reputation: 21212

Mac install and open mysql using terminal

I downloaded the mysql dmg file and went through the wizard to run. Done. I have also started mysql server under system preferences.

The purpose of me doing this is to work through the exercises of my SQL text book. The terminal commands are new to me but I think once I can actually get started, working through the exercises should be OK.

From researching the web the various blogs tell me to navigate to to the mysql folder in the terminal:

/usr/local/mysql

Fine. Then it gets a little less clear as nearly each article has a different set of instructions on how to proceed. I was fiddling with it yesterday and was prompted for a password - what is the default mysql password?

Could someone give me the steps to get up and running with mysql via the terminal?

Upvotes: 95

Answers (14)

Praveen Kumar

Reputation: 29

MAC OS Open mysql using terminal

/usr/local/mysql/bin/mysql -u root -p
Enter password: ***** And See
If See Server Port, Version more info then type back slace \s enter
\s

Upvotes: 0

Ranushka Lakmal Sankalpa

Reputation: 901

using terminal insert following command

mysql -u root -p

after enter your root mysql password.

Upvotes: 0

CodingBee

Reputation: 1199

In terminal

sudo sh -c 'echo /usr/local/mysql/bin > /etc/paths.d/mysql'

Close that and open new terminal

mysql -u root -p

Give your password

Upvotes: 7

Kateridzhe

Reputation: 249

You can simply type in Terminal

brew services start mysql

if you installed mysql via brew on mac

Upvotes: 5

Aziz Zoaib

Reputation: 771

try with either of the 2 below commands

/usr/local/mysql/bin/mysql -uroot
-- OR --
/usr/local/Cellar/mysql/<version>/bin/mysql -uroot

Upvotes: 1

Shivam Bharadwaj

Reputation: 2296

For mac OS Catalina :

/usr/local/mysql/bin/mysql -uroot -p

This will prompt you to enter password of mysql

Upvotes: 5

user1549550

Reputation:

(Updated for 2017)

When you installed MySQL it generated a password for the root user. You can connect using

/usr/local/mysql/bin/mysql -u root -p

and type in the generated password.

Previously, the root user in MySQL used to not have a password and could only connect from localhost. So you would connect using

/usr/local/mysql/bin/mysql -u root

Upvotes: 196

Elyas 'Eloy' Hadizadeh Tasbiti

Reputation: 3665

In MacOS, Mysql's executable file is located in /usr/local/mysql/bin/mysql and you can easily login to it with the following command:

/usr/local/mysql/bin/mysql -u USERNAME -p

But this is a very long command and very boring, so you can add mysql path to Os's Environment variable and access to it much easier.

For macOS Catalina and later

Starting with macOS Catalina, Mac devices use zsh as the default login shell and interactive shell and you have to update .zprofile file in your home directory.

echo 'export PATH="$PATH:/usr/local/mysql/bin"' >> ~/.zprofile
source ~/.zprofile
mysql -u USERNAME -p

For macOS Mojave and earlier

Although you can always switch to zsh, bash is the default shell in macOS Mojave and earlier and with bash you have to update .bash_profile file.

echo 'export PATH="$PATH:/usr/local/mysql/bin"' >> ~/.bash_profile
source ~/.bash_profile
mysql -u USERNAME -p

Upvotes: 10

Micky Q

Reputation: 129

This command works for me:

Command:

mysql --host=localhost -uroot -proot

Upvotes: 2

Dan

Reputation: 137

install homebrew via terminal
brew install mysql

Upvotes: 7

Bijan Negari

Reputation: 132

This command works for me:

./mysql -u root -p

(PS: I'm working on mac through terminal)

Upvotes: 5

Brad Cannell

Reputation: 3200

In the terminal, I typed:

/usr/local/mysql/bin/mysql -u root -p

I was then prompted to enter the temporary password that was given to me upon completion of the installation.

Upvotes: 11

knownUnknown

Reputation: 909

open terminal and type

sudo sh -c 'echo /usr/local/mysql/bin > /etc/paths.d/mysql'

then close terminal and open a new terminal and type

mysql -u root -p

hit enter, and it will ask you for password

I have found this solution on https://teamtreehouse.com/community/says-mysql-command-not-found

now to set new password type

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

Upvotes: 69

Cynical

Reputation: 9568

If you have your MySQL server up and running, then you just need a client to connect to it and start practicing. One is the mysql-client, which is a command-line tool, or you can use phpMyAdmin, which is a web-based tool.

Upvotes: 3

Mac install and open mysql using terminal

Answers (14)

Related Questions