天天看點

初始化mysql 資料庫步驟_安裝&初始化mysql過程中的問題

#----------Add user-------#

/usr/sbin/groupaddmysql

/usr/sbin/useradd -g mysqlmysql

#--------Confiugre & make install -------#

cd /root/tools

tar zxvf mysql-5.5.3-m3.tar.gz

cd mysql-5.5.3-m3/

./configure --prefix=/usr/local/webserver/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase,myisammrg

make && make install

chmod +w /usr/local/webserver/mysql

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

cd ..

#--------Make dir----------#

mkdir -p /data/mysql/data/

mkdir -p /data/mysql/binlog/

mkdir -p /data/mysql/relaylog/

chown -R mysql:mysql /data/mysql/

#--------Initialize MySQL-----#

/usr/local/webserver/mysql/bin/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/data/mysql/data --user=mysql

#-------Start MySQL----------#

[ -f /root/tools/my.cnf ] && cp /usr/local/webserver/mysql/my.cnf

echo "/bin/sh /usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/usr/local/webserver/mysql/my.cnf&" >> /etc/rc.local

/bin/sh /usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/usr/local/webserver/mysql/my.cnf &