I would appreciate some help. I am trying to access the database via Sequel Pro, or WP CLI to import a .sql file and I cannot do either. wp db import says: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) Sequel Pro gets an “unexpected error” when tr…

That was it! I’m on mac os. The reason I was so confused was that when I’d open Terminal, .bash_profile would run, but despite adding my alias to .bash_profile, the alias wouldn’t be set in Terminal windows popped by Local. And that was because Local is running .bashrc. Really, just needed to lear…

I was having some other issues, so I wiped and reinstalled my mac os, I’m using Local on a totally fresh install, and still getting the error: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

That’s not where the socket is. I don’t know why it’s looking there, but the socket location can be seen in the site’s database tab.

Thanks for replying. Yes, I know. I don’t know why it was looking there either. Since reinstalling my mac I have reinstalled mysql on it and have progressed from the previous error to: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) As far as I can tell, the …

Update: Sequel Pro still crashes on trying to access the ‘local’ database. And upon running wp db import I get the error: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) However, I can interact with the database using mysql CLI in the site shell and importing…

Hi I can confirm that problem also with Local v5 new installation. Installed new Local. Added new site and can’t access database from Sequel Pro and also importing from command line with WP-CLI dont work. Only way i accessed database at the moment was that host name in Adminer had to be localhost…

Thank you will try that. But why WP-CLI import gives "ERROR 1049 (42000): Unknown database ‘local’ " errors then? The same MySQL 8.0 related?

Well, if the Sequel Pro nightly works, then I’d have to say yes.

@afragen I didn’t realise I was using Local Beta, but I am. The newer Sequel Pro build did work! @kristjan07 Thanks, weirdly I don’t seem to have Adminer in my Local app

I don’t think Adminer is set up in the beta.

Unable to access database

Support

afragen September 30, 2019, 2:11pm 7

If you are using the Local beta you will need to use the Sequel Pro nightlies. Something about MySQL 8 doesn’t work quite right in the release versions.

Topic		Replies	Views
Using a mySQL desktop admin tool - Connection issues Support mysql-8	7	1150	October 11, 2020
Unable to run Db Export via CLI Support mysqld , wp-cli	27	7671	December 18, 2020
Can't connect to local MySQL server through socket Support mysqld , mysql-8	2	1534	October 28, 2020
WP-Cli : Error establishing a database connection - Amazingly simple solution Support wp-cli	6	7284	July 12, 2020
Local 5.2.4 : Can't connect to local MySQL server through socket (macOS) Support mac	17	5387	December 8, 2020

Unable to access database

Related topics