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

Mysql 5.6rpm package for linux installation

Install the system and shut down selinux and iptables

1 close selinux and modify selinux configuration file (restart server takes effect)

[root@mysql1 ~] # 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=disabled

# SELINUXTYPE= can take one of these two values:

# targeted-Targeted processes are protected

# mls-Multi Level Security protection.

SELINUXTYPE=targeted

2 manage iptables (restart server takes effect)

Stop iptables

[root@mysql1 ~] # / etc/init.d/iptables stop

Turn off iptables and start up.

[root@mysql1] # chkconfig-- list iptables

Iptables 0: close 1: close 2: close 3: close 4: close 5: close 6: close

3 query whether there is a mysql residual package in the system, and if there is deletion processing, to ensure that there is no problem with the installation of mysql.

Query

[root@mysql1 install] # rpm-qa | grep mysql

Mysql-libs-5.1.71-1.el6.x86_64

Exist and delete

[root@mysql1 install] # rpm-e mysql-libs-5.1.71-1.el6.x86_64-nodeps

4 install mysql related files

Install server

[root@mysql1 install] # rpm-ivh MySQL-server-5.6.29-1.rhel5.x86_64.rpm

Warning: MySQL-server-5.6.29-1.rhel5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... # [100%]

1:MySQL-server # # [100%]

Install devel

[root@mysql1 install] # rpm-ivh MySQL-devel-5.6.29-1.rhel5.x86_64.rpm

Warning: MySQL-devel-5.6.29-1.rhel5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... # [100%]

1:MySQL-devel # # [100%]

Install client

[root@mysql1 install] # rpm-ivh MySQL-client-5.6.29-1.rhel5.x86_64.rpm

Warning: MySQL-client-5.6.29-1.rhel5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... # [100%]

1:MySQL-client # # [100%]

5. The modified parameter files of mysql database can be stored in Chinese (can be established manually)

[root@mysql1 install] # vi / etc/my.cnf

[client]

# client character set

Default-character-set=utf8

[mysqld]

# character set

Character-set-server=utf8

# case insensitive

Lower_case_table_names=1

[mysql]

# character set

Default-character-set=utf8

6 start the mysql service

[root@mysql1 install] # / etc/init.d/mysql start

7 change the login password

The initial password location is under the root directory of the installation user.

[root@mysql1 ~] # cat / root/.mysql_secret

# The random password set for the root user at Thu Jul 28 14:31:34 2016 (local time): 903yX2XlB1edVpua

8 Log in and change the password

[root@mysql1] # mysql-uroot-p903yX2XlB1edVpua

Mysql > set password=password ('oracle')

Query OK, 0 rows affected (0.00 sec)

Mysql > use mysql

Mysql > UPDATE user SET Password = password ('oracle') WHERE User =' root'

Mysql > flush privileges

Mysql > exit

9 modify the default data file path

Create a directory

[root@mysql1 ~] # cd / home/

[root@mysql1 home] # mkdir mysql

Stop the mysql service

[root@mysql1 home] # / etc/init.d/mysql stop

Shutting down MySQL.. [OK]

10 CP data file to new path

[root@mysql1 home] # cp-r / var/lib/mysql/ / home/mysql/

Modify my.cnf file and / etc/init.d/mysql file

Add socket path to my.cnf file

[root@mysql1 home] # vi / etc/my.cnf

[client]

# client character set

Default-character-set=utf8

Socket = / home/mysql/mysql.sock

[mysqld]

Socket = / home/mysql/mysql.sock

# character set

Character-set-server=utf8

# case insensitive

Lower_case_table_names=1

[mysql]

# character set

Default-character-set=utf8

Auto-rehash

Modify datadir path information in mysql file

[root@mysql1 home] # vi / etc/init.d/mysql

# If you change base dir, you must also change datadir. These may get

# overwritten by settings in the MySQL configuration files.

Basedir=

Datadir=/home/mysql/

Modify the permissions of the new mysql storage directory (both 755 and 775 have reported an error. There is no problem with starting when assigning a value of 777. I don't know why.)

[root@mysql1 home] # chmod-R 777 mysql/

[root@mysql1 home] # / etc/init.d/mysql start

Starting MySQL.. [OK]

The full text is over.

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.