Can't connect sequel pro with mysql

Question

I downloaded and installed mysql community server GPL version 5.7.13 on my Mac OSX El Capitan. Then I downloaded sequel pro. I tried to connect mysql using socket. I used the name localhost and username root and kept the password blank. When I tried to connect every time I got the message in the picture.

I also want to add, when I install mysql for the first time, there is a popup which gives me a cryptic password for the root@localhost. So instead of keeping the password section blank, I tried that password too. But it kept showing me the same message except 'root'@'localhost' (using password: YES). What am I doing wrong?

Surely your root password is not really blank? – user207421 Jun 13 '16 at 02:01 — user207421, Jun 13 '16 at 02:01

score 9 · Answer 1 · answered Jun 19 '18 at 14:54

Start mysql server in terminal by:

mysql.server start

Access in mysql with your root user (deffault user created when installed mysql)

mysql -uroot

Create a new account by:

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';

Give it all privileges:

GRANT ALL PRIVILEGES ON * . * TO 'new_user'@'localhost';

Then to reload newly assigned permissions run:

FLUSH PRIVILEGES;

Now you should be able to connect with Sequel Pro with new user:

Standard

Host: 127.0.0.1
Username: new_user
Password: new_password

Followed this word for word, and it still didn't work. I'm using Catalina 10.15.5 with Sequel Pro 1.1.2. — , Jul 20 '20 at 01:36

score 3 · Accepted Answer · edited May 23 '17 at 11:54

3

I use Sequel Pro and connect without password to a localhost server via socket, without any problems. The most likely problem is you typed in the wrong root password. You can reset the root password.

edited May 23 '17 at 11:54

Community

1
1

answered Jun 23 '16 at 09:26

Hanxue

12,243
18
88
130

2

Looks like there's problem with sequel pro. When I tested the connection, it failed with "Password incorrect". When I connected, it connected successfully. I'm using Sequel Pro 1.1.2 – SenG Apr 16 '17 at 08:30

score 1 · Answer 3 · answered Sep 30 '18 at 15:05

1

Make sure MySQL is running (start MAMP/XAMP servers)
MAMP uses "root" for the username AND "root" for the password

answered Sep 30 '18 at 15:05

cschaefer

259
4
8

score 0 · Answer 4 · answered Dec 31 '17 at 18:48

0

Use 127.0.0.1 instead of 'localhost'.

answered Dec 31 '17 at 18:48

Coder_X

1

score -1 · Answer 5 · answered Sep 04 '18 at 09:06

-1

Uninstall it and again install. Give the root password at the time of installation. It worked for me.

answered Sep 04 '18 at 09:06

Tasif Ansari

9
3

score -2 · Answer 6 · answered Apr 23 '19 at 17:04

-2

You will need to restart mysql after changing password, password can be and is in many cases blank, empty carriage return.

the easiest way to restart mysql I have found is by command line

mysql restart;

answered Apr 23 '19 at 17:04

mibbit

4,997
3
26
34

Can't connect sequel pro with mysql

6 Answers6