Can't connect sequel pro with mysql
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?
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.
- how to get lib_mysqludf_sys.dll file on windows
- Qt5 MYSQL driver not loaded error
- How can I add machines to data already been sharded in SQL database?
- Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)
- how to save marital relationship in a database
- store posts + comments in mysql dbs
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Does using ASCII/Latin Charset speed up the database?
- utf-8 vs latin1
- Looking to build myself a tiny, free VMWare image for PHP+MySQL Development
- What difference does WITH GRANT OPTION make?
- In MySQL, which is more efficient: IFNULL or NULLIF?
- Replace null with 0 in MySQL
- MySql Query Replace NULL with Empty String in Select
- What does # mean in SQL?
- Trying to understand why my search is not yielding results
- How to set the column order of a composite primary key using JPA/Hibernate
- Renaming foreign-key columns in MySQL
- MySQL query next sequence number for MYSQL auto-incremented field
- How can I suppress column header output for a single SQL statement?
- How do I execute PHP that is stored in a MySQL database?
- Splitting huge sql dump file in smallest chunks possible
- Altering table to add column before specific column
- What is the difference between latin1_general_ci and utf8_bin in MySQL
- count with load Laravel
- MySQL: How to convert seconds to mm:ss format?
- Get mySQL MONTH() to use leading zeros?
- Enable password and unix_socket authentication for MariaDB root user?
- sequelize error: missing index for constraint
- How can I access ddev's database with external database browsers or similar tools?