Install MySQL under Ubuntu

My installation method, is on the MySQL official website download ubuntu corresponding MySQL version installs, the process is very arduous, hereby records, hoped can provide a shortcut for the students who have not installed successfully ~ ~ ~

First, download MySQL, Address: https://dev.mysql.com/downloads/mysql/

Choose your own system corresponding to the MSYQL version, I chose the ubuntu16.04 (64-bit), download the first <deb Bundle>, this is the tar compressed package, after downloading ~ ~

Then, start the command line installation, sudo dpkg-i installation package

Install package refers to the previous download of the tar extracted from the Deb file, Deb has a lot, sudo dpkg-i can be installed after a number of Deb, multiple deb between the need for a space to separate, and so many installation package installation is to be installed sequentially ~ ~ Order as follows

At this time, you have to pay attention, so the direct installation estimated hundred percent error ~ ~ ~ Because, there are additional dependencies need to install, respectively: Libaio1 LIBMECAB2

These two rely on the use of a single sudo apt-get install software name for installation will be error ~ ~ ~

The system recommended sudo apt-get-f install, and I did, but it did not succeed, this time the error is: Candidate path/etc/mysql/my.cnf.fallback does not exist

In response, this problem, I searched the internet for a while, there is no one solution to my problem, but still gave me a little inspiration, because I found in my system/etc/mysql directory has a mysql.cnf.dpkg-new and other people say my.cnf file seems to be the same, so I try to copy this file to a sibling directory, and named My.cnf.fallback (actually I was mysql.cnf.dpkg-new copy to My.cnf, and then copied to my.cnf.fallbackm, that is, the real I have mysql.cnf.dpkg-new,my.cnf,my.cnf.fallback three files)

This is the time to re-execute sudo apt-get-f install

During the installation, you will notice that the link group MY.CNF is corrupted, forcing the reinstallation of the candidate/etc/mysql/my.cnf.fallback

But the final installation was successful.

Authentication method: Service MySQL start (will be required to enter the account password ~ ~) and then execute mysql-u root-p This time will enter the MySQL command line operation

Summary: MySQL installation design a bit of a sense of brain residual feeling ~ ~ ~ The reason is: the candidate path/etc/mysql/my.cnf.fallback does not exist can not continue to install, and then in/etc/ MySQL directory It's so strange to have a file named My.cnf.fallback.

Install MySQL under Ubuntu