Install mysql5.7.17 and rpmmysql5.7.17 using RPM in linux

Source: Internet
Author: User

Install mysql5.7.17 and rpmmysql5.7.17 using RPM in linux

For your reference, the installation method record of mysql5.7 rpm in linux is as follows:

Delete old package:

# rpm -qa | grep -i mysql# rpm -ev mysql-libs-* --nodeps

Install the rpm package:

# rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm# rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm# rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm# rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm

Start and Stop:

# service mysqld start# service mysqld stop# service mysqld status

Initial random password:

# cat /var/log/mysqld.log | more

Modify the initial password and authorize remote access:

# mysql -uroot -pmysql> set password='Pwd@123456';mysql> grant all privileges on *.* to 'root'@'%' identified by 'Pwd@123456';

Password Complexity attributes:

mysql> set global validate_password_policy=0;

Validate_password_policy has the following values: (the default value is 1, that is, MEDIUM. Therefore, the password set at the beginning must conform to the length and must contain numbers, lowercase letters, or uppercase letters, and special characters .)

Modify the data directory:

The new directory must be authorized to the mysql user, and the mysqld_safe log file must be authorized to disable selinux (the method for setting related policies is not found)

# mkdir /data/mysql/data# mv /var/lib/mysql/* /data/mysql/data/# mkdir /data/mysql/log# chown mysql:mysql -R /data/mysql# touch mysqld_safe.log# chown mysql:mysql mysqld_safe.log# vi /etc/my.cnf/**[client]port = 3306socket = /data/mysql/log/mysql.sockdefault-character-set=utf8[mysql]no-auto-rehashsocket=/data/mysql/log/mysql.sockdefault-character-set=utf8[mysqld]port = 3306socket = /data/mysql/log/mysql.sockcharacter-set-server=utf8lower_case_table_names=1basedir=/usrdatadir=/data/mysql/datalog-error=/data/mysql/log/error.logpid-file=/data/mysql/log/mysql.pidinit_connect='SET NAMES utf8'symbolic-links=0skip-external-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_size = 256Kread_rnd_buffer_size = 512Kmyisam_sort_buffer_size = 8M[mysqld_safe]log-error=/data/mysql/log/mysqld_safe.log*/# getenforceEnforcing# setenforce 0# vi /etc/selinux/config/**# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:#   enforcing - SELinux security policy is enforced.#   permissive - SELinux prints warnings instead of enforcing.#   disabled - No SELinux policy is loaded.#SELINUX=enforcingSELINUX=disabled# SELINUXTYPE= can take one of these two values:#   targeted - Targeted processes are protected,#   mls - Multi Level Security protection.SELINUXTYPE=targeted */# service mysqld start

Other commands:

# mysqladmin -u root -p passwordmysql> select version();# chkconfig --list# chkconfig --level 345 mysqld on# netstat -na | grep 3306

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.

Related Article

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.