CentOS7.2 automatically installs mysql

CentOS7.2 automatically installs mysql

########################### Number of preemptible parts ########## #############

-- Every time MySQL is installed, it is laborious and time-consuming.

-- CentOS6.5 CentOS7.2 self-test successful

-- This is used to install MYSQL on your own. It's a cool job.

Install: Download The mysql.rar file and follow readme.txt.

############################# Terminator ######### #################

Or you can change it yourself.

Shell file:

[Java] view plaincopy

1. #! /Bin/sh
3. # Closing a process
4. /Etc/init. d/mysqldstop
5. Killallmysqld
6. Pids = ($ (ps-ef | grepmysql | awk '{print $2 }'))
7. For (I = 0; I <$ {# pids [@]}; I ++); do
8. Echo "shut down the process: pid $ {pids [I]}"
9. Kill-9 $ {pids [I]}
10. Done
12. # UninstallMariaDB
13. Mariadb = ($ (rpm-qa | grep-iMariaDB ))
14. For (I = 0; I <$ {# mariadb [@]}; I ++); do
15. Echo "Old mariadb: $ {mariadb [I]}"
16. Echo "delete ..."
17. Yum-yremove $ {mariadb [I]}
18. Done
19. # Force uninstall to prevent residue
20. Mariadb = ($ (rpm-qa | grep-iMariaDB ))
21. For (I = 0; I <$ {# mariadb [@]}; I ++); do
22. Echo "Old mariadb: $ {mariadb [I]}"
23. Echo "Force Delete ..."
24. Rpm-e -- nodeps $ {mariadb [I]}
25. Rpm-e -- noscripts $ {mariadb [I]}
26. Done
28. # Uninstalloldmysql
29. Old_mysql = ($ (rpm-qa | grep-imysql ))
30. For (I = 0; I <$ {# old_mysql [@]}; I ++); do
31. Echo "Old MYSQL: $ {old_mysql [I]}"
32. Echo "delete ..."
33. Yum-yremovejava $ {old_mysql [I]}
34. Done
35. # Removeoldmysqlfiles
36. Old_mysql_file = ($ (find/-namemysql ))
37. For (I = 0; I <$ {# old_mysql_file [@]}; I ++); do
38. Echo "Old MYSQL file: $ {old_mysql_file [I]}"
39. If [[$ {old_mysql_file [I]} = ~ "/Usr/mysql"]
40. Then
41. Continue
42. Fi
43. Echo "delete ..."
44. Rm-rf $ {old_mysql_file [I]}
45. Done
46. # Removesettingfiles
47. Rm-rf/var/log/mysqld. log
48. Rm-rf/etc/my. cnf *
49. Rm-rf/run/mysqld /*
50. Rm-rf/usr/bin/mysql *
52. # Findzipmysqlfile
53. SrcPath = $ (find/usr/mysql-maxdepth1-typef | grepmysql *. tar)
54. If [[$ srcPath = ~ "Mysql"]
55. Then
56. Echo "installation package: $ srcPath"
57. Else
58. Echo "Download mysql ..."
59. Yum-yinstallwget
60. Wgethttps: // response/
61. SrcPath = $ (find/usr/mysql-maxdepth1-typef | grepmysql *. tar)
62. Fi
64. # Unzip
65. Echo "decompress ..."
66. Tarxvf $ srcPath
68. # Install Dependencies
69. Echo "Install perl-DBI ..."
70. Yuminstall-yperl-DBI
71. Echo "Install libaio ..."
72. Yuminstall-ylibaio
74. # Install
75. Rpms = ($ (finding/usr/mysql-maxdepth1-typef | grepmysql-community ))
76. For (r =$ {# rpms [@]}; r> 0; r --); do
77. Echo "$ r"
78. For (I = 0; I <$ {# rpms [@]}; I ++); do
79. Echo ""
80. Echo "installation: $ {rpms [I]}"
81. Echo "Install ..."
82. Rpm-ivh $ {rpms [I]}
83. Done
84. Done
86. # Start startup
87. Chkconfigmysqldon
89. Echo ""
90. Echo "after installation, initialization Settings"
91. /Etc/init. d/mysqldstart
93. TmpPwd = $ (grep 'temporarypassword'/var/log/mysqld. log | awk-F': ''{print $2 }')
94. Echo "TempPasswordis $ tmpPwd"
96. Echo "#1. Stop mysql Database"
97. /Etc/init. d/mysqldstop
99. Echo "#2. Start mysqld_safe"
100. Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &
102. For (I = 0; I <10; I ++); do
103. Sleep4s
104. Ps = ($ (ps-ef | grepmysqld_safe | awk '{print $1 }'))
105. If [$ {# ps [@]}-gt1]; then
106. Echo "mysqld_safestarted"
108. Echo "#3. Use root to log on to the mysql database and set the password to" root ""
109. Mysql-urootmysql <EOF
110. /* Update the root password */
111. UPDATEuserSETauthentication_string = PASSWORD ('root') whereUSER = 'root ';
112. /* Refresh permission */
113. FLUSHPRIVILEGES;
114. EOF
116. TmpPwd = "root"
117. Break
118. Else
119. Echo "$ {I }..."
120. Sleep1s
121. If [$ {I}-ge5]; then
122. Echo "mysqld_safe: notstarted"
123. Break;
124. Fi
125. Fi
126. Done
128. Echo "restart mysql"
129. /Etc/init. d/mysqldrestart
131. # Write port = 3306 to the/etc/my. cnf File
132. Echo "set port"
133. Sed-I '/datadir =/I \ port = 3306'/etc/my. cnf
135. Echo "successrestart ..."
136. Servicemysqldrestart
138. Echo "mysqlhasbeeninstalledandstarted"
139. Echo ""
140. Echo"
141. Youprobablyneedtodooperationsasfollowsbyyourselfforsomesecurityreasons.
142. /* Enter MYSQL */
143. Mysql-uroot-p $ {tmpPwd}
144. /* Change Password Length Policy */
145. Setglobalvalidate_password_policy = 0;
146. Setglobalvalidate_password_length = 0;
147. /* Reset the password */
148. Alteruser 'root' @ 'localhost' identifiedby 'root ';
149. FLUSHPRIVILEGES;
150. /* Set Internet access */
151. Usemysql;
152. Select 'host' fromuserwhereuser = 'root ';
153. Updateusersethost = '%' whereuser = 'root ';
154. FLUSHPRIVILEGES;
155. "

1. Place it in/usr/mysql to run

2. Put the mysql file of mysql in/usr/mysql/

3. Set the initial password to root. Activate it as prompted by the installation.