What does mysql -u root -p do?

Question

I am trying to figure out what the mysql -u root -p command does.

I have googled the command but I can't find any good results.

It's simply the way to execute the mysql `command` as the root user `-u root`, prompting for password `-p`. — glaux, Apr 07 '17 at 11:02
*"I have googled the command but I can't find any good results"* - [Really?...](https://www.google.com/search?q=mysql+-u+root+-p) Google input text: "mysql -u root -p". — Funk Forty Niner, Apr 07 '17 at 12:04
@FunkFortyNiner, this is the first result that comes up. Thanks for being helpful! — John Stoneman, Mar 28 '19 at 10:15
Check: [ERROR 1698 (28000): Access denied for user 'root'@'localhost'](https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost) — Xopi García, Jul 20 '21 at 21:54

Viktor · Answer 1 · 2017-04-07T11:11:21.863

mysql -u root -p means, that you trying to connect to MySQL shell with parameters - -u parameter specified MySQL user name.

-u, --user=name User for login if not current user.

In your case it's root user.

-p, --password[=name] Password to use when connecting to server. If password is not given it's asked from the tty.

You can type mysql --help from the command line for more information about all available parameters.

Good luck.

score 3 · Answer 2 · answered Apr 07 '17 at 11:01

3

It logs you into mysql as the root user. After -p (Immediately after it incidentally, no spaces) you would include the password.

answered Apr 07 '17 at 11:01

mayersdesign

score 2 · Answer 3 · answered Apr 07 '17 at 11:02

2

`mysql -u root -p`

Its initiate a connection of MySQL.

-u means that we are going to connect with a username root

-p means that we will enter username's password

answered Apr 07 '17 at 11:02

Naveed Ramzan

score 0 · Answer 4 · answered Apr 07 '17 at 11:03

0

Your command tries to connect to MySQL on localhost with user "root" and asking for a password

answered Apr 07 '17 at 11:03

ghostprgmr

4 Answers4