Shulou(Shulou.com)05/31 Report--

This "sample analysis of VMWare linux mysql 5.7.13 installation configuration" is not understood by most people except programmers. Today, in order to make you better understand the "sample analysis of VMWare linux mysql 5.7.13 installation configuration", the editor summarizes the following contents, which have a certain reference value, the detailed steps are clear, and the details are handled properly. I hope you can get something through this article. Now let's take a look at the details.

What is Linux system Linux is a free-to-use and free-spread UNIX-like operating system, is a POSIX-based multi-user, multi-task, multi-threaded and multi-CPU operating system, using Linux can run major Unix tools, applications and network protocols.

1. Basic environment description

Virtual machine: VMWare

Operating system: linux

Database version: mysql 5.7.13 Community Edition (Don't ask why not install Enterprise Edition, because Enterprise Edition costs money)

Background: virtual machines can be connected to the external network

2. Find out

Check to see if mysql is installed on linux

① Startup Service service mysqld start

If it is not installed, prompt

② to check whether the service exists chkconfig on linux-- list mysqld

If it is not installed, prompt

3. Create a / tools directory (download files to this directory) and enter the / tools directory

# mkdir / tools# cd / tools

4. Download mysql 5.7.13

# wget http://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

5. Decompression

# tar-xzf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

6. Create a directory / data/mysql (the directory where the installation is located)

# cd / # mkdir data# cd / data# mkdir mysql

7. Create new mysql users, groups and directories

# groupadd mysql# useradd-r-s / sbin/nologin-g mysql mysql- d / tools/mysql-5.7.13-linux-glibc2.5-x86_64

8. Change directories and assign permissions

# cd/tools/mysql-5.7.13-linux-glibc2.5-x86_64#pwd#chown-R mysql. # chgrp-R mysql. # chown-R mysql / data/mysql

If you do not do steps 6-8, you will get an error: bin/mysqld: no such file or directory

9. Set parameters

# bin/mysqld-initialize-user=mysql-basedir=/tools/mysql-5.7.13-linux-glibc2.5-x86_64-datadir=/data/mysql

Note that remember the temporary password of the red box, which will be used later

# bin/mysql_ssl_rsa_setup-datadir=/data/mysql

10. Modify the configuration file

# cd support-files

# cp my-default.cnf / etc/my.cnf# cp mysql.server / etc/init.d/mysql

# vim / etc/init.d/mysql

Modify the following:

# vim / etc/my.cnf

Modify the following:

After the revision, it is best to check it again, sometimes accidentally misspelled, will lead to a lot of messy mistakes.

11. Start mysql

Note: check whether the path used in the my.cnf configuration file exists. If it does not exist, please create it yourself.

# bin/mysqld_safe-- user=mysql &

Bin/mysql-user=root-p

-enter the temporary password generated in step 9

12. Change the root password

Mysql > set password=password ('123456');-- enter a new password

13. Delegate authority

Mysql > grant all privileges on *. * to 'root'@'%' identified by' 123456 unknown MySQL > flush privileges

14. Inspection results

Mysql > use mysql;mysql > select host,user from user;mysql > exit

15. Add system path

# vim / etc/profile

Add:

Export PATH=/usr/local/mysql/bin:$PATH

# source / etc/profile

16. Configure mysql self-startup

# chmod 755 / etc/init.d/mysql# chkconfig-add mysql# chkconfig-level 345 mysql on

Thank you for your reading. I hope you have a certain understanding of the key issue of "sample Analysis of VMWare linux mysql 5.7.13 installation and configuration". The specific use needs to be understood by everyone through hands-on experiments. Go and try it. If you want to read more articles about related knowledge points, welcome to follow the industry information channel!

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.