MySQL Forums - MySQL Installer for Windows

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.

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

MySQL 9.1 Installation Fails on Windows 11 After Latest Update (no replies)

Arena Noor — Fri, 19 Sep 2025 14:14:34 +0000

Hello everyone,

I’m facing issues installing MySQL 9.1 on Windows 11 after the most recent update. The MySQL Configurator is unable to initialize the database and the setup process stops at the “Initializing database” step.

I’ve attached part of the log file below:

Process for mysqld was run successfully and exited with code -1073741819.
Database initialization failed.

Steps already tried:

Running installer as Administrator

Checking permissions for the data and install directories

Re-installing Visual C++ Redistributables

Unfortunately, the problem still persists.

Has anyone else experienced this? Any suggestions or fixes would be greatly appreciated.

Thanks in advance!

MySQL 8.0.37 upgrade never completes (no replies)

Mike Fox — Wed, 02 Jul 2025 12:42:26 +0000

I'm hoping someone can help me with this issue.

We have been tracking this issue for a couple of years now, and we were promised by the developer of this application that the latest release would fix the issue we have.

To allow us to investigate and not affect the production server, I have built a test system so we can investigate the issue.

I'm not a MySQL expert by a long stretch and so some of this may be obvious, but I'd really appreciate any pointers you could give me so we can get to the bottom of the issue.

We have an application which relies on MySQL to hold the data for that app. It is currently running on version 8.0.30.

Each new iteration of the app so versions 2023, 2024 and 2025 (now) requires the MySQL to be updated before we can update the app - the issue is that the MySQL upgrade always fails.

2023 versions updated from 8.0.30 to 8.0.32 which failed.
2024 version updated from 8.0.30 to 8.0.34 which failed
2025 version updates from 8.0.30 to 8.0.37 which also fails.

The log file pretty much shows this

Attempting to start service MySQL....
'--sync-relay-log-info' is deprecated and will be removed in a future release.
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 35188
--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
InnoDB initialization has started.......
InnoDB initialization has ended.............
MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
A task may only be disposed if it is in a completion state (RanToCompletion, Faulted or Canceled).
Ended configuration step: Starting the server and upgrading system tables (may take a long time)
Server upgrade from '80030' to '80037' started...
•.....

At some point later the upgrade will then go from 8.0.30 to 8.0.37 and then it sits for days attempting to start the MySQL service - the strange thing is the MySQL service is actually started.

In the error log I see the following

DateTime=2025-06-30T08:32:06.6780355Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.37
DateTime=2025-06-30T08:32:08.3971921Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2025-06-30T08:32:08.4821861Z
mysql-installer Information: 10 : Inherited permissions have been converted to explicit permissions.
DateTime=2025-06-30T09:37:37.3726739Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2025-06-30T10:01:35.2420464Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2025-06-30T10:25:17.9984920Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2025-06-30T10:48:04.4009846Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2025-06-30T11:10:29.6651468Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2025-06-30T11:52:33.2949879Z
mysql-installer Information: 10 : Attempting to start service MySQL...
DateTime=2025-06-30T11:52:33.3799881Z
mysql-installer Verbose: 5 : 30/06/2025 12:52:33 - Service MySQL is stopped or paused, so it can be started.
DateTime=2025-06-30T11:52:33.4069909Z
mysql-installer Verbose: 5 : 30/06/2025 12:52:33 - Attempting to start the MySQL service...
DateTime=2025-06-30T11:52:33.4069909Z
mysql-installer Information: 10 : '--sync-relay-log-info' is deprecated and will be removed in a future release.
DateTime=2025-06-30T11:52:37.4450356Z
mysql-installer Information: 10 : 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
DateTime=2025-06-30T11:52:37.4600921Z
mysql-installer Information: 10 : C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 5380
DateTime=2025-06-30T11:52:37.4800559Z
mysql-installer Information: 10 : --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
DateTime=2025-06-30T11:52:37.5010332Z
mysql-installer Information: 10 : InnoDB initialization has started.
DateTime=2025-06-30T11:52:38.5493586Z
mysql-installer Error: 50 : Time out has expired and the operation has not been completed.
Thrown by: Logger.LogException
DateTime=2025-06-30T11:54:06.5268909Z
mysql-installer Information: 10 : MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
DateTime=2025-06-30T11:54:06.5518852Z
mysql-installer Error: 50 : A task may only be disposed if it is in a completion state (RanToCompletion, Faulted or Canceled).
DateTime=2025-06-30T11:54:06.5738974Z
mysql-installer Information: 10 : Finished configuration of MySQL Server 8.0.37 with state ConfigurationError
DateTime=2025-06-30T11:54:06.5928970Z
mysql-installer Information: 10 : InnoDB initialization has ended.
DateTime=2025-06-30T11:54:23.9383026Z
mysql-installer Information: 10 : Beginning ConfigApplyPage.
DateTime=2025-06-30T11:57:55.1867137Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.37
DateTime=2025-06-30T11:57:55.2158585Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2025-06-30T11:57:55.2447130Z
mysql-installer Error: 50 : The trust relationship between this workstation and the primary domain failed.

Thrown by: Logger.LogException
DateTime=2025-06-30T11:57:55.2529234Z
mysql-installer Error: 50 : Failed to obtain SID for the 'LocalSystem' NT account.
DateTime=2025-06-30T11:57:55.2529234Z
mysql-installer Information: 10 : Server upgrade from '80030' to '80037' started.
DateTime=2025-06-30T12:02:10.4096607Z
mysql-installer Information: 10 : Server upgrade from '80030' to '80037' completed.
DateTime=2025-06-30T12:04:34.9398147Z
mysql-installer Information: 10 : CA certificate ca.pem is self signed.
DateTime=2025-06-30T12:04:56.0419886Z
mysql-installer Information: 10 : Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
DateTime=2025-06-30T12:04:56.0539876Z
mysql-installer Information: 10 : X Plugin ready for connections. Bind-address: '::' port: 33060
DateTime=2025-06-30T12:04:57.1128137Z
mysql-installer Information: 10 : C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.37' socket: '' port: 3306 MySQL Community Server - GPL.
DateTime=2025-06-30T12:04:57.1278127Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2025-06-30T12:25:09.6747887Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2025-06-30T12:48:44.6175666Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2025-06-30T13:12:22.5709476Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2025-06-30T13:33:22.4361905Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2025-06-30T13:54:23.7668237Z
mysql-installer Information: 10 : Attempting to start service MySQL...
DateTime=2025-06-30T13:54:23.8088260Z
mysql-installer Verbose: 5 : 30/06/2025 14:54:23 - Service MySQL is running already.
DateTime=2025-06-30T13:54:23.8118256Z
mysql-installer Information: 10 : 2025-07-01T01:30:08.593804Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
DateTime=2025-07-01T01:30:09.6340342Z
mysql-installer Information: 10 : 2025-07-02T01:30:18.475350Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
DateTime=2025-07-02T01:30:18.8389154Z

It is almost like a timeout issue as about 30 seconds after the error message to state that MySQL cannot be started you can see that the service does start.

Any help or places to look would be really appreciated.

MySQL v8.0.19 -> 8.0.41 upgrade failed (no replies)

Reyna Hollinshead — Wed, 12 Mar 2025 21:19:15 +0000

Howdy folks. I am remediating security vulnerabilities by applying & updating the newest set of CPUs to a number of MySQL instances to bring them to the newest version

My other attempts succeeded with ease but I have one problem child that I could use help with

Scenario is that the binaries upgrade to 8.0.41 has already completed successfully but the system table upgrade step remains unfinished.

The failure is reliably reproduceable. Process is:
1) Launch MySQL Commercial Installer from start menu, using version 8.0.41.0 from Oracle MOS which is patch ID 37499809. No impact if I specifically elevate the installer with admin privs

2) See the list of installed products. I'm clicking 'reconfigure' to get back into the system table upgrade portion, click next, click execute to begin.

Failure is assured here, but the Log shows 1 of 2 outputs:
1) First it fails to continue past the 'Attempting to start service MySQL80...' and will time out here ad infinitum regardless of how much time lapses

2) Secondly, if I begin executing the upgrade while the MySQL windows service is stopped, the upgrade will begin normally. It appears to continue just fine but then fails to complete with errors

My REAL problem here is that I cannot identify any clues or breadcrumbs about what the actual error is that's stopping the upgrade. Admittedly I am not very familiar with MySQL so I'm hoping this is down to my inexperience on not knowing where to look, but I don't see any errors logged out to the Application or System views of Event Viewer nor does anything stand out in the log from "C:\ProgramData\MySQL\MySQL Installer for Windows\Logs\"

Here is the output that is shown from the log

Cannot connect (no replies)

Branko Smok — Wed, 19 Feb 2025 07:59:10 +0000

Hi!
After instaling mySQL i can not connect to server/database.
I am sure that i entered the right password because it is the password i entered at instalation.
When i try to connect to database from sql workbanch i get error "Access denied (using password:Yes)
Please help.
Can i completely remove mysql from my PC? Is there a way to reset password?
Thank you in advance

Error on Reinstall (3 replies)

Mike Demaris — Wed, 26 Mar 2025 22:59:34 +0000

Hi all,
I uninstalled MySQL server because I could not reset the root password and could not log into the server.
Now, I cannot install, using the web installer nor the full MSI installer. The error I get is: Internal Error. (Error retrieving product version.)

I deleted the MySQL folders in the Program Files and AppData folder as well. Not sure what else to look at.

Windows 11, 64 bit. I have Visual C++ 2015-2022 and Visual Studio 2019/2022 installed. There is one ODBC connector that didn't want to be removed and I was able to reinstall the Workbench.

Thanks for your help.

Vulnerable version of Oracle MySQL detected on port 3306 over TCP - 8.0.22-commercial (1 reply)

Mario Firmansyah — Tue, 21 Jan 2025 11:17:08 +0000

Greetings.

I have an issue regarding a vulnerable version of Oracle MySQL detected on port 3306 over TCP - 8.0.22-commercial. Could you please provide information on what steps we need to take to resolve this issue? Thank you.

MySQL for Excel error (4 replies)

Francisco Ignacio Fernandez Sanchez — Thu, 19 Jun 2025 12:47:55 +0000

When running MySQL for Excel in Excel the following error occurs

Connection attempt failed

The key provided is not found in the dictionary.

Both MySQL and Excel are working and I can access from Excel to MySQL via ODBC.

I have disabled Firewall and Antivirus and it gives the same problem, reinstalled connectors and MySqServer, in the logs I do not see any related error.

With the user and password I can access from the Workbench and from other Data Sources via ODBC in Excel itself, the problem is only in the MySql for Excel component, I have tried with other previous versions and also give the same problem.

Does anyone have any idea what could be the problem?

The versions of the installed components are:

Windows 11 Home 24H2

MySQL Server MySQL Server 8.0.40

MySQL For Excel 1.3.8

MySQL Connector ODBC 9.1 (64 bits)

MySQL Connector NET 9.0.0

Microsoft® Excel® para Microsoft 365 MSO (versión 2411 compilación 16.0.18227.20082) de 64 bits

Installation of MySql 9.1 after the last Win 11 update does not run correctly (4 replies)

Peter Rosinský — Fri, 19 Sep 2025 14:02:58 +0000

Installation of MySql 9.1 after the last Win 11 update does not run correctly.

MySql configurator is unable to initialize the database and fails to complete basic setup.

I am attaching a log dump:

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL91 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 0" protocol=TCP localport=0

No rules match the specified criteria.

An error occurred running netsh.exe delete:
The attempt to delete a Windows Firewall rule failed.
Adding a Windows Firewall rule for MySQL91 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.
Granted permissions to the data directory.
Granted permissions to the install directory.
Updating existing service...
Existing service updated
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 9.1.0...
Starting process with command: C:\Program Files\MySQL\MySQL Server 9.1\bin\mysqld.exe --defaults-file="C:\MySQL\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
Process for mysqld, with ID 15552, was run successfully and exited with code -1073741819.
Failed to start process for MySQL Server 9.1.0.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

MySQL-Server 9.1 (1 reply)

Lothar Rappsilber — Wed, 26 Mar 2025 22:25:53 +0000

Hallo Gemeinde,

ich arbeite mit Server 9.1.
1. Der Installationsassistent zeigt nicht alle installierten Produkte an
2. Wenn ich den Server aktualisiere und einen Neustart durchführe, akzeptiert er mein Passwort nicht
3. Ich kann nur vorher deinstallieren (DB sichern), dann neu starten und danach wieder 9.1 installieren
4. DB-Sicherung einspielen

Mit der 32bit-Version ging es mit dem Installationsassistenten perfekt. Was kann ich machen?

Mit freundlichen Grüßen
L.Rappsilber

Database initialization error and unable to uninstall mysql server (2 replies)

Yaminee Kumari — Tue, 12 Nov 2024 20:06:23 +0000

Hi,

I am using Windows 11 and I downloaded the mysql-installer-community-8.0.39.0

While configuring the mysql server, it threw an error in "Initializing Database" step. Below is the log from the configuration setup:
"""
Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306

Deleted 1 rule(s).
Ok.

Adding a Windows Firewall rule for MYSQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 33060" protocol=TCP localport=33060

Deleted 1 rule(s).
Ok.

Adding a Windows Firewall rule for MYSQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.
Granted permissions to the data directory.
Updating existing service...
Existing service updated
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.39...
Failed to start process for MySQL Server 8.0.39.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)
"""

I even attempted to remove mysql server product which again failed with the following log:
"""
Beginning remove step: Stopping the server

Ended remove step: Stopping the server

Beginning remove step: Removing the MySQL Windows service

Removing the Windows service created for this server installation.
Deleting the existing service.
The existing service has been deleted.
Ended remove step: Removing the MySQL Windows service

Beginning remove step: Uninstalling product
1: The action 'Remove' for product 'MySQL Server 8.0.39' failed.

Ended remove step: Uninstalling product
"""

I then attempted to uninstall mysql server from 'installed apps' in settings which also failed with the following message prompt:
"""
The installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
"""

I have tried googling these errors and even followed some youtube videos to try to fix them but without any success.

Asking for help in resolving this issue as soon as possible.

I cannot create a new root password (1 reply)

Pierre Guirguis — Wed, 11 Sep 2024 10:05:32 +0000

Greetings,

I am trying to install MySQL (version 8.0.32) on my laptop. However, whenever I try to set a new root password, I keep getting a red X with a message that says "MySQL Server is not running, a connection cannot be established". This is despite being connected to the internet. I have tried to uninstall and reinstall MySQL multiple times, but to no avail.

Please advise

Request for development of installation program for ARM CPUs (1 reply)

chang jason — Tue, 12 Nov 2024 19:59:26 +0000

I am currently using a PC that supports an ARM CPU, but I have noticed that MySQL is not compatible with ARM. I was wondering if there are any plans to improve compatibility for ARM systems. If so, could you please provide me with more information about these plans?

MySQL Community (GPL) Downloads (1 reply)

A A Khatana — Tue, 12 Nov 2024 19:55:32 +0000

MySQL Community (GPL) Downloads for windows get downloaded but not executed.

Guys I need help with the instalation MySQL Community (2 replies)

Isabella Bella — Thu, 27 Jun 2024 21:55:56 +0000

Hi Guys I'm begginer student of sql, Im having problem with the instalation of MySql Community, when I get to "Apply Configuration" all the topics are sucessfully executed except the topic "Updating permissions for the data folder and related server files" and the description of the error says "Attempting to update the permissions for the data folder and related server files...The data directory does not exist. Failed to update permissions for the data folder and related server files. Ended configuration step: Updating permissions for the data folder and related server files".
Someone can help me to fix this error ? I'll be endless gratefull

Mysql ODBC Connector Options are missing in installer (1 reply)

Prashant Nirgun — Mon, 10 Jun 2024 12:32:44 +0000

I was trying to install MySQL 8 64 Bit + ODBC Connector 32 bit on new Asus i3 laptop. I completed all windows updates and then install Mysql Installer 1.6 also updated all product updates also but It was ony showing me option 1 Mysql, 2 Application, 3 Documentation only. ODBC Connector options are missing from installer. I tried offline and online version both behaves same way. I checked there is no filter set

If I download installer for mysql ODBC connector it automatically install 64 Bit version no choice to select.

Microsoft Windows 11 Home Single Language 10.0.22621 Build 22621

C:\ProgramData\MySQL\MySQL Installer for Windows\Product Cache contain following files
mysql-8.0.0-dmr-winx64.msi
mysql-8.0.37-winx64.msi
mysql-documents-8.0.37.msi
mysql-examples-8.0.37.msi
mysql-router-8.0.37-winx64.msi
mysql-shell-8.0.37-windows-x86-64bit.msi
mysql-workbench-community-8.0.36-winx64.msi

Error al instalar (2 replies)

Mariano Benegas — Fri, 28 Jun 2024 00:25:48 +0000

Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.37...
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
Using jemalloc.dll for my_malloc and ut::malloc etc.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Empty value for 'open_files_limit' specified.
Process for mysqld, with ID 4692, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.37.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

intente de todo y no hay caso llevo dos dias intentando solucionar

How to install mysql-connector-python-8.4.0.zip it does not have setup.py (1 reply)

Ivan Bonanno — Fri, 28 Jun 2024 00:28:12 +0000

How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz

Problem to initialize a MySQL Connections (1 reply)

Jose Antonio Moran Rodriguez — Fri, 28 Jun 2024 00:32:46 +0000

Hello guys, I'm really newbie in this database.
I have the following problem, I have downloaded the MYSQL version 8.0 above, and also its respective workbench. So when I was trying to ADD MySQL connection it appears the next error "Failed to Connect to MySQL at 127.0.0.1:3306 with user root""Acces denied for user 'root'@'localhost'(using password:yes"

Itried some answers in the web but it does not work. Any suggestion? Also I am gonna share my question more explained in this link: https://stackoverflow.com/questions/78316465/the-innodb-system-data-file-ibdata1-must-be-writable?noredirect=1#comment138070002_78316465

Best Regards

Failed to install on the MS Surface Go4 (3 replies)

booraseth sookpipatchaiyo — Fri, 28 Jun 2024 00:27:11 +0000

I installed MySQL Server 5.7.44 on the MS Surface Go3 normally.
But I can't install on MS Surface Go4.
There is an error when initializing the database.
The MS Surface Go4 has UFS storage. Not sure if this is a storage problem or not.

Anyone who knows please help me.
Thank You.

Issue upgrade mysql machine has no internet (2 replies)

Ivan Bonanno — Fri, 28 Jun 2024 00:30:57 +0000

I am upgrading Windows MySQL from version 8.0.21 to 8.0.36, but the paths are not located in C:. When using the offline installer, I am not given the option to upgrade, and the architecture is shown as not specified. Additionally, the machine does not have internet access.

Mysql workbench installer for windows on arm laptop (2 replies)

Byungkyu Lee — Sat, 22 Jun 2024 17:33:54 +0000

Hello, you may know that there is no installer for ARM laptops except iOS devices.

While there are alternatives like SQLyog, they don't entirely replace MySQL.

Do you have any plans to provide an installer for ARM machines in the future? I would be grateful if you could share any information about such a plan.

Database Initializing Failed (3 replies)

Endre Solem — Fri, 28 Jun 2024 00:41:26 +0000

Hello.

My local MySql version stopped working suddenly and I could not figure out why.
I tried to install it again and now it won't initialize.
I have downloaded the latest installer and nothing helps.

Another strange thing is that the error message is more or less the same as one posted here a few weeks ago in this tread.
https://forums.mysql.com/read.php?169,707410,707410

The strange this is the word Wondershare (video editing tool). I deleted these files a few days ago (maybe when things stopped working)

Also, the data folder is not even created, so I can not delete it.

----
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
mysqld: Can't get stat of 'C:\Users\Public\Documents\Wondershare\CreatorTemp' (OS errno 2 - No such file or directory)
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
The designated data directory C:\ProgramData\MySQL\MySQL Server 8.0\Data\ is unusable. You can remove all files that the server added to it.
Aborting
Process for mysqld, with ID 17736, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.36.
-----

Any tips on what can be wrong?

Thanks

Endre

MySql and InstallAnywhere (1 reply)

Drive Mat — Wed, 13 Mar 2024 21:41:51 +0000

Desktop application had mysql 5.x (community edition) packaged and installed using InstallAnywhere without any user interaction at least for the mysql part. Upgrading Mysql to 8.x requires VisualBasic which requires more user interaction. How to solve this problem and keep the same user experience when it comes to installing the desktop app with mysql upgraded to 8,x?

Configuration operations (1 reply)

Akanksha Popade — Wed, 13 Mar 2024 21:46:55 +0000

Attempting to start service mysql80..
But it is failing each time
Mysql failed to start due to an unknown cause

Connecting my development code in vscode to mysql in the cpanel (2 replies)

M A — Tue, 19 Mar 2024 06:30:53 +0000

Dear Friends,

I have setup a Remote MySQL in my cpanel server.

In my vscode i setup SQL Tool extension and i connected to my Remote MySQL.

i can make query and select from my Remote MySQL.

Now my i created a small form where i want to submit my form data and stored in my Remote MySQL in the cpanel not localhost in my pc.

below is my connection code :

$dbHost = "555.457.7775.555";
$dbUser = "user_name";
$dbPass = "XXXXX";
$dbName = "Database_name";

$conn = mysqli_connect($dbHost,$dbUser,$dbHost, $dbName);

if (!$conn) {
die("Something went wrong");
}

echo "Coonection successful";

?>

and below is my submit data code :

if (isset($_POST["create"])) {
include("../connect.php");
$title = mysqli_real_escape_string($conn,$_POST["title"]);
$summary = mysqli_real_escape_string($conn,$_POST["summary"]);
$content = mysqli_real_escape_string($conn,$_POST["content"]);
$date = mysqli_real_escape_string($conn,$_POST["date"]);

$sqlInsert = "INSERT INTO post(title,summary,content,date) VALUES ('$title', '$summary', '$content', '$date')";
if (mysqli_query($conn,$sqlInsert))
{

}
else
{
die("Data is not inserted");
}
}
?>

i am getting his errorr :

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'user_nameXX '@'555.457.7775.555' (using password: YES) in C:\xampp\htdocs\blog\connect.php:9 Stack trace: #0 C:\xampp\htdocs\blog\connect.php(9): mysqli_connect('555.457.7775.555', 'database_name...', Object(SensitiveParameterValue), 'databasea_name...') #1 C:\xampp\htdocs\blog\admin\process.php(3): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\blog\connect.php on line 9

note : Above address is Fake, just for display only because i changed for privacy.

Kindly advise , i am new to Mysql

Data Dir (Permission Denied) (1 reply)

wagner marques — Tue, 10 Oct 2023 03:11:14 +0000

Hi...

I'm trying to start mysql with datadir as a mounted partition but I'm facing permission denied problem and mysql does not starts.

My datadir is: /home/wgn/mnt/mysql8data/mysql

that is mounted as below:

/dev/sdb1 on /home/wgn/mnt/mysql8data type ext4 (rw,relatime,seclabel,errors=remount-ro)

And permissions of my data dir are:
[wgn@fedora ~]$ ls -ilha /home/wgn/mnt/
total 24K
4728662 drwxr-xr-x. 5 wgn wgn 4,0K set 19 15:34 .
4718593 drwx--x---+ 52 wgn wgn 4,0K set 19 23:26 ..
2 drwxrwxrwx. 30 wgn wgn 4,0K set 17 23:20 ext4
2 drwxrwxrwx. 4 mysql mysql 4,0K set 19 15:35 mysql8data
5128036 drwxr-xr-x. 2 wgn wgn 4,0K set 16 15:09 wgnbk

My selinux are in permissive mode:

wgn@fedora ~]$ sestatus
SELinux status: enabled
SELinuxfs mount: /sys/fs/selinux
SELinux root directory: /etc/selinux
Loaded policy name: targeted
Current mode: permissive
Mode from config file: permissive
Policy MLS status: enabled
Policy deny_unknown status: allowed
Memory protection checking: actual (secure)
Max kernel policy version: 33

The mysql start process log are below

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.812522Z 0 [Warning] [MY-010091] [Server] Can't create test file /home/wgn/mnt/mysql8data/mysq/mysqld_tmp_file_case_insensitive_test.lower-test

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.812638Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 3636

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.817024Z 0 [Warning] [MY-010091] [Server] Can't create test file /home/wgn/mnt/mysql8data/mysq/mysqld_tmp_file_case_insensitive_test.lower-test

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.817036Z 0 [Warning
[MY-010159] [Server] Setting lower_case_table_names=2 because file system for /home/wgn/mnt/mysql8data/mysql/ is case insensitive

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.817095Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to '/home/wgn/mnt/mysql8data/mysql/' (OS errno: 13 - Permission denied)

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.817237Z 0 [ERROR] [MY-010119] [Server] Aborting

set 19 23:32:20 fedora mysqld[3636]: 2023-09-20T02:32:20.817517Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.

set 19 23:32:20 fedora systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE

set 19 23:32:20 fedora systemd[1]: mysqld.service: Failed with result 'exit-code'.

set 19 23:32:20 fedora systemd[1]: Failed to start mysqld.service - MySQL Server.

set 19 23:32:20 fedora audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=mysqld comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed'

set 19 23:32:20 fedora systemd[1]: mysqld.service: Consumed 2.254s CPU time.

set 19 23:32:20 fedora sudo[3606]: pam_unix(sudo:session): session closed for user root

set 19 23:32:20 fedora audit[3606]: USER_END pid=3606 uid=1000 auid=1000 ses=1 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_close grantors=pam_keyinit,pam_limits,pam_keyinit,pam_limits,pam_systemd,pam_unix acct="root" exe="/usr/bin/sudo" hostname=? addr=? terminal=/dev/pts/0 res=success'
set 19 23:32:20 fedora audit[3606]: CRED_DISP pid=3606 uid=1000 auid=1000 ses=1 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_env,pam_localuser,pam_unix acct="root" exe="/usr/bin/sudo" hostname=? addr=? terminal=/dev/pts/0 res=success'

Could someone helps, please, what could be wrong to cause permission denied to prevent mysql to write in /home/wgn/mnt/mysql8data directory?

Best regards...

Introducing the MySQL Configurator tool for Windows (no replies)

Edwin Desouza — Thu, 20 Jul 2023 16:03:29 +0000

Introducing the MySQL Configurator tool for Windows
- https://blogs.oracle.com/mysql/post/introducing-the-mysql-configurator-tool

An error happened while reading data from the provider: ‘Object cannot be cast from DBNull to other types.’ (3 replies)

Guram jalaghonia — Tue, 09 Jan 2024 16:04:59 +0000

Hello Dear friends,

I have a next problem: I didn't manage to get data from a database. This happened after changing the database server and a database version. Before changing everything work fine, it was "MariaDB 10.5", after changing become MariaDB 10.11.

If I try to create a new connection I get an error:

--We encountered an error while trying to connect. Details: “An error happened while reading data from the provider: ‘Object cannot be cast from DBNull to other types.’”--

If I try to refresh an existing connection I get some errors:

--DataSource.Error: An error happened while reading data from the provider: 'Object cannot be cast from DBNull to other types.'--

--DataSource.Error: An error happened while reading data from the provider: 'The given key was not present in the dictionary.'--(If there are some steps in Power Query).

I have a last version of Power Bi, I can connect to the database through MySQL Workbench 8.0 CE without any problem.

I think that problem may be MySQL Connector NET 8.0.32, it's not a last version, last version is MySQL Connector NET 8.0.33, but it doesn't work.

Using last version of the this software, I get an next error:

--This connector requires one or more additional components to be installed before it can be used.

Microsoft Powe Bi didn't manage to help me, may be somebody has appropriate experience and can help me.

Thank you so much.

Best Regards,

Guram