mysql command line connection to azure

Question

I am using azure and mysql. I CAN connect to the azure mysql instance with the GUI mysql workbench however trying to connect with the command line always gives an access denied.

Here is my connection string (obfuscated)

mysql -h azureserver -u myuser -p thepass -D thedatabase

Here is the output from the command

$ mysql -h azureserver -u myuser -p thepass -D thedatabase 
Enter password: 
ERROR 1045 (28000): Access denied for user 'myuser'@'azureserver' (using password: NO)

Why can I connect with the GUI client and the command line client fails? I used the -p to specify a password but clearly the results implies that I am not using a password (see above)

Am I missing some detail when trying to connect through the command line to an Azure mysql instance?

The Azure tutorial implies that this is all I need PHP mysql azure tutorial

So to summarize:

Yes the MySQL db is up and running. I can access it through my app AND I can access it through the GUI MySQLWorkbench
Trying to access the db with the commandline tool fails indicating that I am not using a password when in fact I am with the -p switch.
My dev box is running MacOSX

Álvaro González · Accepted Answer · 2013-06-10 08:30:10Z

3

Key points:

-p thepass
using password: NO

As per the docs:

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, mysql prompts for one.

So you're asked for a password, but you apparently didn't type anything at the Enter password: prompt. Thus the error.

answered Jun 10, 2013 at 8:30

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

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

1 Comment

Shane Over a year ago

LOL... I knew it was something trivial like that. It is interesting that the other options can deal with a space but the password short form can't. Thanks!

Collectives™ on Stack Overflow

mysql command line connection to azure

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related