Winning bid for Kirin operating system to install mysql5.7.21
Download the installation package on the official website.
1. Check whether the mysql package has been installed:
Rpm-qa | grep mysql
Mysql-libs-5.1.73-8.el6_8.ns6.01.x86_64
Mysql-5.1.73-8.el6_8.ns6.01.x86_64
Mysql-devel-5.1.73-8.el6_8.ns6.01.x86_64
2. Uninstall:
Rpm-e-- nodeps mysql-libs-5.1.73-8.el6_8.ns6.01.x86_64
Rpm-e-- nodeps mysql-5.1.73-8.el6_8.ns6.01.x86_64
Rpm-e-- nodeps mysql-devel-5.1.73-8.el6_8.ns6.01.x86_64
3. Find the installation path of mysql and delete it one by one.
Find / name mysql
After that, the installation begins.
Mkdir / home/mysql
Mkdir / home/mysql/data
Groupadd mysql
Useradd-g mysql-d / home/mysql mysql
Extract the installation package
Tar-xzvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
Cd mysql-5.7.21-linux-glibc2.12-x86_64
Move the directory to the home/mysql directory and rename
Mv * / home/mysql
Cd / home/mysql
Ls
Install, print the last act on the screen and copy down the initial password for later use.
. / bin/mysqld-user=mysql-basedir=/home/mysql-datadir=/home/mysql/data-initialize
Bin/mysql_ssl_rsa_setup-datadir=/home/mysql/data
Modify data directory permissions in mysql directory
Chown-R mysql:mysql / home/mysql/data
Chmod-R 755 / home/mysql/data
Cd support-files/
Ls
Vim mysql.server
Basedir=/home/mysql
Datadir=/home/mysql/data
: wq
. / support-files/mysql.server start
If there is no my.cnf under / etc/, create one yourself.
Touch / etc/my.cnf
Vim / etc/my.cnf
[client]
Port = 3306
Default-character-set=utf8
[mysqld]
Basedir = / home/mysql
Datadir = / home/mysql/data
Port = 3306
Character_set_server=utf8
Init_connect='SET NAMES utf8'
: wq
(not all configuration files can be copied elsewhere)
Put the startup script in the boot initialization directory
Cp / home/mysql/support-files/mysql.server / etc/init.d/mysqld
Chmod 755 / etc/init.d/mysql
Chmod 755 / etc/init.d/mysqld
Chkconfig-- add mysqld registers mysql as a startup entry
Chkconfig-- list mysqld to check whether the addition is successful
Chkconfig mysqld on
Create a soft connection
Ln-s / home/mysql/bin/mysql / usr/bin/mysql
Cd bin
. / mysql-u root-p
Initial password generated by the system
Set password=password ('new password')
Use mysql
Update user set host='%' where user='root'
GRANT ALL PRIVILEGES ON. Password set by TO 'username' @'% 'IDENTIFIED BY' 'WITH GRANT OPTION
FLUSH PRIVILEGES
Exit
Service mysqld restart
