Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to achieve the installation and configuration of Mysql5.7.12/10, the content of the article is carefully selected and edited by the author, with a certain pertinence, for your reference significance is still relatively great, the following with the author to understand how to achieve Mysql5.7.12/10 installation and configuration bar.

1. Install the packages needed to compile the code

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel libaio libaio-develperl-Data-Dumper net-tools

2. Installed version of boost1.53:

Yum-y install boost boost-devel boost-doc

3. Download the release version of boost1.59

Cd / usr/local/src

Wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

4. Decompress and install boost1.59

Tar zxvfboost_1_59_0.tar.gz

Cd boost_1_59_0

. / bootstrap.sh--with-libraries=system,filesystem,log,thread-- with-toolset=gcc

. / b2toolset=gcc

. / b2install

Installed by default in the / usr/local/lib directory; header files in the / usr/local/include/boost directory

The version of boost must be 1.59, if not, uninstall and reinstall (5.7.10 can also be used)

5. Install mysql5.7.12

Wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12.tar.gz

You can pass it on yourself.

Check whether the MD5 value is the same as the official website

Md5sum mysql-5.7.12.tar.gz

1) decompression

Tar xvfmysql-5.7.12.tar.gz

Cd mysql-5.7.12

2) compile and install

Cmake\

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\

-DMYSQL_DATADIR=/usr/local/mysql/data\

-DSYSCONFDIR=/etc\

-DWITH_MYISAM_STORAGE_ENGINE=1\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_MEMORY_STORAGE_ENGINE=1\

-DWITH_READLINE=1\

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock\

-DMYSQL_TCP_PORT=3306\

-DENABLED_LOCAL_INFILE=1\

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DEXTRA_CHARSETS=all\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci

(--Build fileshave been written to: / root/mysql-5.7.10

The last sentence of compilation shows that this is ok.)

Make&& make install

6. Check whether there are any mysql users

Cat / etc/passwd | grep mysql

7. View the list of user groups

Cat / etc/group

Create if you don't

Groupadd mysql

Useradd-g mysql mysql

8. Set permissions and initialize the MySQL system authorization table

Modify / usr/local/mysql permissions

Chown-Rmysql:mysql / usr/local/mysql

9. Enter the installation path:

Cd / usr/local/mysql

Sudo is a must! (version 6.4 or above) otherwise the database cannot be started

Sudo cp support-files/my-default.cnf / etc/my.cnf

Vi / etc/my.cnf

[mysqld]

Datadir=/var/lib/mysql

Socket=/var/liv/mysql/mysql.sock

Symbolic-links=0

Log-bin=mysql-bin

Server-id=151

Sql-mode= ""

10. Add service scripts to init.d

Cp support-files/mysql.server / etc/init.d/mysqld

Add execution permissions:

Chmod 755/etc/init.d/mysqld

11. Default database initialization

Bin/mysql_install_db-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data-user=mysql

Boot self-start

Chkconfig-list mysql

Chkconfig-add mysql

Set mysql to start automatically at level 345

Chkconfig-level 345 mysql on

Error

Startup was not successful

Kill the blocking process

Start successfully!

12. Change the root password

Shut down the database

Service mysqld stop

Add skip-grant-tables to / etc/my.cnf

Start the database

Mysql-p can be logged in directly, and enter with password is fine.

If you report an error,

Execute the following statement

Ln-s / usr/local/mysql/bin/mysql / usr/bin

Take a closer look at the red mark below and then do it.

Update mysql.user setpassword=password ('newpassword') where user='root'

The lower version of centos is password=password (newpassword), but my system is centos7.2. I ran an error and found that password changed the field after Google search.

Update mysql.user set authentication_string=password ('WrAJ2wag:gx') where user='root'

Exit the database and restart the database

Set the skip- in / etc/my.cnf. Annotation

Try logging in to the database:

Success!

After reading the above about how to install and configure Mysql5.7.12/10, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.