Forum for New Users of MySQL. https://forums.mysql.com/list.php?10 Mon, 20 Apr 2026 15:10:29 +0000 Phorum 5.2.23 https://forums.mysql.com/read.php?10,741759,741759#msg-741759 https://forums.mysql.com/read.php?10,741759,741759#msg-741759
Can't change the password using windows terminal because it says mysqld is not recognised.
Just kinda confused because I havent had any issue using mySQL in university or having to input a password to open connections there, not sure if i set something up wrong.]]> Javier Nguyen Newbie Wed, 15 Apr 2026 08:35:47 +0000 https://forums.mysql.com/read.php?10,741708,741708#msg-741708 https://forums.mysql.com/read.php?10,741708,741708#msg-741708 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]]> Jie D Newbie Sun, 29 Mar 2026 20:34:29 +0000 https://forums.mysql.com/read.php?10,741651,741651#msg-741651 https://forums.mysql.com/read.php?10,741651,741651#msg-741651
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!]]> Funnelsflex Team Newbie Wed, 25 Feb 2026 18:07:39 +0000 https://forums.mysql.com/read.php?10,741640,741640#msg-741640 https://forums.mysql.com/read.php?10,741640,741640#msg-741640
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.]]> David person Newbie Mon, 23 Feb 2026 10:46:03 +0000 https://forums.mysql.com/read.php?10,741583,741583#msg-741583 https://forums.mysql.com/read.php?10,741583,741583#msg-741583
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.]]> harishma kumar Newbie Fri, 06 Mar 2026 18:14:05 +0000 https://forums.mysql.com/read.php?10,741567,741567#msg-741567 https://forums.mysql.com/read.php?10,741567,741567#msg-741567 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.]]> Smith John Newbie Tue, 10 Feb 2026 12:19:58 +0000 https://forums.mysql.com/read.php?10,741538,741538#msg-741538 https://forums.mysql.com/read.php?10,741538,741538#msg-741538 Alonzo Lattimore Newbie Thu, 08 Jan 2026 20:31:44 +0000 https://forums.mysql.com/read.php?10,741501,741501#msg-741501 https://forums.mysql.com/read.php?10,741501,741501#msg-741501
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.]]> Shirley Bowen Newbie Mon, 22 Dec 2025 07:19:48 +0000 https://forums.mysql.com/read.php?10,741497,741497#msg-741497 https://forums.mysql.com/read.php?10,741497,741497#msg-741497
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!]]> USASnow DayCalculator Newbie Fri, 19 Dec 2025 10:31:27 +0000 https://forums.mysql.com/read.php?10,741460,741460#msg-741460 https://forums.mysql.com/read.php?10,741460,741460#msg-741460
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]]> James A Wilson Newbie Thu, 04 Dec 2025 17:54:26 +0000 https://forums.mysql.com/read.php?10,741456,741456#msg-741456 https://forums.mysql.com/read.php?10,741456,741456#msg-741456 Thank you]]> Panagiotis Adam Newbie Wed, 03 Dec 2025 16:56:43 +0000 https://forums.mysql.com/read.php?10,741446,741446#msg-741446 https://forums.mysql.com/read.php?10,741446,741446#msg-741446 Unfortunately, the workbench home screen as shown in the tutorial does not match the home screen on my workbench.
(I was hoping that I would be able to attach 2 jpg files to this to show the differences)
Can anyone help me with this rather annoying start?]]> Andrew Greenwood Newbie Sun, 30 Nov 2025 16:09:04 +0000 https://forums.mysql.com/read.php?10,741431,741431#msg-741431 https://forums.mysql.com/read.php?10,741431,741431#msg-741431
Im trying to edit my database that contains data from a tracker. I wish to delete the values for the odometer, but the value is in a column named `attributes` which contains mutiple data in each cell like below

{"operator":23410,"odometer":4.9654157716276E7,"io83":1265,"io87":51129600,"distance":3.28,"totalDistance":688005.33,"fuel":999873.5,"hours":61446060,"Sleep Mode":"Awake","Mobile Network":"o2","FMC Battery":"3.924","Car Battery":"15.027000000000001","Speed":12,"Fuel Tank (%)":25,"Engine RPM":727,"Total Fuel used (l)":126.5}

I've tried update but can't seem to select the value "odometer" in the column `attributes`

Any help appreciate]]> Adam Bateman Newbie Thu, 27 Nov 2025 13:30:27 +0000 https://forums.mysql.com/read.php?10,741402,741402#msg-741402 https://forums.mysql.com/read.php?10,741402,741402#msg-741402
Complete newbie to MySQL.

So I have installed MySQL 8.0.44 on RHEL 9

a mysql linux account is automatically created but has no shell enabled. So to switch to the mysql linux account I run

su - mysql --shell=/bin/bash

When trying to start mysqld as the mysql user I am prompted for the root password.

uid=27(mysql) gid=27(mysql) groups=27(mysql)
$ systemctl start mysqld
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====
Authentication is required to start 'mysqld.service'.
Authenticating as: root
Password:

I have been using OS root to stop and start mysqld but I want to move away from using the OS root user.

All mysql files and directories are owned by the mysql linux account.

So my questions are:

1. Should the mysql account have privileges to start/stop mysqld without prompting for root password?

2. What is best practice for the mysql linux account? is it ok for the user to have login permissions?

Many Thanks]]> Karl Champion Newbie Thu, 20 Nov 2025 09:59:48 +0000 https://forums.mysql.com/read.php?10,741388,741388#msg-741388 https://forums.mysql.com/read.php?10,741388,741388#msg-741388 mysql=8.0.xx
MysqlI Support = enabled
Client API library version = mysqlnd 8.3.27

Getting back into php/mysql after 2 decades with cf/sqlserver.

database connecting, selecting, ordering is fine

Display error when I want to draw a table of first/last names

display code fails at this line

while($row = $result->mysqli_fetch_assoc())


Fatal error: Uncaught Error: Call to a member function mysqli_fetch_assoc() on string in.....

Been on google for hours. Now here. :(

Thanks]]> M. Masters Newbie Thu, 26 Feb 2026 18:50:17 +0000 https://forums.mysql.com/read.php?10,741386,741386#msg-741386 https://forums.mysql.com/read.php?10,741386,741386#msg-741386
Has anyone here experimented with combining AI tools (like SchriftGenerators for custom fonts) with MySQL to create dynamic, visually styled content? Any tips on storing font styles, handling text formatting, or best practices for database design in this context would be greatly appreciated.

Thanks!]]> Ddavid Lee Newbie Sat, 15 Nov 2025 07:35:59 +0000 https://forums.mysql.com/read.php?10,741382,741382#msg-741382 https://forums.mysql.com/read.php?10,741382,741382#msg-741382
I started a topic in the german forum two days ago and two days later it was still not approved.

Oracle, is this forum dead?

Best regards
raZe]]> Ramon Dohle Newbie Fri, 28 Nov 2025 19:19:55 +0000 https://forums.mysql.com/read.php?10,741377,741377#msg-741377 https://forums.mysql.com/read.php?10,741377,741377#msg-741377
Normally for analyzing the long running queries or associated performance issues , its advisable to set parameters like "slow_query_log" in mysql database or "log_min_duration_statement" in postgres. And with this all the queries running beyond certain duration will gets logged into the database log.

In case of cloud databases like aws aurora mysql/postgres which eventually pushed the logs to cloudwatch. And then on top of that cloudwatch logs, we can do alerting or do the analysis in case of any performance issues.

However, I wanted to understand how things work in case of some organizations which deals with PI or PCI data like say for e.g. financial institutions. As because in these cases there happens to be some sensitive information exposed in the cloudwatch logs which may be embeded as part of the literals in the sql query text. So how should one cater to this requirement?

Basically wants to have these logging features enabled at the same time not breaking the regulatory requirement of "not exposing any sensitive information inadvertently" ? As because we may not have full control on what people embeded in the sql text in a large organization with 100's of developer and support guys running queries in the database 24/7.]]> Jasper Callahan Newbie Wed, 25 Feb 2026 12:41:46 +0000 https://forums.mysql.com/read.php?10,741292,741292#msg-741292 https://forums.mysql.com/read.php?10,741292,741292#msg-741292
We are using aurora mysql database.

Is there any dowsnide of enabling slow_query_log in mysql in production? and also to what value we should be setting it to be in safe side without impacting any other?]]> Sheryl Carlson Newbie Fri, 28 Nov 2025 19:12:12 +0000 https://forums.mysql.com/read.php?10,741285,741285#msg-741285 https://forums.mysql.com/read.php?10,741285,741285#msg-741285
Oracle said they are focusing on HeatWave and AI within OCI but what about us that use MySQL for few decades? I know there are MariaDB and that Percona have their fork too but both are heavily dependent on the Oracle work. If Oracle is scrapping MySQL - what is the best course of action now? Should we look at alternatives immediately or should we hope someone will pick up all the riffed engineers and continue the work (e.g. Meta as one of the biggest users or Amazon that already have a big team working on MySQL source) and we hope they will share it with rest of us? Problem is we already know Amazon is not sharing their work.]]> Sheryl Carlson Newbie Thu, 26 Feb 2026 19:01:25 +0000 https://forums.mysql.com/read.php?10,741284,741284#msg-741284 https://forums.mysql.com/read.php?10,741284,741284#msg-741284
I’ve been working on improving the performance of MySQL databases used in high-traffic web applications. While exploring different caching and query optimization techniques, I found some helpful tools and tutorials that really boosted my understanding.

For example, using query indexing, JOIN optimization, and connection pooling helped reduce response times significantly.

I also write about MySQL-related automation, AI integrations, and backend optimization on my personal tech blog — you can check it here:
👉 Learn more about MySQL optimization here

Would love to hear your tips too —

What’s your favorite method for caching or reducing query load?

Do you prefer MyISAM or InnoDB for large-scale systems?

Thanks in advance for sharing your insights! 🙌]]> Edward James Newbie Thu, 09 Oct 2025 11:33:21 +0000 https://forums.mysql.com/read.php?10,741259,741259#msg-741259 https://forums.mysql.com/read.php?10,741259,741259#msg-741259 dpkg -i mysql-apt-config_0.8.34-1_all.deb
Which launches the installer, but initially, as it didn't have a Trixie option listed, I selected the Abort option so I could research what to do. Now I know I can use the Bookworm option (with a manual install of libaio1), I am re-running the above, but on the second time of running exactly the same command as above, nothing happens!

dpkg -i mysql-apt-config_0.8.34-1_all.deb
(Reading database ... 34911 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.34-1_all.deb ...
Unpacking mysql-apt-config (0.8.34-1) over (0.8.34-1) ...
Setting up mysql-apt-config (0.8.34-1) ...

And then I am returned to the prompt?!

How do IRunn run the installer a second time so I can continue?]]> Alan Ingram Newbie Fri, 03 Oct 2025 23:16:17 +0000 https://forums.mysql.com/read.php?10,741246,741246#msg-741246 https://forums.mysql.com/read.php?10,741246,741246#msg-741246 Pearl Goodwin Newbie Fri, 26 Sep 2025 08:29:40 +0000 https://forums.mysql.com/read.php?10,741205,741205#msg-741205 https://forums.mysql.com/read.php?10,741205,741205#msg-741205
One - No Cost

MySQL Workbench 8.0 – Export/Import

7-Zip – AES-256 encryption

PowerShell – SHA-256 checksum

WinSCP/FileZilla – Secure file transfer

Windows Sandbox / Docker – Isolated testing

Two - Cloud Cost

MySQL Workbench 8.0 – Export/Import

Egnyte Secure File Sharing – Encrypted storage & transfer [Cost$$$]

PowerShell – SHA-256 checksum

Windows Sandbox / Docker – Isolated restore & validation]]> Marion Terry Newbie Thu, 02 Oct 2025 12:29:23 +0000 https://forums.mysql.com/read.php?10,741199,741199#msg-741199 https://forums.mysql.com/read.php?10,741199,741199#msg-741199
One - No Cost

MySQL Workbench 8.0 – Export/Import

7-Zip – AES-256 encryption

PowerShell – SHA-256 checksum

WinSCP/FileZilla – Secure file transfer

Windows Sandbox / Docker – Isolated testing

Two - Cloud Cost

MySQL Workbench 8.0 – Export/Import

Egnyte Secure File Sharing – Encrypted storage & transfer [Cost$$$]

PowerShell – SHA-256 checksum

Windows Sandbox / Docker – Isolated restore & validation]]> Marion Terry Newbie Mon, 06 Oct 2025 17:35:19 +0000 https://forums.mysql.com/read.php?10,741194,741194#msg-741194 https://forums.mysql.com/read.php?10,741194,741194#msg-741194
What is the difference?]]> Jennifer Murphy Newbie Fri, 02 Jan 2026 12:19:48 +0000 https://forums.mysql.com/read.php?10,741193,741193#msg-741193 https://forums.mysql.com/read.php?10,741193,741193#msg-741193 Jennifer Murphy Newbie Wed, 17 Sep 2025 06:48:14 +0000 https://forums.mysql.com/read.php?10,741122,741122#msg-741122 https://forums.mysql.com/read.php?10,741122,741122#msg-741122
Under the subject field, I found a Follow Topic checkbox. When I checked that, a second check box popped up for sending me e-mail notices. And there's a third check box for adding my signature to the message. In most of the many forums that I follow, these are settings in my profile so I don't have to remember to check them each time I post a message. But when I open my profile, I couldn't find those settings anywhere.

I also couldn't find anywhere to enter a signature.

For both of these messages I found a spam prevention step that required me to enter a code. Is this something that will go away after I have had a few posts here and the system believes I'm a real person?

Finally, most of the forums that I participate in have some way for me to see the threads that I'm following. Some of them call it a “Watched” list. Some of them have a “My Content” link. I couldn't find anything like that here.

Thanks for any help]]> Jennifer Murphy Newbie Sun, 04 Jan 2026 10:21:25 +0000 https://forums.mysql.com/read.php?10,741027,741027#msg-741027 https://forums.mysql.com/read.php?10,741027,741027#msg-741027
My goal is to join these two tables and serve the joined dataset to my web application. I can't move the tables to a common location as these are for 2 different applications altogether. I'm working within Google Cloud Platform (GCP) and open to using managed services.

Has anyone implemented something similar?]]> Ben Shelton Newbie Wed, 30 Jul 2025 04:37:45 +0000 https://forums.mysql.com/read.php?10,741022,741022#msg-741022 https://forums.mysql.com/read.php?10,741022,741022#msg-741022
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@newstr varchar(200);

This is the procedure;

drop procedure if exists `network`.`procNetDebugVarChar`;

delimiter $$
create procedure `network`.`procNetDebugVarChar`()
begin
declare @newstr varchar(200);
set @newstr = 'hello world';
end $$
delimiter ;

Can anyone tell me what is wrong with the syntax?]]> David Lyon Newbie Tue, 29 Jul 2025 01:32:46 +0000