Since the installation of feasible method, mainly refer to the mysql installation | novice tutorial

Other problems encountered are the results of their own baidu

Go to the MySQL framework (GA) website to download the url

Move to the folder where the framework file is stored and run the RPM command to decompress and install it

Because I am not in the habit of entering root to operate the installation. Select * from user root where sudo is selected
Mysql80-community-release-fc28-1.noarch. RPM = mysql80-community-release-fc28-1.noarch. RPM = mysql80-community-release-fc28-1.noarch

sudo rpm -Uvh mysql80-community-release-fc28-1.noarch.rpm

Update the yum library and install mysql-Server

sudo yum update

sudo yum install mysql-server

Initialized mysql

mysqld –initialize

Start the mysql

systemctl start mysqld

Mysql > Update mysql

systemctl status mysqld

Go to the tm rookie tutorial… Dry fedora28 tm

Yes, literally, the one above didn’t work, at least not when I installed it, and found two problems.

  • Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
  • Access denied for user ‘root’@’localhost’ (using password: YES)

One is missing files and the other is denied connections. Follow the online method to make things messy, which is not a good experience for a would-be DBA

So ah, online to give a good tutorial, which is responsible for the official instructions to use ah ~ MySQL official website

PS: The following order is the order in which I logged in the official website UI on November 8, 2018… In the future, if the UI is changed, slowly turn it over, I believe that it is not difficult to do this line… English is not good you need a Google browser, I will use the Google browser machine page installation 🙂

Click in order, and the target is in a prominent place:

DOCUMENTATION ->MySQL Server -> Installing and Upgrading MySQL ->2.5 Installing MySQL on MySQL > install MySQL

On this page you can see a table which lists. The forehead.. Installation tools? , which has the Yum (Fedora available) installation tools and Docker that I’m familiar with. Translation is not recommended for this page. Machine translation will be very strange, here to find your system with the corresponding entry. In my case, Yum is followed by two links

Enable the MySQL Yum Repository: Enable the MySQL Yum Repository: Enable the MySQL Yum Repository You can also find A Quick Guide to Using the MySQL Yum Repository on this page.

One is Documentation and the quick guide above is a link

Next, you can follow the steps of the document to install, or you can follow my steps directly, which is the step I have not encountered any problems with

  1. Uninstall a batch of MySQL that was installed in a mess

    sudo yum remove mysql

  2. Install the YUM repository and replace the file name yourself

    sudo dnf localinstall mysql80-community-release-fc29-{version-number}.noarch.rpm

  3. Manually modify the version series

    sudo vim /etc/yum.repos.d/mysql-community.repo

    If 57 sublibraries are disabled, 80 is enabled, enabled=0 is disabled, enabled=1 is enabled, my file now looks like this

    [mysql57-community] name=MySQL 5.7 community Server enabled=0 baseurl=http://repo.mysql.com/yum/mysql-5.7-community/fc/$releasever/$basearch/ gpgcheck = 1 Gpgkey =file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql80-community] name=MySQL 8.0 community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/fc/$releasever/$basearch/ enabled = 1 gpgcheck = 1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-connectors-community] name=MySQL Connectors Community baseurl=http://repo.mysql.com/yum/mysql-connectors-community/fc/$releasever/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-tools-community] name=MySQL Tools Community baseurl=http://repo.mysql.com/yum/mysql-tools-community/fc/$releasever/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-tools-preview] name=MySQL Tools Preview baseurl=http://repo.mysql.com/yum/mysql-tools-preview/fc/$releasever/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysqlCopy the code

  4. MySQL installation

    sudo dnf install mysql-community-server

    After installation, we can start, stop and restart the service

    service mysqld stop

    service mysqld start

    service mysqld status

  5. Can’t connect to local mysql server through socket ‘/ TMP /mysql.sock ‘(2)”

    mysql -uroot -p

  6. Then you’ll find that you need a password. The password is not empty. Root’s initial password is in the error log file

    sudo grep ‘temporary password’ /var/log/mysqld.log

    A sentence is printed on the screen

    2018-10-3t03:04:23.365034z 5 [Note] [my-010454] [Server] A temporary password is generated for root@localhost: ***

    The *** position is the default password, in plain text. Remember to change your password after logging in

    Validate_password is installed by default. The implemented default password policy validate_password requires that the password contains at least one uppercase letter, one lowercase letter, one digit, and one special character. The password must contain at least eight characters in total

    Because this server is for my study. This password policy sucks. It’s time FOR me to study how to change password policies…

At this point, I finally installed MySQL on Fedora28 system and was ready to start my learning journey,

If there are any mistakes, I hope you can comment on them. It is very important for my DBA to change career.

If there is any problem I haven’t met, please send a message. It would be better if there is a solution, which is very important for my younger brother to become a DBA

First time with MarkDown, poor typography, some advice

In this thanked

The MySQL database changes the password policy later