First upgrade CENTOS7, then install MARIADB, and then die you almost three o'clock or can't sleep.

Source: Internet
Author: User

Upgrade to CentOS 7, want to install a MySQL, be told:

"Sorry, I didn't notice you are CentOS7, as another Netizen said, after MySQL was acquired by Oracle, the CentOS community was concerned about the copyright or its features of the successor version. Conversion of the default database management system. “

This logic, not very understand, and then Mariadb Bai.

Then service mysqld start is out of date. (but can still be used), redirected to Systemctl this thing.

What is this thing? I don't know, but I feel like a misleading person.

Systemctl Start mariadb

According to Murphy's law, things can never go down as they are supposed to, and it's inevitable to report a mistake. So you see this crap:

Then you see this as prompted:

This is to get you into a trap. None of this is going to work, and it's no use doing a level two. also drunk.

So, where to look?

My own experience is that

Locate the log folder:

Order, because I don't know which one to look at.

Just this boot.

It really is the start of the message. But there's a different hint.

Systemctl Status Mariadb.service

The log file you're dreaming of is here.

With a normal hint of error, things are much better.

The answer is to delete a similar document. It is recommended that the backup be deleted, although I finally deleted it directly.

Cd/var/lib/mysql

MV ib_logfile* ~

Also reported error, port occupancy: This simple, kill process

Still wrong: Can't find mysql.host:mysql_install_db

Also wrong: Can ' t find file: './mysql/host.frm ': Actually not found, is not the right:

Cd/var/lib/mysql

CD MySQL

Chown MySQL *
CHGRP MySQL *
chmod ug+rwx *

Also wrong: Incorrect information in file: './mysql/proxies_priv.frm ', incorrect information? deleted directly. (not recommended, backup recommended)

Rm-f proxies_priv*

Systemctl Start mariadb

It's 49 o ' 2 o'clock in the morning.

First upgrade CENTOS7, then install MARIADB, and then die you almost three o'clock or can't sleep.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.