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

1. Download the RPM package for Linux, such as the RPM package for CentOS6.7_64, as follows:

[root@mysql ~] # ll

The total dosage is 113808

-rw-. 1 root root 1434 December 13 18:47 anaconda-ks.cfg

-rw-r--r--. 1 root root 42556 December 13 18:47 install.log

-rw-r--r--. 1 root root 10033 December 13 18:45 install.log.syslog

-rw-r--r--. 1 root root 23135399 December 13 18:56 MySQL-client-5.6.25-1.linux_glibc2.5.x86_64.rpm

-rw-r--r--. 1 root root 4586217 December 13 18:56 MySQL-devel-5.6.25-1.linux_glibc2.5.x86_64.rpm

-rw-r--r--. 1 root root 88715219 December 13 18:56 MySQL-server-5.6.25-1.linux_glibc2.5.x86_64.rpm

two。 Check MySQL and related RPM packages for installation, and if any, remove (rpm-e name)

[root@mysql ~] # rpm-qa | grep-I mysql

Mysql-libs-5.1.73-5.el6_6.x86_64

[root@mysql] # rpm-ev mysql-libs-5.1.73-5.el6_6.x86_64-- nodeps

3. Install MySQL

[root@mysql] # rpm-ivh MySQL-server-5.6.25-1.linux_glibc2.5.x86_64.rpm

Preparing... # [100%]

1:MySQL-server # # [100%]

Warning: user mysql does not exist-using root

Warning: group mysql does not exist-using root

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as / usr/my.cnf and

Will be used by default by the server when you start it.

You may edit this file to change server settings

[root@mysql] # rpm-ivh MySQL-devel-5.6.25-1.linux_glibc2.5.x86_64.rpm

Preparing... # [100%]

1:MySQL-devel # # [100%]

[root@mysql] # rpm-ivh MySQL-client-5.6.25-1.linux_glibc2.5.x86_64.rpm

Preparing... # [100%]

1:MySQL-client # # [100%]

4. Initialize MySQL and set password

[root@mysql ~] # / usr/bin/mysql_install_db-- mysql_install_db script to generate the account and corresponding permission permission table

WARNING: The host 'mysql' could not be looked up with / usr/bin/resolveip.

This probably means that your libc libraries are not 100% compatible

. . Omit the output.

WARNING: Default config file / etc/my.cnf exists on the system

This file will be read by default by the MySQL server

If you do not want to use this, either remove it, or use the

-- defaults-file argument to mysqld_safe when starting the server

[root@mysql ~] # service mysql start

Starting MySQL. SUCCESS!

[root@mysql ~] # cat / root/.mysql_secret-- check the root account password

# The random password set for the root user at Tue Dec 13 18:59:06 2016 (local time): 7MhtyX3aZEl9OUf8

[root@mysql] # mysql-uroot-p

Enter password:-- (copy and paste 7MhtyX3aZEl9OUf8 here)

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.6.2

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Note: the appearance of mysql > indicates that everything is going well.

Mysql > SET PASSWORD = PASSWORD ('123456');-- set the password to 123456

5. Allow remote login

Mysql > use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with-A

Database changed

Mysql > select host,user,password from user

+-- +

| | host | user | password | |

+-- +

| | localhost | root | * 6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| | mysql | root | * 6D95CDA252C85345E8BC1C4168E962D3949C30F9 |

| | 127.0.0.1 | root | * 6D95CDA252C85345E8BC1C4168E962D3949C30F9 |

| |:: 1 | root | * 6D95CDA252C85345E8BC1C4168E962D3949C30F9 |

+-- +

4 rows in set (0.00 sec)

Mysql > update user set password=password ('123456') where user='root'

Query OK, 3 rows affected (0.00 sec)

Rows matched: 4 Changed: 3 Warnings: 0

Mysql > update user set host='%' where user='root' and host='localhost'

Query OK, 1 row affected (0.01sec)

Rows matched: 1 Changed: 1 Warnings: 0

Mysql > flush privileges

Query OK, 0 rows affected (0.00 sec)

Mysql > exit

6. Set Boot self-boot

[root@mysql ~] # chkconfig mysql on

[root@mysql ~] # chkconfig-- list | grep mysql

Mysql 0: off 1: off 2: enable 3: enable 4: enable 5: enable 6: close

7. Default installation location of MySQL

/ var/lib/mysql/ # database directory

/ usr/share/mysql # configuration file directory

/ usr/bin # related command directory

/ etc/init.d/mysql # startup script

8. Change the MySQL directory and character set

[root@mysql01 /] # cd /

[root@mysql01 /] # mkdir data # create a data directory

[root@mysql01 /] # service mysql stop

Shutting down MySQL.... [OK]

[root@mysql01 /] # mv / var/lib/mysql / data # move the entire directory / var/lib/mysql to / home/data

[root@mysql01 /] # mkdir-p / data/mysql/binarylog

[root@mysql01 /] # chown-R mysql:mysql / data/mysql

If there is no my.cnf configuration file in the / etc/ directory, please find the * .cnf file under / usr/share/mysql/, copy one of them to / etc/ and rename it to my.cnf

[root@mysql ~] # cp / usr/share/mysql/my-default.cnf / etc/my.cnf-- modify the configuration file location

Configure / etc/my.cnf file, modify the data storage path, mysql.sock path and default encoding utf-8.

[root@mysql01 /] # cat / etc/my.cnf

[client]

Password = 123456

Port = 3306

Default-character-set = utf8

[mysqld]

Port = 3306

Socket = / data/mysql/mysql.sock

Character_set_server = utf8

Character_set_client = utf8

Collation-server=utf8_general_ci

Lower_case_table_names = 1

Max_connections = 1000

Datadir = / data/mysql/

Log_bin = / data/mysql/binarylog/binlog

[mysql]

Default-character-set = utf8

Socket = / data/mysql/mysql.sock

View character set

Show variables like'% collation%'

Show variables like'% char%'

9. Restart the MySQL service

[root@mysql ~] # service mysql restart

Shutting down MySQL.. SUCCESS!

Starting MySQL. SUCCESS!

OK is a success.

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.