Experiment: CentOS 7.3 binary installation mariadb10.2.8

1 Rpm-qa mariadb*

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/08/9B/wKiom1nkmDzipCL_AAFwPk3nxjg684.png-wh_500x0-wm_ 3-wmp_4-s_2561488328.png "title=" Sogou October 12, 17 1703_1.png "alt=" Wkiom1nkmdzipcl_aafwpk3nxjg684.png-wh_50 "/>

2 getent passwd MySQL

useradd-d/app/mysqldb-r-m-s/sbin/nologin MySQL

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/08/9B/wKiom1nkmFjzFWulAADC_f-r-I8279.png-wh_500x0-wm_ 3-wmp_4-s_2758826362.png "title=" Sogou October 12, 17 1708_3.png "alt=" Wkiom1nkmfjzfwulaadc_f-r-i8279.png-wh_50 "/>

3 Tar xvf mariadb-10.2.8-linux-x86_64.tar.gz-c/usr/local/

cd/usr/local/

Ln-s Mariadb-10.2.8-linux-x86_64/mysql

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/A7/4B/wKioL1nkla6wNf60AAFrVUxhnQs680.png-wh_500x0-wm_ 3-wmp_4-s_1519772553.png "title=" Sogou October 12, 17 1718_4.png "alt=" Wkiol1nkla6wnf60aafrvuxhnqs680.png-wh_50 "/>

4 cd/usr/local/mysql/

mkdir/etc/mysql/

CP SUPPORT-FILES/MY-HUGE.CNF/ETC/MYSQL/MY.CNF

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M00/08/9B/wKiom1nkmG2TRqVxAABhcsbqOJg190.png-wh_500x0-wm_ 3-wmp_4-s_4235203088.png "title=" Sogou October 12, 17 1721_6.png "alt=" Wkiom1nkmg2trqvxaabhcsbqojg190.png-wh_50 "/>

Vim/etc/mysql/my.cnf

[Mysqld]

DataDir =/app/mysqldb

Innodb_file_per_table = On

Skip_name_resolve = On

5

scripts/mysql_install_db--user=mysql--datadir=/app/mysqldb

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/A7/4B/wKioL1nklcbwEXH-AAB5_WlhGr0857.png-wh_500x0-wm_ 3-wmp_4-s_2536763697.png "title=" Sogou October 12, 17 1723_7.png "alt=" Wkiol1nklcbwexh-aab5_wlhgr0857.png-wh_50 "/>

6 CP Support-files/mysql.server/etc/init.d/mysqld

Chkconfig--list mysqld

Chkconfig--add mysqld

Service Mysqld start failed

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/08/9B/wKiom1nkmIyjSS11AAAqDH1TGeE501.png-wh_500x0-wm_ 3-wmp_4-s_1830977109.png "style=" Float:none; "title=" Sogou October 12, 17 1725_8.png "alt=" Wkiom1nkmiyjss11aaaqdh1tgee501.png-wh_50 "/>

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/A7/4B/wKioL1nkldegau44AABJ0L5MJv8136.png-wh_500x0-wm_ 3-wmp_4-s_617100560.png "style=" Float:none; "title=" Sogou October 12, 17 1726_10.png "alt=" Wkiol1nkldegau44aabj0l5mjv8136.png-wh_50 "/>

7 mkdir/var/log/mariadb/

Chown mysql/var/log/mariadb/

Service mysqld Start

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/08/9B/wKiom1nkmJ7wFY8AAAAmYWB9a1s657.png-wh_500x0-wm_ 3-wmp_4-s_3082362488.png "style=" Float:none; "title=" Sogou October 12, 17 1731_13.png "alt=" Wkiom1nkmj7wfy8aaaamywb9a1s657.png-wh_50 "/>

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/A7/4B/wKioL1nklejwm8o0AAA7cy94UgM146.png-wh_500x0-wm_ 3-wmp_4-s_1846426308.png "style=" Float:none; "title=" Sogou October 12, 17 1731_14.png "alt=" Wkiol1nklejwm8o0aaa7cy94ugm146.png-wh_50 "/>

8 vi/etc/profile.d/mysql.sh

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

. /etc/profile.d/mysql.sh

9 mysql_secure_installation

Ten Mysql-uroot-p

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M00/08/9B/wKiom1nkmK7RS3x9AABCXA7DrW4176.png-wh_500x0-wm_ 3-wmp_4-s_1280378283.png "title=" Sogou October 12, 17 1733_15.png "alt=" Wkiom1nkmk7rs3x9aabcxa7drw4176.png-wh_50 "/>

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/A7/4B/wKioL1nklgbxRot_AAIP7SL6nVQ469.png-wh_500x0-wm_ 3-wmp_4-s_3014356100.png "title=" Sogou October 12, 17 1734_16.png "alt=" Wkiol1nklgbxrot_aaip7sl6nvq469.png-wh_50 "/>

Experiment: CentOS 7.3 binary installation mariadb10.2.8