# \#mysql **URL:** https://community.localwp.com/tag/mysql/87.md [Latest](https://community.localwp.com/latest.md) · [Categories](https://community.localwp.com/categories.md) · [Tags](https://community.localwp.com/tags.md) --- ## [Local MySQL 8.xx.xx live MySQL 5.7.x move local \> live 8?](https://community.localwp.com/t/local-mysql-8-xx-xx-live-mysql-5-7-x-move-local-live-8/51736)
**Author:** [@Koeraedf4312](https://community.localwp.com/u/Koeraedf4312)\ **Replies:** 3\ **Last updated:** [February 4, 2026, 5:21pm UTC](https://community.localwp.com/t/local-mysql-8-xx-xx-live-mysql-5-7-x-move-local-live-8/51736 "2026-02-04T17:21:22Z")
I noticed my live server is still using MySQL 5.7, because WordPress gave me a warning / notification. I also noticed my Local version of my site is running on MySQL version 8.0.35 and without any problems. Now my quest… --- ## [Unable to run some wp-cli DB commands](https://community.localwp.com/t/unable-to-run-some-wp-cli-db-commands/26920)
**Author:** [@janw.me](https://community.localwp.com/u/janw.me)\ **Replies:** 4\ **Last updated:** [September 28, 2021, 3:26pm UTC](https://community.localwp.com/t/unable-to-run-some-wp-cli-db-commands/26920 "2021-09-28T15:26:14Z")
Issue Summary Some wp db \*\* commands don’t work some do. Replication When I start any site, right click open site shell and execute: Works: wp db check wp db export (it was a problem in the past apparently) Gives er… --- ## [Allow configurable location for "userdata/run" folder](https://community.localwp.com/t/allow-configurable-location-for-userdata-run-folder/51037)
**Author:** [@hugosolar](https://community.localwp.com/u/hugosolar)\ **Replies:** 7\ **Last updated:** [August 1, 2025, 4:57pm UTC](https://community.localwp.com/t/allow-configurable-location-for-userdata-run-folder/51037 "2025-08-01T16:57:41Z")
Moving Application support data to a different location Is there a way to move the Application Support/Local/run/ folder to a different location? is currently taking a lot of space from my small hard drive. What I’ve se… --- ## [Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect](https://community.localwp.com/t/cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2-when-trying-to-connect/50431)
**Author:** [@matei](https://community.localwp.com/u/matei)\ **Replies:** 6\ **Last updated:** [June 9, 2025, 2:13pm UTC](https://community.localwp.com/t/cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2-when-trying-to-connect/50431 "2025-06-09T14:13:40Z")
What issue or error are you experiencing? Hello, I am using Localwp on my Linux Mint 21.3 Cinnamon. I want to make a backup of the WordPress website I have been working on using Duplicator plugin. When the backup tried… --- ## [Can't resolve the Msql error after trying everything](https://community.localwp.com/t/cant-resolve-the-msql-error-after-trying-everything/47299)
**Author:** [@marh](https://community.localwp.com/u/marh)\ **Replies:** 15\ **Last updated:** [May 16, 2025, 1:14pm UTC](https://community.localwp.com/t/cant-resolve-the-msql-error-after-trying-everything/47299 "2025-05-16T13:14:27Z")
Hello Thank you for your help and time in advance if possible. I don’t know witch steps to make now. I am not unfamiliar with the error, but this time i tried all i found and that i can try, without result. What issue … --- ## [Unable to start site or create a new one](https://community.localwp.com/t/unable-to-start-site-or-create-a-new-one/49700)
**Author:** [@cvf.93](https://community.localwp.com/u/cvf.93)\ **Replies:** 1\ **Last updated:** [April 16, 2025, 5:40pm UTC](https://community.localwp.com/t/unable-to-start-site-or-create-a-new-one/49700 "2025-04-16T17:40:03Z")
What issue or error are you experiencing? I can’t start my site or access the wp admin. My website was working fine last night, but I came back to it today unable to access it at all. I’m also unable to log in to the dat… --- ## [Error: "Uh-oh! Unable to start site." for sites using mysql5](https://community.localwp.com/t/error-uh-oh-unable-to-start-site-for-sites-using-mysql5/49465)
**Author:** [@taste.misrule](https://community.localwp.com/u/taste.misrule)\ **Replies:** 5\ **Last updated:** [April 3, 2025, 2:56pm UTC](https://community.localwp.com/t/error-uh-oh-unable-to-start-site-for-sites-using-mysql5/49465 "2025-04-03T14:56:14Z")
Bug Summary Can’t start sites that use MySQL 5.7.28, MySQL 8 sites work fine. Error: Uh-oh! Unable to start site. Error: spawn /Users/me/Library/Application Support/Local/lightning-services/mysql-5.7.28+6/bin/darwi… --- ## [Bug Report: Unable to start site on Ubuntu](https://community.localwp.com/t/bug-report-unable-to-start-site-on-ubuntu/49007)
**Author:** [@engrrajonahmed](https://community.localwp.com/u/engrrajonahmed)\ **Replies:** 1\ **Last updated:** [March 19, 2025, 1:34pm UTC](https://community.localwp.com/t/bug-report-unable-to-start-site-on-ubuntu/49007 "2025-03-19T13:34:46Z")
Bug Summary On my Linux machine I see the following error when I try to start a site for the first time in a session after a reboot. Steps to reproduce 1. Install Ubuntu 22.04.… --- ## [Solved: Where are non-WP databases?](https://community.localwp.com/t/solved-where-are-non-wp-databases/45665)
**Author:** [@EvgeniyO](https://community.localwp.com/u/EvgeniyO)\ **Replies:** 2\ **Last updated:** [November 22, 2024, 9:51am UTC](https://community.localwp.com/t/solved-where-are-non-wp-databases/45665 "2024-11-22T09:51:18Z")
I maintain multiple databases in AdminerEvo, beside of those of WP. I found local.sql of the WP site - but where are other databases? Search for \*.sql displays only local.sql. Does somebody know pathes to non-WP databas… --- ## [MySQL Workbench](https://community.localwp.com/t/mysql-workbench/45451)
**Author:** [@EvgeniyO](https://community.localwp.com/u/EvgeniyO)\ **Replies:** 1\ **Last updated:** [November 10, 2024, 2:29pm UTC](https://community.localwp.com/t/mysql-workbench/45451 "2024-11-10T14:29:12Z")
I was confronted with the same issue. In my experience, as for november 2024, connection with Workbench isn’t possible. But finally I imported my needed external db with LocalWP’s own AdminerEvo to manage it. --- ## [Database Import Error on Debian Linux - libtinfo.so.5 Version Mismatch](https://community.localwp.com/t/database-import-error-on-debian-linux-libtinfo-so-5-version-mismatch/45148)
**Author:** [@dcampbell](https://community.localwp.com/u/dcampbell)\ **Replies:** 3\ **Last updated:** [October 23, 2024, 1:08pm UTC](https://community.localwp.com/t/database-import-error-on-debian-linux-libtinfo-so-5-version-mismatch/45148 "2024-10-23T13:08:26Z")
I’m encountering an error when trying to import a WordPress database into a LocalWP site on my Debian Linux machine. The import fails with the following error message: Error: Failed to get current SQL modes. Reason: my… --- ## [Emojis break when pulling down to Local site (show up as '?')](https://community.localwp.com/t/emojis-break-when-pulling-down-to-local-site-show-up-as/45037)
**Author:** [@beardsavvy](https://community.localwp.com/u/beardsavvy)\ **Replies:** 3\ **Last updated:** [October 17, 2024, 2:19pm UTC](https://community.localwp.com/t/emojis-break-when-pulling-down-to-local-site-show-up-as/45037 "2024-10-17T14:19:57Z")
Bug Summary Emojis in post content are not displayed. Instead they show up as ? or ??? Steps to reproduce Pull down to Local from a WP Engine environment with emojis in the post content. Environment Info Describe your … --- ## [Populating LocalWP MySQL from local machine](https://community.localwp.com/t/populating-localwp-mysql-from-local-machine/44520)
**Author:** [@EvgeniyO](https://community.localwp.com/u/EvgeniyO)\ **Replies:** 2\ **Last updated:** [September 11, 2024, 2:04pm UTC](https://community.localwp.com/t/populating-localwp-mysql-from-local-machine/44520 "2024-09-11T14:04:28Z")
Is it possible to populate MySQL of LocalWP with files from local Windows machine? With Python script running on Windows, or with custom Wordpress plugin, running in LocalWP installation? Are there any known limitations… --- ## [Change mysqladmin ping timeout](https://community.localwp.com/t/change-mysqladmin-ping-timeout/44308)
**Author:** [@PeteNelson](https://community.localwp.com/u/PeteNelson)\ **Replies:** 3\ **Last updated:** [August 28, 2024, 2:49pm UTC](https://community.localwp.com/t/change-mysqladmin-ping-timeout/44308 "2024-08-28T14:49:41Z")
I have a large mysql database that has been imported into a Local site. The DB itself is around 2GB, which isn’t an issue, but it’s from a multisite install that has about 190 sites, and the number of tables in the datab… --- ## [Error in startup](https://community.localwp.com/t/error-in-startup/44041)
**Author:** [@vexxodev](https://community.localwp.com/u/vexxodev)\ **Replies:** 1\ **Last updated:** [August 6, 2024, 2:23pm UTC](https://community.localwp.com/t/error-in-startup/44041 "2024-08-06T14:23:00Z")
This is the Problem shown in all-time in startup --- ## [Only Part of the Database Loads into New Site](https://community.localwp.com/t/only-part-of-the-database-loads-into-new-site/43130)
**Author:** [@grzfyf64df89](https://community.localwp.com/u/grzfyf64df89)\ **Replies:** 13\ **Last updated:** [June 1, 2024, 8:04pm UTC](https://community.localwp.com/t/only-part-of-the-database-loads-into-new-site/43130 "2024-06-01T20:04:02Z")
I created a new site by selecting a zip file with the wp-contents folder and a MySQL file. I have I selected also the PHP version 8, Apache, and MySQL version 8 (but I also tried version 5.7 with the same results). After… --- ## [Unable to Start Site MYSL](https://community.localwp.com/t/unable-to-start-site-mysl/41845)
**Author:** [@Slavov](https://community.localwp.com/u/Slavov)\ **Replies:** 3\ **Last updated:** [March 16, 2024, 2:01pm UTC](https://community.localwp.com/t/unable-to-start-site-mysl/41845 "2024-03-16T14:01:06Z")
What issue or error are you experiencing? When i try to start my site it gives me this message Error X Uh-oh! Unable to start site. Error: Command failed: C:\\Users\\Ceco X sikasil\\AppData\\Roaming\\Local\\lightning-serv… --- ## [Unable to Start Site MYSQL](https://community.localwp.com/t/unable-to-start-site-mysql/41582)
**Author:** [@zafira](https://community.localwp.com/u/zafira)\ **Replies:** 4\ **Last updated:** [March 13, 2024, 7:26pm UTC](https://community.localwp.com/t/unable-to-start-site-mysql/41582 "2024-03-13T19:26:01Z")
Hi! Im pretty new to Local and i struggle a bit to understand how to fix errors, and lately ive been facing a lot of errors/bugs maybe because i dont kow how to manage the application. Huge thank you for the one(s) tha… --- ## [Where are LocalWP MySQL databases stored?](https://community.localwp.com/t/where-are-localwp-mysql-databases-stored/40801)
**Author:** [@s.doig](https://community.localwp.com/u/s.doig)\ **Replies:** 4\ **Last updated:** [January 19, 2024, 6:31am UTC](https://community.localwp.com/t/where-are-localwp-mysql-databases-stored/40801 "2024-01-19T06:31:54Z")
Where are LocalWP MySQL databases stored on a Mac? I have exported 3 websites from WP Engine and dragged their zips into LocalWP to create them locally. I noticed there were 2 SQL files in each of the site’s sql folder… --- ## [An empty WordPress installation](https://community.localwp.com/t/an-empty-wordpress-installation/40768)
**Author:** [@tayfur](https://community.localwp.com/u/tayfur)\ **Replies:** 2\ **Last updated:** [January 9, 2024, 4:06pm UTC](https://community.localwp.com/t/an-empty-wordpress-installation/40768 "2024-01-09T16:06:24Z")
We are using YOOtheme PRO and need manual installation to transfer the initial setup demo content. Is it possible to install manually with LocalWP? --- ## [File errors on startup after update, plus .ibd file is missing error](https://community.localwp.com/t/file-errors-on-startup-after-update-plus-ibd-file-is-missing-error/40694)
**Author:** [@donb625](https://community.localwp.com/u/donb625)\ **Replies:** 3\ **Last updated:** [January 4, 2024, 6:04pm UTC](https://community.localwp.com/t/file-errors-on-startup-after-update-plus-ibd-file-is-missing-error/40694 "2024-01-04T18:04:35Z")
I have been using local for roughly a year now with no trouble. I was out of the office over the holidays, returned today, and was prompted to update to 8.2. Afterwards, trying to start any of my local sites yields vario… --- ## [Sites fail to boot or create on Fedora 39](https://community.localwp.com/t/sites-fail-to-boot-or-create-on-fedora-39/39923)
**Author:** [@leichim](https://community.localwp.com/u/leichim)\ **Replies:** 7\ **Last updated:** [December 24, 2023, 10:21am UTC](https://community.localwp.com/t/sites-fail-to-boot-or-create-on-fedora-39/39923 "2023-12-24T10:21:12Z")
What issue or error are you experiencing? mysql service is spewing out errors, and can not start The error does not exist when using MySql 5.7. I have reinstalled Local I have tried it on existing sites that work… --- ## [Someone to help me please ,am getting "uh-oh! unable to provision site" in localwp](https://community.localwp.com/t/someone-to-help-me-please-am-getting-uh-oh-unable-to-provision-site-in-localwp/39703)
**Author:** [@muthokah](https://community.localwp.com/u/muthokah)\ **Replies:** 20\ **Last updated:** [November 7, 2023, 11:03pm UTC](https://community.localwp.com/t/someone-to-help-me-please-am-getting-uh-oh-unable-to-provision-site-in-localwp/39703 "2023-11-07T23:03:05Z")
What issue or error are you experiencing? “uh-oh! unable to provision site” in localwp What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc “uh-oh! unable to provision site” in lo… --- ## [Open Site Shell does not use local mysql sock](https://community.localwp.com/t/open-site-shell-does-not-use-local-mysql-sock/39561)
**Author:** [@mic](https://community.localwp.com/u/mic)\ **Replies:** 3\ **Last updated:** [October 17, 2023, 6:47pm UTC](https://community.localwp.com/t/open-site-shell-does-not-use-local-mysql-sock/39561 "2023-10-17T18:47:57Z")
What issue or error are you experiencing? I cannot use the site shell in the local container. It seems to be referencing outside the container ~/Local Sites/test/app/public which means the mysql sock used is from my mach… --- ## [Mysqld doesn't start](https://community.localwp.com/t/mysqld-doesnt-start/39428)
**Author:** [@titaniumbones](https://community.localwp.com/u/titaniumbones)\ **Replies:** 5\ **Last updated:** [October 7, 2023, 1:40pm UTC](https://community.localwp.com/t/mysqld-doesnt-start/39428 "2023-10-07T13:40:57Z")
What issue or error are you experiencing? when trying to create a site, I get the “unable to provision” error. the local mysqld won’t launch, and the process repeatedly shuts down. What steps can be taken to replicate … --- ## [\[REQ\] Update to MySQL 8.1?](https://community.localwp.com/t/req-update-to-mysql-8-1/38536)
**Author:** [@Banija](https://community.localwp.com/u/Banija)\ **Replies:** 0\ **Last updated:** [August 11, 2023, 12:46am UTC](https://community.localwp.com/t/req-update-to-mysql-8-1/38536 "2023-08-11T00:46:24Z")
https://dev.mysql.com/downloads/mysql/ --- ## [Can I set a global MySQL settings that will affect all my sites?](https://community.localwp.com/t/can-i-set-a-global-mysql-settings-that-will-affect-all-my-sites/38470)
**Author:** [@merianos](https://community.localwp.com/u/merianos)\ **Replies:** 2\ **Last updated:** [August 8, 2023, 3:42pm UTC](https://community.localwp.com/t/can-i-set-a-global-mysql-settings-that-will-affect-all-my-sites/38470 "2023-08-08T15:42:31Z")
What issue or error are you experiencing? I have some plugins on my WordPress site that making MySQL server write huge binlogs. To give you an idea, first time I mentioned that issue, my MySQL server produced for a singl… --- ## [Trying to add site but it self deletes after opening SQL Database](https://community.localwp.com/t/trying-to-add-site-but-it-self-deletes-after-opening-sql-database/38246)
**Author:** [@DYEvans](https://community.localwp.com/u/DYEvans)\ **Replies:** 17\ **Last updated:** [July 28, 2023, 4:28pm UTC](https://community.localwp.com/t/trying-to-add-site-but-it-self-deletes-after-opening-sql-database/38246 "2023-07-28T16:28:05Z")
During the install from zip process the site self-deletes after trying to open the MySQL database. I am just trying to backup a website for a friend, and wanted to give them the option of using a program like Local to v… --- ## [Database repeatedly disconnects](https://community.localwp.com/t/database-repeatedly-disconnects/37882)
**Author:** [@nickfindley](https://community.localwp.com/u/nickfindley)\ **Replies:** 11\ **Last updated:** [July 19, 2023, 2:18pm UTC](https://community.localwp.com/t/database-repeatedly-disconnects/37882 "2023-07-19T14:18:11Z")
I’m having constant disconnects when trying to run my site locally. I can occasionally restart the site and connect briefly, but not long enough to do much. Error reconnecting to the database This means that the contac… --- ## [Most current version of mySQL](https://community.localwp.com/t/most-current-version-of-mysql/37671)
**Author:** [@RainvilleM](https://community.localwp.com/u/RainvilleM)\ **Replies:** 5\ **Last updated:** [June 23, 2023, 8:26pm UTC](https://community.localwp.com/t/most-current-version-of-mysql/37671 "2023-06-23T20:26:28Z")
Issue Summary Is it possible to use different versions of mySQL than what are available in the select boxes? We are looking to keep up with the last versions of mySQL from a security standpoint. Right now we are looking … [Next page](https://community.localwp.com/tag/mysql/87.md?match_all_tags=true&page=1&tags%5B%5D=mysql)