#!/bin/sh
#####this is install mysql 5.5.32 scripts#####
#####liycwing
function mysql(){
yum install ncurses-devel libaio-devel -y
cd /application/tools
tar zxf cmake-2.8.8.tar.gz
cd cmake-2.8.8
./configure
gmake
gmake install
cd ..
groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql
cd /application/tools/
tar zxf mysql-5.5.32.tar.gz
cd /application/tools/mysql-5.5.32
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
make && make install
if [ -d "/application/mysql-5.5.32" ];then
echo -e "\033[32mMySQL install successfully! \033[0m"
else
echo -e "\033[31mMySQL install failed,Please Contact Author! \033[0m"
exit 1
fi
cd ~
ln -s /application/mysql-5.5.32 /application/mysql
/bin/cp /application/tools/mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf
echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
source /etc/profile
chown -R mysql.mysql /application/mysql
cd /application/mysql/scripts/
./mysql_install_db --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data/
/bin/cp /application/tools/mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
/application/mysql/bin/mysqladmin -u root password 'liycwing123'
mysql -uroot -pliycwing123 -e "drop database test;"
mysql -uroot -pliycwing123 -e "delete from mysql.user where host='::1';"
mysql -uroot -pliycwing123 -e "delete from mysql.user where host='db2';"
mysql -uroot -pliycwing123 -e "delete from mysql.user where user='' and host='localhost';"
}
mysql
运维网声明
1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网 享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com