安裝lamp之 一鍵安裝單一實例mysql

標籤：一鍵安裝mysql

#!/bin/sh

#一鍵安裝單一實例mysql

#xiaogao 20190921

#建立相關mysql使用者

groupadd mysql

useradd -s /sbin/nologin -g mysql -M mysql

tail -1 /etc/passwd

#安裝mysql依賴庫

yum -y install ncurses-devel 

#開啟安裝mysql，記得先上傳安裝包到/home/lvnian/tools/

cd /home/lvnian/tools/

tar zxf mysql-5.1.72.tar.gz

cd mysql-5.1.72

./configure \

--prefix=/application/mysql5.1.72 \

--with-unix-socket-path=/application/mysql5.1.72/tmp/mysql.sock \

--localstatedir=/application/mysql5.1.72/data \

--enable-assembler \

--enable-thread-safe-client \

--with-mysqld-user=mysql \

--with-big-tables \

--without-debug \

--with-pthread \

--enable-assembler \

--with-extra-charsets=complex \

--with-readline \

--with-ssl \

--with-embedded-server \

--enable-local-infile \

--with-plugins=partition,innobase \

--with-mysqld-ldflags=-all-static \

--with-client-ldflags=-all-static 

#--with-plugin-PLUGIN \

make && make install

echo $?

#製作軟串連:

ln -s /application/mysql5.1.72  /application/mysql

#建立msyql資料庫檔案

cd /home/lvnian/tools/mysql-5.1.72/support-files/

ls my*.cnf -l

/bin/cp my-small.cnf /etc/my.cnf

mkdir /application/mysql/data -p

chown -R mysql.mysql /application/mysql/data/

#初始化資料庫

/application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql

#啟動mysql資料庫

#/application/mysql/bin/mysqld_safe &

#啟動方法2

echo "-----------啟動方法mysql 2---------------"

cp /home/lvnian/tools/mysql-5.1.72/support-files/mysql.server /etc/init.d/mysqld

chmod 700 /etc/init.d/mysqld 

/etc/init.d/mysqld restart

sleep 5

netstat -lnt|grep 3306

lsof -i :3306

#設定mysql命令全域使用路徑

echo ‘PATH=$PATH:/application/mysql/bin‘ >> /etc/profile 

source /etc/profile

which mysql  

#設定開機自啟動mysql資料庫

chkconfig --add mysqld

chkconfig mysqld on

chkconfig --list mysqld

#進入資料庫：

mysql 

quit；

####單一實例mysql安裝完畢

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

#修改密碼

mysqladmin -uroot password ‘lvnian‘

本文出自 “技術改變命運” 部落格，請務必保留此出處http://lvnian.blog.51cto.com/7155281/1696817

安裝lamp之 一鍵安裝單一實例mysql