MySQL is among the oldest and most dependable open-source relational database management systems, trusted and utilized daily by millions of users.
With Fedora recently announcing its latest version of the flagship distribution, we’ll walk through how to easily install MySQL 8 on Fedora 39, Fedora 38, and Fedora 37.
Through this guide, we'll leverage the default Fedora repositories to keep the installation process as straightforward as possible.
Note: MySQL and MariaDB packages provide overlapping files and will conflict with each other. Therefore, you should install either MySQL or MariaDB, but not both.
Installing MySQL in Fedora Linux
Before installing any package, updating your repositories and applying any available updates ensures a smooth experience. Update your repositories with the following command:
<code>$ sudo dnf update</code>
After updating the repositories, we can move forward with the installation. Since we're using the default repository, it simplifies the process. To ensure you get the latest version of MySQL, we'll use the community edition.
Install MySQL using the provided command:
<code>$ sudo dnf install community-mysql-server -y</code>
Using dnf, it will manage all dependencies automatically, providing a seamless experience.
Starting MySQL in Fedora Linux
Installing MySQL alone isn't enough. After installation, it will remain inactive until enabled. Check the current status of the MySQL service with:
<code>$ systemctl status mysqld</code>
Start the MySQL service using:
<code>$ sudo systemctl start mysqld</code>
Verify that MySQL is running correctly by checking its status again:
<code>$ systemctl status mysqld</code>
As shown, MySQL is now active.
If you wish to have it start automatically on boot, enable it with:
<code>$ sudo systemctl enable mysqld</code>
Securing MySQL in Fedora Linux
By default, MySQL is less secure according to modern standards and can be exploited easily. One of the simplest and most effective methods to secure it is by using the secure script.
Launch the secure script with:
<code>$ sudo mysql_secure_installation</code>
For most users, this script works well. If prompted for a password, retrieve the temporary password from mysqld.log at /var/log/ using:
<code>$ sudo grep 'temporary password' /var/log/mysqld.log</code>
The secure script will prompt you to:
- Set a root password
- Remove anonymous users
- Disable remote root access
- Delete the test database
- Reload root privileges
Connecting to MySQL in Fedora Linux
Once secured, connect to the MySQL server with:
<code>$ sudo mysql -u root -p</code>
Inside MySQL, list databases using:
<code>mysql> SHOW DATABASES;</code>
Updating MySQL in Fedora Linux
Even though the installation is recent, you can update MySQL products using:
<code>$ sudo dnf update mysql-server</code>
That covers how to easily install MySQL 8 on Fedora in the simplest way possible. If you encounter any issues during installation, don't hesitate to ask in the comments.
The above is the detailed content of How to Install MySQL 8 in Fedora 38 Linux. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

LXD is described as the next-generation container and virtual machine manager that offers an immersive for Linux systems running inside containers or as virtual machines. It provides images for an inordinate number of Linux distributions with support

When encountering DNS problems, first check the /etc/resolv.conf file to see if the correct nameserver is configured; secondly, you can manually add public DNS such as 8.8.8.8 for testing; then use nslookup and dig commands to verify whether DNS resolution is normal. If these tools are not installed, you can first install the dnsutils or bind-utils package; then check the systemd-resolved service status and configuration file /etc/systemd/resolved.conf, and set DNS and FallbackDNS as needed and restart the service; finally check the network interface status and firewall rules, confirm that port 53 is not

If you find that the server is running slowly or the memory usage is too high, you should check the cause before operating. First, you need to check the system resource usage, use top, htop, free-h, iostat, ss-antp and other commands to check CPU, memory, disk I/O and network connections; secondly, analyze specific process problems, and track the behavior of high-occupancy processes through tools such as ps, jstack, strace; then check logs and monitoring data, view OOM records, exception requests, slow queries and other clues; finally, targeted processing is carried out based on common reasons such as memory leaks, connection pool exhaustion, cache failure storms, and timing task conflicts, optimize code logic, set up a timeout retry mechanism, add current limit fuses, and regularly pressure measurement and evaluation resources.

As a system administrator, you may find yourself (today or in the future) working in an environment where Windows and Linux coexist. It is no secret that some big companies prefer (or have to) run some of their production services in Windows boxes an

Frankly speaking, I cannot recall the last time I used a PC with a CD/DVD drive. This is thanks to the ever-evolving tech industry which has seen optical disks replaced by USB drives and other smaller and compact storage media that offer more storage

In Linux systems, 1. Use ipa or hostname-I command to view private IP; 2. Use curlifconfig.me or curlipinfo.io/ip to obtain public IP; 3. The desktop version can view private IP through system settings, and the browser can access specific websites to view public IP; 4. Common commands can be set as aliases for quick call. These methods are simple and practical, suitable for IP viewing needs in different scenarios.

Built on Chrome’s V8 engine, Node.JS is an open-source, event-driven JavaScript runtime environment crafted for building scalable applications and backend APIs. NodeJS is known for being lightweight and efficient due to its non-blocking I/O model and

Data replication is the process of copying your data across multiple servers to improve data availability and enhance the reliability and performance of an application. In MySQL replication, data is copied from a database from the master server to ot
