MySQL Forums

What are the three arguments expected by this script (build_deps.sh)? (no replies)

Bing Ma — Fri, 10 Apr 2026 10:05:31 +0000

I need to upgrade kopf to fix a bug, but the required version depends on a newer Python.
I'm not sure how Python is installed in your base image — is it provided via PYTHON_TARBALL in this script?
Is this a custom-built Python package maintained internally?

MySQL Workbench (no replies)

Nick Cole — Wed, 01 Apr 2026 17:00:53 +0000

Why does Workbench not allow us to DISCONNECT from a database. Connection deleted, but it still connects even if there is a connection to a different database.
ALL sql commands operate on the UNWANTED database.
There are aspects of this tool which are so useless!
Code entered in the editor, after copying from a text editor produce a sql error. yet copying the exact same code into the command line editor run fine.
Is workbench only able to connect to a single database?
It does not allow us to specify a paarticular one anyway.
This is the latest version too.

Database wont start (no replies)

Jie D — Sun, 29 Mar 2026 20:34:29 +0000

We Recently installed new artifacts on our server and now mysql will not start. any help is appreciated. it told us to copy and paste this in the forums so heres what i got. thank you for any help in advance
4:26:39 PM [main] Initializing Control Panel
4:26:39 PM [main] Windows Version: 64-bit
4:26:39 PM [main] XAMPP Version: 8.2.12
4:26:39 PM [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
4:26:39 PM [main] Running with Administrator rights - good!
4:26:39 PM [main] XAMPP Installation Directory: "c:\users\administrator\desktop\xampp\"
4:26:39 PM [main] Checking for prerequisites
4:26:39 PM [main] All prerequisites found
4:26:39 PM [main] Initializing Modules
4:26:39 PM [Apache] XAMPP Apache is already running on port 80
4:26:39 PM [Apache] XAMPP Apache is already running on port 443
4:26:39 PM [mysql] MySQL Service detected with wrong path
4:26:39 PM [mysql] Change XAMPP MySQL and Control Panel settings or
4:26:39 PM [mysql] Uninstall/disable the other service manually first
4:26:39 PM [mysql] Found Path: C:\Users\Administrator\Desktop\XAMPP\mysql\bin\mysqld --defaults-file=C:\Users\Administrator\Desktop\XAMPP\mysql\bin\my.ini mysql
4:26:39 PM [mysql] Expected Path: c:\users\administrator\desktop\xampp\mysql\bin\mysqld.exe --defaults-file=c:\users\administrator\desktop\xampp\mysql\bin\my.ini mysql
4:26:39 PM [main] The FileZilla module is disabled
4:26:39 PM [main] The Mercury module is disabled
4:26:39 PM [main] The Tomcat module is disabled
4:26:39 PM [main] Enabling autostart for module "Apache"
4:26:39 PM [main] Enabling autostart for module "MySQL"
4:26:39 PM [main] Starting Check-Timer
4:26:39 PM [main] Control Panel Ready
4:26:40 PM [Apache] Autostart aborted: Apache is already running
4:26:40 PM [mysql] Autostart active: starting...
4:26:40 PM [mysql] Attempting to start MySQL service...
4:26:40 PM [mysql] Status change detected: running
4:26:47 PM [mysql] Status change detected: stopped
4:26:47 PM [mysql] Error: MySQL shutdown unexpectedly.
4:26:47 PM [mysql] This may be due to a blocked port, missing dependencies,
4:26:47 PM [mysql] improper privileges, a crash, or a shutdown by another method.
4:26:47 PM [mysql] Press the Logs button to view error logs and check
4:26:47 PM [mysql] the Windows Event Viewer for more clues
4:26:47 PM [mysql] If you need more help, copy and post this
4:26:47 PM [mysql] entire log window on the forums

Oracle MySQL Community Early Access (EA) Builds: MySQL 9.7.0 EA now available (no replies)

Lenka Kašparová — Wed, 18 Mar 2026 12:38:56 +0000

The MySQL 9.7.0 Community Edition Early Access (EA) Release build is now available on MySQL Labs.
======================
As part of our continued focus on MySQL Community collaboration, we’re pursuing a three-pronged strategy:

1. Deliver innovation by introducing developer-focused features into MySQL Community Edition
2. Extend and enrich the ecosystem and adoption
3. Increase transparency and encourage broader community participation

What’s new in MySQL 9.7.0 (feature highlights)
======================
The release notes remain the authoritative source for complete details and final behavior. Highlights include:

* Flow-control monitoring for MySQL InnoDB Cluster (Group Replication)
* MySQL JSON Duality Views
* Hypergraph Optimizer
* Telemetry (OpenTelemetry / OTLP)
* Profile-Guided Optimization (PGO)
* Multi-threaded applier: extended applier statistics (new replication observability tables)

Early Access (EA) builds: intended for early feedback
======================
EA builds are pre-GA / developer preview packages meant for testing and feedback before GA. They may change prior to GA and are not intended for production use.

Download EA builds: https://labs.mysql.com/

Join the discussion (and help shape what’s next)
======================
Our next public MySQL Community discussion is on March 23:
Public MySQL Community Roadmap Discussion Webinar (Edition #2)
Registration: https://oracle.zoom.us/webinar/register/WN_KSzOt8qTRNm6q7ez-5ym_Q?_x_zm_rtaid=W8ywnK#/registration

Worklogs (WL): increased transparency
======================
We have also resumed publishing selected MySQL Worklogs (WL) to increase transparency and invite earlier design feedback:
https://dev.mysql.com/worklog/

More info and links
======================
* Blog post (full context + details): https://blogs.oracle.com/mysql/mysql-community-early-access-builds
* EA builds download page: https://labs.mysql.com/
* Webinar registration: https://oracle.zoom.us/webinar/register/WN_KSzOt8qTRNm6q7ez-5ym_Q?_x_zm_rtaid=W8ywnK#/registration
* Worklogs: https://dev.mysql.com/worklog/
* Report and view bugs: https://bugs.mysql.com/
* MySQL on GitHub: https://github.com/mysql/
* MySQL Community Slack channel: http://mysqlcommunity.slack.com/

Who designed this all but useless tool? (no replies)

Nick Cole — Mon, 16 Mar 2026 20:06:39 +0000

Why not ask for a directory of where the data is held?
Why not have a list of users to manage?
Migration task list does NOTHING, CANNOT MIGRATE withoUT SPECIFYING WHAT TO MIGRATE FROM AND TO!
How do we specify where the data is stored?
cannot connect to a previous database set up under mySQL.

Someone clearly hasn't thought through these basic functional processes.
cannot bulk load data, and neither have hundreds of other people.

MYSQL 8.4.8 CE - Group Replication - read_only ON (2 replies)

Mircea Ispasoiu — Mon, 23 Mar 2026 16:21:41 +0000

Hello,

I have an issue with a cluster from 3 nodes and Group replication, oracle linux 9.7 and MYSQL CE 8.4.8.

Every time I restart the mysqld service the read_only and super_read_only remain ON.

If I check the cluster all nodes are online and primary and no errors (it`s a multi master).

What`s the problem ?

I`ve tried to set the /etc/my.cnf with setting:
read_only = OFF
super_read_only = OFF

but no success.

Once I restart mysqld service read_only came back to ON.

Thank you.

Tips for Optimizing MySQL Queries for Beginners (no replies)

Funnelsflex Team — Wed, 25 Feb 2026 18:07:39 +0000

Hi everyone,

I’m new to MySQL and learning how to manage databases efficiently. I’ve noticed that some queries, especially when joining tables or filtering large datasets, can be slower than expected.

I’d love some advice on a few things:

How to use indexes effectively without slowing down insert/update operations.

Best practices for writing joins and subqueries to make queries faster.

Ways to monitor slow queries and find bottlenecks.

Tips on structuring tables and choosing the right data types for better performance.

Any guidance, examples, or beginner-friendly tips would be very helpful. I’m eager to learn from the community’s experience and improve my database skills.

Thanks in advance for your insights!

AWS Ubuntu / MariaDB / MySQL can't view tables but data looks like it's there (no replies)

Christopher Feeny — Tue, 24 Feb 2026 21:58:32 +0000

Recently my phpBB forums stopped working with DB errors, I tried to go and view the tables and nothing returns. I went to the /lib/ mysql directory and the DB directory is there and full of the files many very large, but I cannot access them.

I also get authentication errors now. I have root/ownership of the domain.

Ubuntu is the latest LTS release.

Can someone help?

Alter table variable value (1 reply)

David person — Mon, 23 Feb 2026 10:46:03 +0000

I have been trying to figure out how to change a value in a table variable in a MySQL database, but I've hit nothing but syntax errors, despite copying and pasting commands from bits I can find. I started at the CLI and couldn't find the commands to work, so I was going to try with the MySQL Workbench from my PC. I disabled the firewall, changed the binding to allow remote machines to connect, and then tried to grant access from both any machine or just my IP and that's where the syntax errors came in. Even direct copying and pasting full commands, changing that which needed to be changed resulted in the same syntax errors.

Ideally, I'd prefer to change it from the mysql cli in Linux as with the right command, that's probably super simple, the problem is I can't find the right command. Nothing I've found has worked.

I can get all the way down to looking the variable in the table after selecting the database, but I can't get further than that.

mysql> select * from my_variables\G;
*************************** 1. row ***************************
variable_id: 1
variable_name: padding_tile
variable_datetime_utc: 2026-02-21 19:04:23
variable_value: 754
variable_type: int

Could someone please tell me what command I'd need to run to change the 'variable_value' of '754' to something else? It seems this should be so simple, but I haven't been able to find a clear command.

Workbench running as background task after start, connect, exit (no replies)

Ron James — Tue, 17 Feb 2026 17:19:31 +0000

I’ve just installed MySQL Workbench Version 8.0.44 build 5549652 CE (64 bits) Community on Windows 11 Pro OS Build 26200.7840, Version 25H2.

I start the program, connect to a remote database and then exit the program. The program will no longer start from its shortcut. Task Manager reveals that it’s running as a background task, not as a service, just as a background task.

Killing the background task enables the program to start from its shortcut.

I did initially have MySql running as a service via xampp but I’ve subsequently uninstalled that service and rebooted. Still have the issue.

What’s going on?

Thanks in advance.

Ron James

MacBook compatbility? (no replies)

PATRICK DIXON — Fri, 13 Feb 2026 01:20:33 +0000

I am currently running WorkBench 8 on a MacBook Pro 2019 with 2.6 ghz 6core Intel i7, 16 GM RAM, 2 TB hard drive. I am considering upgrading to MacBook M4 Max 16core, 48GB RAM, 4 TB hard drive.
Will I have any compatibility issues with your application?
How do I migrate?

Mysql community edition upgrade from 8.0.36 to 8.4 (LTS) (no replies)

Raja Pathri — Thu, 12 Feb 2026 09:17:15 +0000

Could you please advise if anyone has successfully upgraded MySQL Community Edition from 8.0.36 to 8.4?

We are planning to upgrade from MySQL 8.0.36 (Community Edition) to MySQL 8.4, and before proceeding we would like confirmation/guidance from the MySQL community (or any official references) on the following:

Whether a direct in-place upgrade from 8.0.36 → 8.4 is supported (or if an intermediate upgrade step/version is recommended).

Any required pre-upgrade steps or mandatory fixes that should be completed prior to the upgrade.

Any known issues, upgrade advisories, or common pitfalls for this upgrade path.

Any deprecated or removed features in MySQL 8.4 that could impact existing workloads.

Environment details (for context):

Current version: MySQL 8.0.36 (Community)

Target version: MySQL 8.4 (Community)

Platform: [AWS EC2 ]

Application: Axway B2Bi (application layer already verified compatible with 8.4)

Thank you in advance for any guidance or links to relevant documentation.

How can I implement MySQL connection pooling in a Python Flask or Django application? (1 reply)

harishma kumar — Fri, 06 Mar 2026 18:14:05 +0000

Hello everyone,

I am developing a web application using Python with either Flask or Django, and MySQL as the backend database. As the application grows, I want to manage database connections efficiently and avoid opening a new connection for every request.

I would like to know:

What is the recommended way to implement MySQL connection pooling in Flask or Django?

Which libraries or tools work best for connection pooling (SQLAlchemy, mysql-connector, PyMySQL, etc.)?

How should pool size and timeout values be configured for a production environment?

Are there any common mistakes or performance issues to watch out for when using connection pooling?

If possible, sample code snippets or real-world experiences would be very helpful.

Thanks in advance for your guidance.

Announcing January 2026 Releases featuring MySQL Server 9.6.0 Innovation, 8.4.8 LTS and 8.0.45 (no replies)

Balasubramanian Kandasamy — Fri, 23 Jan 2026 17:56:47 +0000


Dear MySQL users,

We are pleased to announce the release of the following products:

    * MySQL Server 9.6.0 Innovation, 8.4.8 LTS, and 8.0.45
    * MySQL Shell, Router 9.6.0, 8.4.8, and 8.0.45
    * MySQL 9.6.0 Connectors
    * MySQL NDB Cluster 9.6.0, 8.4.8, 8.0.45, and 7.6.37

These releases are recommended for use on production systems and are
available in source and binary form for a number of platforms from our
MySQL Community download pages at:

https://dev.mysql.com/downloads/

Regardless of server version, always use the latest version of MySQL
Clients, Tools, and Connectors as they support both MySQL Server 8.0
and 8.4 LTS too.

Windows packages are available via the Installer for Windows or .ZIP
(no-install) packages for more advanced needs. The point and click
configuration wizards and MySQL products are available in the unified
Installer for Windows:

https://dev.mysql.com/downloads/installer/

Enterprise binaries for these new releases are available on My Oracle
Support:

https://support.oracle.com

Choose the “Patches & Updates” tab, and then choose the “Product or
Family (Advanced Search)” side tab in the “Patch Search” portlet.

MySQL Enterprise binaries are also available on the Oracle Software
Delivery Cloud:

https://edelivery.oracle.com/

Developers can download MySQL Enterprise Edition from

https://www.oracle.com/mysql/technologies/mysql-enterprise-edition-downloads.html

Innovation releases are supported until the next innovation release, and
are recommended for production use. The 8.0 and 8.4 series
will focus on security and bug fixes only. Please refer to the following
for more information:

https://dev.mysql.com/doc/refman/8.4/en/mysql-releases.html

Changes since the previous releases can be viewed online:

https://dev.mysql.com/doc/#current-release-notes

On Behalf of the MySQL Engineering Team,
Balasubramanian Kandasamy

conversion from Mar-2026 to 03-2026 and vice versa (1 reply)

Smith John — Tue, 10 Feb 2026 12:19:58 +0000

I am new to PHP & MySQL, struggling to learn the technology (absolute beginner). now I want to convert a VARCHAR column name is SALARY_MONTH, it contains data like: Mar-2025 now I want this in 03-2025 format (vice versa too).
please help to achieve this.

I tried below in PhpMyAdmin Console but it returns NULL.

--- start
SELECT DATE_FORMAT(
STR_TO_DATE('Mar-2025', '%b-%Y'),
'%c-%Y'
) AS result;
--- end

thanks in advance.

MySQL 8.0.42 Installer, ODBC 9.3.0 and Connector/J removed from Archives – any official explanation? (2 replies)

Dhamotharan Sivaraman — Fri, 20 Feb 2026 04:59:52 +0000

Hello,

We noticed that the following MySQL artifacts are no longer available in the MySQL Product Archives:

- MySQL Installer Community MSI 8.0.42
- MySQL Connector/ODBC 9.3.0 MSI
- MySQL Connector/J corresponding to MySQL 8.0.42

Other surrounding versions such as 8.0.41 and 8.0.43 are still present in the archive, but exactly these versions are missing.

We were using these versions as prerequisites in our enterprise product installer, and customers are now unable to download them from the official MySQL site.

Could someone from Oracle or the community please clarify:

1. Were these artifacts intentionally removed from the archives?
2. Was there any official announcement or document about this removal?
3. Is there any possibility these versions will be restored in the archives?
4. What is the officially recommended replacement version?

Thank you for your guidance.

Tips for Optimizing MySQL Performance on a Small Server (no replies)

John Ackerman — Tue, 20 Jan 2026 07:50:10 +0000

Hello,

I’m running MySQL on a small server and looking for general advice on improving performance. The database has moderate traffic, and I’d like to optimize it for efficiency and future growth.

Any recommendations on configuration settings, indexing, or tools for identifying slow queries would be appreciated.

Thanks!

How can I fix Engine errors after migration from 5.7 to 8 (no replies)

Vito Cavallo — Sun, 18 Jan 2026 20:37:25 +0000

I am migrating 6 databases from MySQL 5.7.44 to 8.0.44 and ran into issues with some lacking InnoDB engines.

I used mysqldump command to export databases to an sql file.
I was able restore only with mysql < database-file.sql. Nothing else worked.

Terminal and MySQL workbench worked fine, i can see schemas and tables.
I gracefully shut down the mysql server and rebooted the physical server.

After restarting the mysql server threw errors. Some databases, I believe mysql were MySAM engine. They need to be InnoDB engine.

I am starting the 3 day import again into a clean installation.
I will hold off on the reboot.

Can I alter if running?
How can I alter tables after import?

Is there a better way to backup mysql 5.7 databases for easier 8.0 import?

All the documentation I read recommends mysqldump. Never a mention of converting engines.

Thank YOu.

having problem with MySQL (no replies)

Alonzo Lattimore — Thu, 08 Jan 2026 20:31:44 +0000

Hopefully I'm in the right place where I can ask for some help. MY daughter wants to start a freight dispatching business I'm trying to make it as foolproof as possible I've go the site built having problems with MySQL to build the traccar server so she can track the drivers in real time. Anyone know of any MySQL Jedi Masters this young padawan needs help any guidance putting me on the right path is greatly appreciated by me and my daughter.

How to properly use mysql_config (no replies)

Igor Korot — Sun, 04 Jan 2026 21:18:28 +0000

Hi, ALL,
In my Makefile.am I have the following:

libmysql_lib_la_CXXFLAGS = `mysql_config \
   --cflags` \
   -I../../dbinterface \
   -DUNICODE \
   @DBTOOLKIT@

libmysql_lib_la_LDFLAGS = `mysql_config \
   --libs`

Is _LDFLAGS correct place? Or I should put it in some other variable, namely _LIBS?

Thank you.

My SQL Workbench: Check for updates error solved in macOS (no replies)

Alex Garcia Alegre — Sun, 28 Dec 2025 03:47:55 +0000

# Fix para HTTPS en MySQL Workbench

## Problema
El módulo SSL de Python en MySQL Workbench no puede cargar `libssl.3.dylib` debido a que la aplicación usa "hardened runtime" en macOS.

Error:
```
dlopen(.../_ssl.cpython-312-darwin.so, 0x0002): Library not loaded: libssl.3.dylib
Reason: tried: 'libssl.3.dylib' (relative path not allowed in hardened program)
```

## Solución
Modificar el archivo `wb_utils_grt.py` para usar `curl` en lugar del módulo SSL de Python.

## Archivo a modificar
`/Applications/MySQLWorkbench.app/Contents/Resources/plugins/wb_utils_grt.py`

## Cambios a aplicar

### Cambio 1: Líneas ~590-600 (importación de SSL)

**ANTES:**
```python
self.is_running = True
try:
import urllib.request, urllib.error, urllib.parse
import json
import base64
import ssl
```

**DESPUÉS:**
```python
self.is_running = True
try:
import urllib.request, urllib.error, urllib.parse
import json
import base64

# Check if SSL module is available
ssl_available = False
try:
import ssl
ssl_available = True
except (ImportError, OSError):
# SSL module not available, will use curl as fallback
pass
```

### Cambio 2: Líneas ~717-760 (petición HTTPS)

**ANTES:**
```python
urllib.request.install_opener(opener)

self.json = json.load(urllib.request.urlopen("https://workbench.mysql.com/current-release";))
```

**DESPUÉS:**
```python
urllib.request.install_opener(opener)

# Try to fetch update information
url = "https://workbench.mysql.com/current-release";

# First, try using curl as it has its own SSL/TLS support
try:
import subprocess
result = subprocess.run(['curl', '-s', '-L', url],
capture_output=True,
text=True,
timeout=10)
if result.returncode == 0 and result.stdout:
self.json = json.loads(result.stdout)
else:
raise Exception("curl failed or returned empty response")
except Exception as curl_error:
# Fallback to urllib if curl fails
if not ssl_available:
raise Exception("HTTPS support is not available.\n\n"
"The SSL module cannot be loaded and curl is not available.\n"
"You can check for updates manually at:\n"
"https://www.mysql.com/downloads/workbench/";)

try:
context = ssl._create_unverified_context()
self.json = json.load(urllib.request.urlopen(url, context=context))
except AttributeError:
self.json = json.load(urllib.request.urlopen(url))
except urllib.error.URLError as e:
error_msg = str(e)
if 'unknown url type: https' in error_msg or 'CERTIFICATE_VERIFY_FAILED' in error_msg:
raise Exception("HTTPS support is not available.\n"
"You can check for updates manually at:\n"
"https://www.mysql.com/downloads/workbench/";)
else:
raise
```

## Cómo funciona la solución

1. **Detección de SSL**: Intenta importar el módulo `ssl` pero captura el error sin fallar
2. **Uso de curl**: Usa `curl` (que tiene su propio soporte SSL/TLS) como método principal
3. **Fallback a urllib**: Si curl falla y SSL está disponible, intenta con urllib
4. **Mensajes claros**: Proporciona mensajes de error informativos al usuario

## Ventajas

- ✅ No requiere modificar binarios del sistema
- ✅ No requiere deshabilitar SIP
- ✅ No requiere enlaces simbólicos de bibliotecas
- ✅ Usa herramientas del sistema (curl) que tienen SSL integrado
- ✅ Mantiene compatibilidad si SSL funciona en futuras versiones

## Aplicar después de actualizar

Si MySQL Workbench se actualiza y el problema persiste, simplemente vuelve a aplicar estos cambios al nuevo archivo `wb_utils_grt.py`.

---
Fecha: 28 de diciembre de 2025

Forgot my password (no replies)

Shirley Bowen — Mon, 22 Dec 2025 07:19:48 +0000

I need the cli command used to change a password. I tried in phpmyadmin and it shows changed but it's not working when I go to login to the admin panel of the site. I did use MD5 and tried SHA1 as well. So let say I need a command for the following:

Database: myacct_dbname
Table: 1_users
Field: password

So I want to change the admin password for a site admin in the myacct_dbname database under the 1_users table. Any help is appreciated thank you.

MySQL support for Windows Server 2025 (2 replies)

Duong Nguyen — Thu, 02 Apr 2026 13:25:33 +0000

Hi MySQL team

I saw that Windows Server 2025 is not yet a supported OS for MySQL.
https://www.mysql.com/jp/support/supportedplatforms/database.html

Do we have plan to support Windows Server 2025?
It would be great if MySQL 8.4 usage on Windows Server 2025 can be supported.

What can be done to ensure this?

Best regards,
Duong

Best MySQL schema for ZIP-code based weather prediction data? (no replies)

USASnow DayCalculator — Fri, 19 Dec 2025 10:31:27 +0000

Hi everyone,

I’m working on a small project that predicts school closures based on
weather conditions (snowfall, temperature, alerts).

The system collects:
- ZIP code
- Hourly weather metrics
- Probability scores (0–100)
- Timestamped updates

I’m unsure whether a single table with indexed ZIP codes is enough,
or if partitioning by state/date would be better for performance.

Any advice on schema design or indexing strategies would be appreciated.
Thanks!

util.dump requires mysql.user read priv (no replies)

Krzysztof Wróblewski — Sun, 14 Dec 2025 19:35:26 +0000

Hello,
I would like to propagate using mysql.shell util.dump tools in developers' area (to migrate tables or databases). It's nice tool and it has many advantages... but, I cannot do this because of this error:

ERROR: Unable to check privileges for user 'user'@'localhost'. User requires SELECT privilege on mysql.* to obtain information about all roles.

For specific user, who is not administrator, I cannot give reading mysql schema privilege due security reason.
I don't see also any workaround.

Why for dumping single table or even schema, there is a need read whole mysql schema?

For mysqldump it's not needed.

Any tips how to use these tools by non-administrative accounts?
If not, then it's useless for devs.

FULLTEXT initialization 200s (no replies)

a a — Sun, 14 Dec 2025 17:56:11 +0000

I found this issue when migrating servers in 2025/11. I migrated mysql to a server with almost the same configuration. The version is 5.7.44. There are some specific SQL sessions that are particularly long. However, this problem does not occur with the same data and the same SQL statement on other servers, and I tried to revert to 5.7.40 and still has this problem.
https://dba.stackexchange.com/questions/87089/full-text-search-results-in-a-large-amount-of-time-spent-in-fulltext-initializa
My question is almost the same. And all tried. There are still problems. The queried table has 1000w pieces of data.

For example, this one.
select id from problem WHERE MATCH (problem_text) AGAINST ('下面关于Android操作系统的描述中，正确的是' IN BOOLEAN MODE) and is_del = 0 limit 5;
FULLTEXT initialization has 200s. But when I switch to NATURAL LANGUAGE MODE, I don't have this problem. But NATURAL LANGUAGE MODE is too poor at matching short texts

Comment vérifier les privilèges après une erreur "Access denied" (no replies)

benjamin chef — Tue, 09 Dec 2025 12:04:11 +0000

Bonjour,

J'essaie de connecter mon script PHP (explain.php) à ma base de données MySQL locale (via XAMPP). Je reçois une erreur Access denied for user 'mjvincent'@'localhost'.

Voici l'erreur complète :

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'beni88'@'localhost' (using password: YES) in C:\xampp\htdocs\lesson1\explain.php:17 ...
J'ai confirmé que le nom d'utilisateur et le mot de passe que j'utilise dans mysqli_connect() sont bien ceux que j'ai définis.

Si le mot de passe est bon, l'erreur suggère-t-elle que l'utilisateur mjvincent :

N'a pas été correctement créé pour l'hôte localhost ?

Existe, mais ne possède pas les permissions GRANT nécessaires pour accéder à la base de données CustomerDatabase ?

Quelles requêtes dois-je exécuter dans la console MySQL (ou phpMyAdmin) pour vérifier l'existence et les privilèges exacts de cet utilisateur afin de corriger le problème ?

Gap lock failure (1 reply)

Eve Li — Wed, 08 Apr 2026 14:36:36 +0000

Hello. I learned that in MySQL, we might insert multiple rows with the same id into a primary key field because of its gap lock failure. Does anyone have any insight about the details regarding the gap lock failure?

Stored procedure create through odbc driver (2 replies)

Robert Gilland — Wed, 10 Dec 2025 16:34:58 +0000

How to create a stored procedure via odbc. Can odbc use set delimiter?

Help with REGEXP in mySQL WHERE (no replies)

James A Wilson — Thu, 04 Dec 2025 17:54:26 +0000

I have a large mySQL Db table that contain cemetery burial information. One field contains military information about service branch and campaigns (e.g., Korea, Vietnam).

Using a string search value with %...% works fine for most of the campaigns. But, searching for %World War I% also selects the records containing 'World War II'. Thus, I changed the search to use a REGEXP '\bWorld War I\b' but this returns zero records.

This is the code...

SELECT * FROM memorials
LEFT JOIN cemeteries ON cem_id = per_cemid
WHERE per_cemid = 134
AND (per_mil_inscription REGEXP '\bWorld War I\b'
OR per_mil_notes REGEXP '\bWorld War I\b')

The code doesn't work in my PHP code and doesn't work in a cPanel SQL query.

What am I doing wrong?

TIA for any assistance