Lightning - Open Site Shell not working

Took me a few minutes to realize that with lightning, you can access wp cli without it opening a new shell. Open Site Shell opens a new tab in your terminal which should then give you access to WP CLI. However, it looks like there are issues. I’m trying to reset and reinstall a database export but I keep getting this error

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

Seems like this might be an issue with Lightning as I’ve read the following in this post Unable to access database - #18 by johnlovellcdb - Support - Local Community

Currently, the wp db commands don’t work with Local. This is a known issue and our team submitted a patch to WP-CLI . The PR has since been merged and is pending release.

In the meantime, @ben.turner’s pointers above should do the trick.

As far as multisite goes, pushing and pulling isn’t supported, but you should still be able to get up-and-running with multisite.

If you create a brand-new site in Local with multisite, does it function? If so, importing using mysql -u root -proot local < database.sql should do the trick. After that, you should be able to run wp search-replace to update the domain in Local.

1 Like