Weird output when using mysql via command line

Question

I am trying to access mysql via command line, but when I enter the command to access my DB, I get the mysql --help text as an output. Here is what I am typing in:

mysql -h localhost -u USER -p PASSWORD DB_NAME

I have confirmed all of my credentials are correct, but when I run that, I get the following:

mysql  Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Usage: mysql [OPTIONS] [database]
  -?, --help          Display this help and exit.
  -I, --help          Synonym for -?
  --auto-rehash       Enable automatic rehashing. One do...

I have also tried running it using php exec. I see the same output that way also. Anyone have any thoughts on why this is occurring?

Recheck the exact syntax of the -p option

DaveRandom
– DaveRandom

2013-11-15 22:56:03 +00:00
Commented Nov 15, 2013 at 22:56 — DaveRandom
– DaveRandom, Commented Nov 15, 2013 at 22:56

badcook · Accepted Answer · 2013-11-15 22:55:11Z

3

Remove the space between your -p flag and your actual password, or use --password=PASSWORD. From the man page:

If you use the short option form (-p), you cannot have a space between the option and the password.

answered Nov 15, 2013 at 22:55

badcook

3,75916 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Keith Harris · Accepted Answer · 2013-11-15 22:57:15Z

1

Don't include PASSWORD in the command. The "-p" is all you need. It will prompt you for the password without showing the characters you type.

answered Nov 15, 2013 at 22:57

Keith Harris

235 bronze badges

Collectives™ on Stack Overflow

Weird output when using mysql via command line

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related