# \#mysql-8 **URL:** https://community.localwp.com/tag/mysql-8/42.md [Latest](https://community.localwp.com/latest.md) · [Categories](https://community.localwp.com/categories.md) · [Tags](https://community.localwp.com/tags.md) --- ## [Support for MySQL 8.4](https://community.localwp.com/t/support-for-mysql-8-4/51704)
**Author:** [@tigerxonair](https://community.localwp.com/u/tigerxonair)\ **Replies:** 4\ **Last updated:** [April 16, 2026, 1:17pm UTC](https://community.localwp.com/t/support-for-mysql-8-4/51704 "2026-04-16T13:17:59Z")
The testing needed for MySQL 8.4 is increasing. Would be very good to be able to use MySQL 8.4 on the Mac client of Local WP (or toggle between 8 and 8.4). Thanks --- ## [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… --- ## [Pulling information, problem with mySQL](https://community.localwp.com/t/pulling-information-problem-with-mysql/46770)
**Author:** [@BlackStar1991](https://community.localwp.com/u/BlackStar1991)\ **Replies:** 3\ **Last updated:** [February 3, 2025, 7:53pm UTC](https://community.localwp.com/t/pulling-information-problem-with-mysql/46770 "2025-02-03T19:53:33Z")
After I updated Local to the latest version Version 9.2.0+6762, I had a problem retrieving information from the server. I got this error How can I fix it ? local-lightning.log (454.3 KB) logs.zip (15.4 KB) --- ## [Cannot export database using WP-CLI Access Denied](https://community.localwp.com/t/cannot-export-database-using-wp-cli-access-denied/45592)
**Author:** [@clubside](https://community.localwp.com/u/clubside)\ **Replies:** 3\ **Last updated:** [November 18, 2024, 5:45pm UTC](https://community.localwp.com/t/cannot-export-database-using-wp-cli-access-denied/45592 "2024-11-18T17:45:11Z")
What issue or error are you experiencing? Can’t export (or perform any database-related command) using WP-CLI. No problem connecting to the database with the same wp-config.php credentials using HeidiSQL. I have looked u… --- ## [MySQL workbench connection error in Windows 10](https://community.localwp.com/t/mysql-workbench-connection-error-in-windows-10/45164)
**Author:** [@edko](https://community.localwp.com/u/edko)\ **Replies:** 1\ **Last updated:** [October 21, 2024, 8:01pm UTC](https://community.localwp.com/t/mysql-workbench-connection-error-in-windows-10/45164 "2024-10-21T20:01:03Z")
Hi all, This topic has been asked many times. I have read some o solutions but so far it cant fix my issue. What else can i do so that i can use MSQL workbench as a DB GUI local-lightning\_logs.zip (1.7 KB) --- ## [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… --- ## [Non-WP Custom Site: Exporting to OUTFILE secure-file-priv Error](https://community.localwp.com/t/non-wp-custom-site-exporting-to-outfile-secure-file-priv-error/43394)
**Author:** [@CodeSlayer2010](https://community.localwp.com/u/CodeSlayer2010)\ **Replies:** 4\ **Last updated:** [July 17, 2024, 6:15pm UTC](https://community.localwp.com/t/non-wp-custom-site-exporting-to-outfile-secure-file-priv-error/43394 "2024-07-17T18:15:30Z")
What issue or error are you experiencing? I’m learning MySQL and have set up a custom non-WordPress site (as per torquemag), deleted all the WordPress files, and imported a MySQL database not of WordPress origin. I am us… --- ## [Unable to start site. MySQLAdmin cannot connect](https://community.localwp.com/t/unable-to-start-site-mysqladmin-cannot-connect/41055)
**Author:** [@richardkrone](https://community.localwp.com/u/richardkrone)\ **Replies:** 21\ **Last updated:** [March 6, 2024, 8:58pm UTC](https://community.localwp.com/t/unable-to-start-site-mysqladmin-cannot-connect/41055 "2024-03-06T20:58:35Z")
What issue or error are you experiencing? Hello: I have installed the latest version of localwp. When I attempt to create a new site, I get an error about MySQL. I am running the application on Release Linux Mint 21.3 … --- ## [Wp acf Error: Error establishing a database connection](https://community.localwp.com/t/wp-acf-error-error-establishing-a-database-connection/40595)
**Author:** [@serii366](https://community.localwp.com/u/serii366)\ **Replies:** 4\ **Last updated:** [December 29, 2023, 1:53pm UTC](https://community.localwp.com/t/wp-acf-error-error-establishing-a-database-connection/40595 "2023-12-29T13:53:16Z")
What issue or error are you experiencing? Hi, thanks for app. I want to change custom fields from bash terminal. But i have this error from header, when i run command wp acf My system ubuntu 22.04 System Details Lo… --- ## [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… --- ## [Error: Local was unable to import the following SQL files?](https://community.localwp.com/t/error-local-was-unable-to-import-the-following-sql-files/38955)
**Author:** [@esoto101](https://community.localwp.com/u/esoto101)\ **Replies:** 1\ **Last updated:** [September 8, 2023, 3:37pm UTC](https://community.localwp.com/t/error-local-was-unable-to-import-the-following-sql-files/38955 "2023-09-08T15:37:37Z")
Hi, I’m trying to test my site to ready for a MySQL 8.0 upgrade. I’m not very familiar with this but followed the recommendations from a WPEngine session on this topic. Imported the site via connection on Local, and I go… --- ## [Just installed LocalWP and need PDO extensiuon](https://community.localwp.com/t/just-installed-localwp-and-need-pdo-extensiuon/38520)
**Author:** [@peteharrison](https://community.localwp.com/u/peteharrison)\ **Replies:** 11\ **Last updated:** [August 10, 2023, 4:39pm UTC](https://community.localwp.com/t/just-installed-localwp-and-need-pdo-extensiuon/38520 "2023-08-10T16:39:15Z")
What issue or error are you experiencing? I’ve installed PhastPress plugin and am getting a error " Sorry, PhastPress requires a PHP extension that is not installed." Searching the forum, many posts mention the requirem… --- ## [Multiple vulnerabilities CVE-2019-5482, CVE-2021-3711, and CVE-2022-1292 were discovered within MySQL 8](https://community.localwp.com/t/multiple-vulnerabilities-cve-2019-5482-cve-2021-3711-and-cve-2022-1292-were-discovered-within-mysql-8/34701)
**Author:** [@stein2nd](https://community.localwp.com/u/stein2nd)\ **Replies:** 0\ **Last updated:** [December 12, 2022, 5:27am UTC](https://community.localwp.com/t/multiple-vulnerabilities-cve-2019-5482-cve-2021-3711-and-cve-2022-1292-were-discovered-within-mysql-8/34701 "2022-12-12T05:27:46Z")
Issue Summary Multiple vulnerabilities were discovered within MySQL 8. Troubleshooting Questions FortiClient 6.0.5.0209 has identified multiple security vulnerabilities (CVE-2019-5482, CVE-2021-3711, and CVE-2022-1292)… --- ## [Local 5.9.4 I can't create new site](https://community.localwp.com/t/local-5-9-4-i-cant-create-new-site/23430)
**Author:** [@ygtadk](https://community.localwp.com/u/ygtadk)\ **Replies:** 1\ **Last updated:** [December 18, 2020, 3:19pm UTC](https://community.localwp.com/t/local-5-9-4-i-cant-create-new-site/23430 "2020-12-18T15:19:17Z")
Hello, I installed the Local software for the first time. I am getting an error while creating a site. Of course I did my research and read this \[Windows\] Unable to provision site due to mysqld.exe error - Support - Loc… --- ## [Unable to provision sites on Ubuntu 20.04](https://community.localwp.com/t/unable-to-provision-sites-on-ubuntu-20-04/21455)
**Author:** [@ajith](https://community.localwp.com/u/ajith)\ **Replies:** 0\ **Last updated:** [August 12, 2020, 5:51am UTC](https://community.localwp.com/t/unable-to-provision-sites-on-ubuntu-20-04/21455 "2020-08-12T05:51:13Z")
Getting the following error when trying to provision a new site. using preferred settings. (MySQL 8). The site won’t even provision correctly when using PHP 7.4.1. It seems to be working when select older versions of PHP… --- ## [How to edit my.cnf](https://community.localwp.com/t/how-to-edit-my-cnf/21123)
**Author:** [@Oleksandr](https://community.localwp.com/u/Oleksandr)\ **Replies:** 2\ **Last updated:** [August 11, 2020, 5:10pm UTC](https://community.localwp.com/t/how-to-edit-my-cnf/21123 "2020-08-11T17:10:26Z")
Hi to all. How to change the option “only\_full\_group\_by” in MySQL? Local WP doesn’t allow to change settings in the my.cnf Thank you --- ## [Can't connect to local MySQL server through socket](https://community.localwp.com/t/cant-connect-to-local-mysql-server-through-socket/21101)
**Author:** [@blogjunkie](https://community.localwp.com/u/blogjunkie)\ **Replies:** 1\ **Last updated:** [July 30, 2020, 3:37pm UTC](https://community.localwp.com/t/cant-connect-to-local-mysql-server-through-socket/21101 "2020-07-30T15:37:32Z")
I’ve hung on to Local by Flywheel, and this week I tried Local Lightning. It’s been underwhelming. First, I realized that Sequel Pro no longer works because it doesn’t support MySQL 8. No warnings that the MySQL version… --- ## [Unable to import the following SQL files?](https://community.localwp.com/t/unable-to-import-the-following-sql-files/20916)
**Author:** [@MiladySladja](https://community.localwp.com/u/MiladySladja)\ **Replies:** 0\ **Last updated:** [July 17, 2020, 10:53am UTC](https://community.localwp.com/t/unable-to-import-the-following-sql-files/20916 "2020-07-17T10:53:11Z")
After the Windows 10 re-installation, I had to install Local again and import saved files of the site I’m making in Local again. So, I’m trying to import the wp-content file and sql files. I got a message: Error: Local… --- ## [Using a mySQL desktop admin tool - Connection issues](https://community.localwp.com/t/using-a-mysql-desktop-admin-tool-connection-issues/20743)
**Author:** [@dpaultaylor](https://community.localwp.com/u/dpaultaylor)\ **Replies:** 6\ **Last updated:** [July 13, 2020, 4:37pm UTC](https://community.localwp.com/t/using-a-mysql-desktop-admin-tool-connection-issues/20743 "2020-07-13T16:37:27Z")
Hi, Not sure this is the right place to post but I’m trying to use MySQL workbench to connect to the local mysql database that’s been created using local. In fact, I’ve tried several (Sequel Pro was preferred but it seem… --- ## [Unable to access database](https://community.localwp.com/t/unable-to-access-database/14465)
**Author:** [@kristarella](https://community.localwp.com/u/kristarella)\ **Replies:** 48\ **Last updated:** [May 21, 2020, 10:17pm UTC](https://community.localwp.com/t/unable-to-access-database/14465 "2020-05-21T22:17:21Z")
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 thro… --- ## [Connect MySQL Workbench with Local version 5.4.1+3311](https://community.localwp.com/t/connect-mysql-workbench-with-local-version-5-4-1-3311/19428)
**Author:** [@b.dalia](https://community.localwp.com/u/b.dalia)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 3:02pm UTC](https://community.localwp.com/t/connect-mysql-workbench-with-local-version-5-4-1-3311/19428 "2020-05-11T15:02:31Z")
Hi, i did create a site with Local and try to connect to the DB via MySQL Workbench. In your FAQ, the screenshot of the DATABASE tab is showing remote host and port. Those Infos are not present in my Local version, I c… --- ## [Error trying to recreate a database - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)](https://community.localwp.com/t/error-trying-to-recreate-a-database-cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock-2/14339)
**Author:** [@aaronmhr](https://community.localwp.com/u/aaronmhr)\ **Replies:** 6\ **Last updated:** [May 8, 2020, 8:53pm UTC](https://community.localwp.com/t/error-trying-to-recreate-a-database-cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock-2/14339 "2020-05-08T20:53:57Z")
This is my error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I have a WordPress website online, and I wanted it to be under git version control so I installed VersionPres… --- ## [Importing remote site to local fails on SQL file](https://community.localwp.com/t/importing-remote-site-to-local-fails-on-sql-file/18512)
**Author:** [@commadelimited](https://community.localwp.com/u/commadelimited)\ **Replies:** 1\ **Last updated:** [April 7, 2020, 2:27pm UTC](https://community.localwp.com/t/importing-remote-site-to-local-fails-on-sql-file/18512 "2020-04-07T14:27:31Z")
Greetings, I’m trying to get my remote WP site running locally. I’ve done this before on my old computer (and had it running perfectly), but now that I’ve switched over I’d like to do it here as well. I’m running Local… --- ## [A Plea for Local by Flywheel 3](https://community.localwp.com/t/a-plea-for-local-by-flywheel-3/16118)
**Author:** [@daniel](https://community.localwp.com/u/daniel)\ **Replies:** 6\ **Last updated:** [January 13, 2020, 7:31pm UTC](https://community.localwp.com/t/a-plea-for-local-by-flywheel-3/16118 "2020-01-13T19:31:57Z")
Please don’t kill off Local by Flywheel, else please open source it. I recently/finally/awkwardly imported my sites from LBF 3.3.0 to Local 5.0.7 and it is huge steps backward. Local 5 has no support for multiple PHP ve… --- ## [Windows 10: How to connect to MySQL](https://community.localwp.com/t/windows-10-how-to-connect-to-mysql/17555)
**Author:** [@slaFFik](https://community.localwp.com/u/slaFFik)\ **Replies:** 0\ **Last updated:** [February 24, 2020, 2:23pm UTC](https://community.localwp.com/t/windows-10-how-to-connect-to-mysql/17555 "2020-02-24T14:23:55Z")
I don’t understand how to connect to MySQL. As “Open Adminer” doesn’t work for me, I need to connect directly to the database. Here are details with DB access that I see in Local 5.2.4: I use HeidiSQL to connect us… --- ## [Port Conflict and wrong database](https://community.localwp.com/t/port-conflict-and-wrong-database/17127)
**Author:** [@tnichol](https://community.localwp.com/u/tnichol)\ **Replies:** 0\ **Last updated:** [February 7, 2020, 8:28pm UTC](https://community.localwp.com/t/port-conflict-and-wrong-database/17127 "2020-02-07T20:28:30Z")
Imported from devkit for wpengine. The database it is connecting to seems wrong. If I open adminer it shows me as a user but when I try to login or even reset the password. it says user not found. --- ## [Cannot establish MySQL connection caching\_sha2\_password](https://community.localwp.com/t/cannot-establish-mysql-connection-caching-sha2-password/16629)
**Author:** [@jgparks](https://community.localwp.com/u/jgparks)\ **Replies:** 1\ **Last updated:** [January 21, 2020, 3:30pm UTC](https://community.localwp.com/t/cannot-establish-mysql-connection-caching-sha2-password/16629 "2020-01-21T15:30:29Z")
I can’t seem to connect to MySQL for each local site using PHP RAD and am receiving the error: “Authentication method ‘caching\_sha2\_password’ not supported by any of the available plugins.” I’m struggling to figure thi… --- ## [\[Implemented\] ETA for MySQL \< 8?](https://community.localwp.com/t/implemented-eta-for-mysql-8/16254)
**Author:** [@philby](https://community.localwp.com/u/philby)\ **Replies:** 1\ **Last updated:** [January 7, 2020, 6:21pm UTC](https://community.localwp.com/t/implemented-eta-for-mysql-8/16254 "2020-01-07T18:21:30Z")
Is there an ETA for the ability to select different versions of MySQL (and PHP) in Local (Beta)? I seem to remember reading a while back that things were prepared for this, and it probably would make my life easier, as … --- ## [Error importing SQL from Local Lightning](https://community.localwp.com/t/error-importing-sql-from-local-lightning/14097)
**Author:** [@philby](https://community.localwp.com/u/philby)\ **Replies:** 20\ **Last updated:** [December 27, 2019, 3:35pm UTC](https://community.localwp.com/t/error-importing-sql-from-local-lightning/14097 "2019-12-27T15:35:20Z")
Now that’s a bit of a unexpected one – I exported all my Local Lightning (5.0.3) sites and started to re-import into Local (5.0.4), when a “Uh-oh! Unable to import site” popped up. The mention of «Geometry field» would … --- ## [Unable to import site - Local options does not exist](https://community.localwp.com/t/unable-to-import-site-local-options-does-not-exist/14386)
**Author:** [@olivierk95](https://community.localwp.com/u/olivierk95)\ **Replies:** 1\ **Last updated:** [December 23, 2019, 7:05pm UTC](https://community.localwp.com/t/unable-to-import-site-local-options-does-not-exist/14386 "2019-12-23T19:05:48Z")
I am a beginner in programming and it is actually the first time I am developing a wordpress website. After an OS update I had to reinstall Local by Flywheel and wanted to import my previous work into the application. … [Next page](https://community.localwp.com/tag/mysql-8/42.md?match_all_tags=true&page=1&tags%5B%5D=mysql-8)