nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Child Item

MySQL socket error 2002

scuderia

Hi

I am aware that this is a known error and I've searched everywhere but I cannot solve it.

I installed MySQL by double clicking the .pkg file on my Mac. When I try mysql -u root -p I get this error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

Any reason why? The mysql.sock file is located in /var/mysql but there's no text in the file. Where should it be? I've spent the whole day trying to fix this but the error still persists.

In /etc is where my.cnf file is located and in it is this:

[mysqld]
datadir=/usr/local/var/mysql
socket=/var/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/Cellar/mysql/5.6.10

[client]
socket=/var/mysql/mysql.sock

I'm using OSX El Capitan. I just want to set up MySQL so I can use phpMyAdmin as a GUI.

Any help is appreciated.

Find more posts tagged with

Quick Links

Comments

Drexel

Is the MySQL server actually running? Have you started it?

scuderia

Drexel wrote: »

Is the MySQL server actually running? Have you started it?

Yes. When I go to Activity Monitor the process "mysqld" is there.

Drexel

scuderia wrote: »

Yes. When I go to Activity Monitor the process "mysqld" is there.

Try restarting it and logging in again. Also you are passing -p but with no password

Loads of people seeing the same error. Just google it and work through some of the suggestions. One of them will be the correct one

scuderia

Drexel wrote: »

Try restarting it and logging in again. Also you are passing -p but with no password

Loads of people seeing the same error. Just google it and work through some of the suggestions. One of them will be the correct one

It prompts me for a password and when I enter it I get the error. I've looked everywhere, no idea what to do anymore. Have a post on Stack Overflow as well:

http://stackoverflow.com/questions/36654411/mysql-cant-connect-to-local-mysql-server-error-2002

Drexel

scuderia wrote: »

It prompts me for a password and when I enter it I get the error. I've looked everywhere, no idea what to do anymore. Have a post on Stack Overflow as well:

http://stackoverflow.com/questions/36654411/mysql-cant-connect-to-local-mysql-server-error-2002

The guys on stack overflow should sort it for you. They are very good.

One thing, have you set a root password? I think MySQL has no password set by default. Ha e you tried logging in without -p?