Sequelpro: Cannot Login with Blank Password

[yuchunc]

Hi

In my development environment, I have set root to use a blank password, so something like this would work.

$ mysql -uroot -p
Password:

However, when using Sequel Pro's login form, an empty password box doesn't grant me any privileges after login. I believe it is behaving more or less like the following.

$ mysql -uroot

Am I doing something I shouldn't do? or is it missing the function?

Thanks for the awesome APP!

Mickey

[rowanbeentje]

Hi @yuchunc - I _think_ the behaviour of mysql -uroot and mysql -uroot -p with an empty password is the same - I thought both cases are essentially treated as no password.

With Sequel Pro are you using a Socket connection type, or are you using a Standard connection with a local hostname? The two do behave a bit differently depending on how MySQL is set up...

[dmoagx]

For me it's the same:

# mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# mysql -uroot -p
Enter password: (just pressed enter)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

(note the "using password: NO")

Likewise if you leave the password empty in Sequel Pro:

MySQL said: Access denied for user 'root'@'localhost' (using password: NO)

[jnesbitt]

This is still an issue. No need to wait on a response from the original submitter. Should be simple to set up a test and verify.

[dmoagx]

This issue is closed and as shown above Sequel Pro behaves exactly like the MySQL CLI client so we don't intent to change anything.

[juliocanares]

got into this today