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.