Error encountered with MySQL.
Error encountered with MySQL.
Hey, I’m here again with another problem involving Linux. I recently wanted to move from MariaDB back to MySQL. After running the apt purge mariadb* command and then trying to install using apt-get install mysql-server mysql-client, I encountered the same error shown in the screenshot. I’ve also attached the journalctl output, though it didn’t help much. I’ve checked numerous guides online, but nothing seems to work. I’m counting on the forum’s experts to assist me. Any tips would be greatly appreciated. No worries about losing data since everything looks fine here. Thanks a lot!
For curiosity, the system shows the current status of services with "systemctl status mysql". When searching logs with "journal | grep mysql", it highlights any recent entries related to MySQL activity. Both commands help monitor and debug MySQL after starting it.
I tried to set up a service named Pterodactyl on my system and the SQL operations kept failing. Since MariaDB was already installed and resembles MySQL, I aimed to switch it for the problem. Please review the attached images for further guidance.
Run the command to add the directory to configuration and launch MySQL.
Thank you for your patience. I’ve stopped responding and went to sleep. The issue remains unchanged—there was a prior error requesting `mysqld -initialize`, which I attempted but the problem persists.
I’m making an educated assumption about the ownership here since I’m unsure what Ubuntu uses for MySQL. The error indicates it’s not running as root. I changed the ownership to mysql:mysql in /var/lib/mysql. This shouldn’t push you away from MySQL, but I wanted to share it. MariaDB is actually a modified version of MySQL from the original MySQL Developers. It’s not just similar—it’s built on top of MySQL and serves as an open-source alternative. Over time, it has filled the gap that MySQL once held. Although some code paths have changed, keeping compatibility with MySQL remains a priority. Most Linux distributions now prefer or default to MariaDB, and some even remove MySQL from their repositories.
You found the answer you were looking for. It was surprisingly straightforward. I wasn't aware it would be that easy. I'm using MySQL now and will keep it as long as it functions. I previously thought they were alike but distinct, similar to MongoDB yet more like MySQL. Thanks for your assistance!