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?

Answer 1

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