Durchsuchen nach
Schlagwort: MySQL

After upgrading to Fedora 42, problems with the MySQL database due to downgrading

After upgrading to Fedora 42, problems with the MySQL database due to downgrading

First of all, it took me three hours of troubleshooting to solve the problem. I took a day off because it requires the utmost concentration. It’s not something you can do on the side. What is troubleshooting? Troubleshooting involves fault finding and fault correction and is a systematic approach to problem solving that is often used to find and eliminate problems in complex machines, electronics, computers and software systems. The first step in most troubleshooting methods is to gather information…

Weiterlesen Weiterlesen

Nach Upgrade nach Fedora 42 Probleme mit der Datenbank MySQL, wegen Downgrading

Nach Upgrade nach Fedora 42 Probleme mit der Datenbank MySQL, wegen Downgrading

Vorneweg, ich habe drei Stunden Troubleshooting gebraucht, also das Lösen des Problems liegen hinter mir. Ich habe mir einen Tag Pause gegönnt, denn es ist höchste Konzentration vonnöten. So etwas macht man nicht nebenbei. Was ist Troubleshooting? Troubleshooting umfasst die Fehlersuche und die Fehlerbehebung und ist ein systematischer Ansatz zur Problemlösung, der häufig verwendet wird, um Probleme in komplexen Maschinen, Elektronik, Computern und Softwaresystemen zu finden und zu eliminieren. Der erste Schritt bei den meisten Fehlerbehebungsmethoden ist das Sammeln von…

Weiterlesen Weiterlesen

Upgrade from Fedora 41 to Fedora 42

Upgrade from Fedora 41 to Fedora 42

I actually wanted to upgrade to Fedora 43 today, which is technically possible, but there was a problem with the MySQL database. I am using a manually installed, older version of MySQL (probably the 9.2 repo version, which was a mistake). That was a tip from a contact on LinkedIn back then. The installation worked without any problems. But now, when downloading the files, I got a message saying that the server could not be found. Yesterday evening, there was…

Weiterlesen Weiterlesen

Python MySQL create a database and a table

Python MySQL create a database and a table

This is a Python script in order to create first the database and then a table with different values in one step. It is useful, then you don’t need to do it in two steps. What is the requirement for the script Installation of Python Windows and Mac For this script, you need to install Python if you are on Windows and Mac. Go to the official web page of Python.org and download your package and installed like another program….

Weiterlesen Weiterlesen

MySQL – Reset the root password

MySQL – Reset the root password

If you have forgotten your root password (it was in my case) then you can do the followings steps: I use here a Linux, Fedora 41. If you are using other distributions or Windows / macOS, please search for this operating systems. And if your system shows an error message, contact your favourite AI or a platform like StackOverflow. I did it today for the first day on my system because I did not know the root password. That’s all.