欧美成人精品在线,色偷偷www8888,噜噜噜综合亚洲

去MariaDB官網下載MariaDB本文用的是MariaDB 10.1.16
https://downloads.mariadb.org

選擇二進制版本，下載到/root目錄下
mariadb-10.1.16-linux-x86_64.tar.gz

開始安裝
[root@HE3 ~]# cat mariadb_auto_install.sh

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

									###### 二進制自動安裝數據庫腳本root密碼MANAGER將腳本和安裝包放在/root目錄即可###############

									######數據庫目錄/usr/local/mysql############

									######數據目錄/data/mysql############

									######日志目錄/log/mysql############

									######端口號默認3306其余參數按需自行修改############

									##################

									#author：[email protected]#

									##################

									#!/bin/bash

									PATH=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/bin

									export PATH

									# Check if user isroot

									if [ $(id -u) !="0" ]; then

									  echo "Error: You must be root to runthis script, please use root to install"

									  exit 1

									fi

									clear

									echo"========================================================================="

									echo "A tool toauto-compile & install MariaDB-10.1.16 on Redhat/CentOS Linux "

									echo"========================================================================="

									cur_dir=$(pwd)

									#set mysql rootpassword

									echo"==========================="

									mysqlrootpwd="MANAGER"

									echo -e "Please input the root password of mysql:"

									read -p "(Default password: MANAGER):" mysqlrootpwd

									if[ "$mysqlrootpwd" = "" ]; then

									mysqlrootpwd="MANAGER"

									fi

									echo"==========================="

									echo"MySQL root password:$mysqlrootpwd"

									echo"==========================="

									#which MySQL Versiondo you want to install?

									echo"==========================="

									isinstallmysql56="n"

									echo"Install mariadb-10.1.16,Please input y"

									read -p "(Please input y , n):" isinstallmysql56

									case"$isinstallmysql56" in

									y|Y|Yes|YES|yes|yES|yEs|YeS|yeS)

									echo"You will install MariaDB 10.1.16"

									isinstallmysql56="y"

									;;

									*)

									echo"INPUT error,You will exit install MariaDB 10.1.16"

									isinstallmysql56="n"

									  exit

									esac

									get_char()

									{

									SAVEDSTTY=`stty-g`

									stty-echo

									sttycbreak

									#ddif=/dev/tty bs=1 count=1 2> /dev/null

									stty-raw

									sttyecho

									stty$SAVEDSTTY

									}

									echo""

									echo"Press any key to start...or Press Ctrl+c to cancel"

									char=`get_char`

									# Initialize the installation related content.

									functionInitInstall()

									{

									cat/etc/issue

									uname -a

									MemTotal=`free -m | grep Mem | awk '{print $2}'` 

									echo -e "\n Memory is: ${MemTotal} MB "

									#Settimezone

									rm -rf /etc/localtime

									ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

									  #Delete Old Mysql program

									rpm -qa|grep mysql

									rpm -e mysql

									#DisableSeLinux

									if[ -s /etc/selinux/config ]; then

									sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

									fi

									  setenforce 0

									}

									#Installation ofdepend on and optimization options.

									functionInstallDependsAndOpt()

									{

									cd $cur_dir

									cat>>/etc/security/limits.conf<<EOF

									* soft nproc 65535

									* hard nproc 65535

									* soft nofile 65535

									* hard nofile 65535

									EOF

									echo"fs.file-max=65535" >> /etc/sysctl.conf

									}

									#Install MySQL

									functionInstallMySQL56()

									{

									echo"============================Install MariaDB 10.1.16=================================="

									cd $cur_dir

									#Backup old my.cnf

									#rm -f /etc/my.cnf

									if [ -s /etc/my.cnf]; then

									  mv /etc/my.cnf /etc/my.cnf.`date+%Y%m%d%H%M%S`.bak

									fi

									#mysql directoryconfiguration

									groupadd mysql -g512

									useradd -u 512 -gmysql -s /sbin/nologin -d /home/mysql mysql

									tar xvf/root/mariadb-10.1.16-linux-x86_64.tar.gz

									mv /root/mariadb-10.1.16-linux-x86_64 /usr/local/mysql

									mkdir -p /data/mysql

									mkdir -p /log/mysql

									chown -R mysql:mysql/data/mysql

									chown -R mysql:mysql/usr/local/mysql

									chown -R mysql:mysql/log

									SERVERID=`ifconfigeth0 | grep "inet addr" | awk '{ print $2}'| awk -F. '{ print$4"3306"}'`

									cat>>/etc/my.cnf<<EOF

									[client]

									port    =3306

									socket    =/tmp/mysql.sock

									default-character-set=utf8

									[mysql]

									default-character-set=utf8

									[mysqld]

									port    =3306

									socket    =/tmp/mysql.sock

									basedir    =/usr/local/mysql

									datadir    =/data/mysql

									open_files_limit  = 3072

									back_log = 103

									max_connections =800

									max_connect_errors =100000

									table_open_cache =512

									external-locking =FALSE

									max_allowed_packet =32M

									sort_buffer_size =2M

									join_buffer_size =2M

									thread_cache_size =51

									query_cache_size =32M

									tmp_table_size = 96M

									max_heap_table_size= 96M

									slow_query_log = 1

									slow_query_log_file= /log/mysql/slow.log

									log-error =/log/mysql/error.log

									long_query_time = 1

									server-id =$SERVERID

									log-bin =/log/mysql/mysql-bin

									sync_binlog = 1

									binlog_cache_size =4M

									max_binlog_cache_size= 8M

									max_binlog_size =1024M

									expire_logs_days =60

									key_buffer_size =32M

									read_buffer_size =1M

									read_rnd_buffer_size= 16M

									bulk_insert_buffer_size= 64M

									character-set-server=utf8

									default-storage-engine= InnoDB

									binlog_format = row

									innodb_buffer_pool_dump_at_shutdown= 1

									innodb_buffer_pool_load_at_startup= 1

									binlog_rows_query_log_events= 1

									explicit_defaults_for_timestamp= 1

									#log_slave_updates=1

									#gtid_mode=on

									#enforce_gtid_consistency=1

									#innodb_write_io_threads= 8

									#innodb_read_io_threads= 8

									#innodb_thread_concurrency= 0

									transaction_isolation= REPEATABLE-READ

									innodb_additional_mem_pool_size= 16M

									innodb_buffer_pool_size= 512M

									#innodb_data_home_dir=

									innodb_data_file_path= ibdata1:1024M:autoextend

									innodb_flush_log_at_trx_commit= 1

									innodb_log_buffer_size= 16M

									innodb_log_file_size= 512M

									innodb_log_files_in_group= 2

									innodb_max_dirty_pages_pct= 50

									innodb_file_per_table= 1

									innodb_locks_unsafe_for_binlog= 0

									wait_timeout = 14400

									interactive_timeout= 14400

									skip-name-resolve

									[mysqldump]

									quick

									max_allowed_packet =32M

									EOF

									/usr/local/mysql/scripts/mysql_install_db--basedir=/usr/local/mysql --datadir=/data/mysql --defaults-file=/etc/my.cnf--user=mysql

									cp/usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

									chmod 700 /etc/init.d/mysqld

									chkconfig --add mysql

									chkconfig --leve l2345 mysqld on

									cat >>/etc/ld.so.conf.d/mysql-x86_64.conf<<EOF

									/usr/local/mysql/lib

									EOF

									ldconfig

									if [ -d"/proc/vz" ];then

									ulimit -s unlimited

									fi

									/etc/init.d/mysqldstart

									cat >>/etc/profile <<EOF

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

									export LD_LIBRARY_PATH=/usr/local/mysql/lib

									EOF

									/usr/local/mysql/bin/mysqladmin-u root password $mysqlrootpwd

									cat >/tmp/mysql_sec_script<<EOF

									use mysql;

									delete frommysql.user where user!='root' or host!='localhost';

									flush privileges;

									EOF

									/usr/local/mysql/bin/mysql-u root -p$mysqlrootpwd -h localhost < /tmp/mysql_sec_script

									#rm -f/tmp/mysql_sec_script

									/etc/init.d/mysqldrestart

									source /etc/profile

									echo"============================MariaDB 10.1.16 installcompleted========================="

									}

									functionCheckInstall()

									{

									echo"===================================== Check install==================================="

									clear

									ismysql=""

									echo"Checking..."

									if [ -s/usr/local/mysql/bin/mysql ] && [ -s /usr/local/mysql/bin/mysqld_safe ]&& [ -s /etc/my.cnf ]; then

									 echo "MySQL: OK"

									 ismysql="ok"

									 else

									 echo "Error: /usr/local/mysql notfound!!!MySQL install failed."

									fi

									if ["$ismysql" = "ok" ]; then

									echo "MariaDB 10.1.16 completed! enjoy it."

									echo"========================================================================="

									netstat -ntl

									else

									echo"Sorry,Failed to install MySQL!"

									echo "You cantail /root/mysql-install.log from your server."

									fi

									}

									#The installationlog

									InitInstall2>&1 | tee /root/mysql-install.log

									CheckAndDownloadFiles2>&1 | tee -a /root/mysql-install.log

									InstallDependsAndOpt2>&1 | tee -a /root/mysql-install.log

									InstallMySQL562>&1 | tee -a /root/mysql-install.log

									CheckInstall2>&1 | tee -a /root/mysql-install.log

[root@HE3 ~]# mysql -uroot -p

Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.16-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

至此，mariadb-10.1.16安裝成功