Can't connect sequel pro with mysql

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

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.