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…

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…

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. [image] Unable to connect to site with Sequel Pro with Mac Lighting Support …

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.

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

Adminer isn’t there yes. I just downloaded the single file and added it myself to /app/public folder - just to test and get database imported :slight_smile: I love adminer since it’s a single file replacement for phpmyadmin

Hey Everyone – We’ve been zeroing in on why this is happening and the general issue is that the wp db subcommands use the --no-defaults param which blocks out the custom MySQL config we provide. There is a solution but we ran into major issues when trying to implement it on Windows so we’re s…

Ben, thanks for much for this. I found this thread when trying to import a new db into an existing local (beta 5.x) site. The mysql commands worked like charm. Woot!

Unable to access database

Support

kristarella September 30, 2019, 11:56pm 10

@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

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

Unable to access database

Related topics