MySQL单实例、多实例安装
2025-07-22 09:56 点击:0
【单实例安装】说明:即只提供一个服务,一个端口sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/networkhostname mysqlyum -y install ncurses-devel gcc gcc-c++useradd mysql -s /sbin/nologin -Mtar xf cmake-2.8.8.tar.gzcd cmake-2.8.8./configuregmakegmake installcd ..tar xf mysql-5.5.32.tar.gzcd mysql-5.5.32cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/usr/local/mysql/data \-DMYSQL_UNIX_ADDR=/usr/local/mysql/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_ZLIB=bundled \-DENABLED_LOCAL_INFILE=1 \-DWITH_READLINE=1 \-DWITH_EMBEDDED_SERVER=1 \-DWITH-DEBUG=0make && make install cp support-files/my-small.cnf /etc/my.cnfln -s /usr/local/mysql/bin/* /usr/local/sbin chmod -R 1777 /tmp chown -R mysql:mysql /usr/local/mysql cd /usr/local/mysql/scripts/./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysqlcp /opt/mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqldservice mysqld startchkconfig mysqld onmysql -e "delete from mysql.user where user='';"mysql -e "delete from mysql.user where host='localhost.localdomain';"mysql -e "delete from mysql.user where host='::1';"mysql -e "drop database test;"mysqladmin -u root password "wsyht123"【多实例安装】说明:多实例,指多个端口,多个MySQL提供服务sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/networkhostname mysqlyum -y install ncurses-devel gcc gcc-c++ libaio-develuseradd mysql -s /sbin/nologin -Mtar xf cmake-2.8.8.tar.gzcd cmake-2.8.8./configuregmakegmake installcd ..tar xf mysql-5.5.32.tar.gzcd mysql-5.5.32cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/usr/local/mysql/data \-DMYSQL_UNIX_ADDR=/usr/local/mysql/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_ZLIB=bundled \-DENABLED_LOCAL_INFILE=1 \-DWITH_READLINE=1 \-DWITH_EMBEDDED_SERVER=1 \-DWITH-DEBUG=0make && make install ln -s /usr/local/mysql/bin/* /usr/local/sbinchmod 700 /opt/mysqlmkdir -p /data/{3306,3307,3308}cp /opt/my.cnf /data/3306/cp /opt/my.cnf /data/3307/cp /opt/my.cnf /data/3308/cp /opt/mysql /data/3306cp /opt/mysql /data/3307cp /opt/mysql /data/3308chmod -R 1777 /tmp chown -R mysql:mysql /datachown -R mysql:mysql /usr/local/mysqlcd /usr/local/mysql/scripts./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3306/data/ --user=mysql./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3307/data/ --user=mysql./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3308/data/ --user=mysql/data/3306/mysql start