广州 网站备案,太阳能 技术支持 东莞网站建设,首页设计图,济南建设信息网站1、编译安装MySQL需要一些必备的组件#xff0c;可以直接使用yum安装即可yum -y install cmake ncurses-devel gcc-c2 创建 Mysql用户useradd mysql3 分别给mysql创建程序安装目录和数据存储目录#xff0c;这里将mysql安装在/opt下#xff0c;数据存储在 /data/mysql下mkdi…1、编译安装MySQL需要一些必备的组件可以直接使用yum安装即可yum -y install cmake ncurses-devel gcc-c2 创建 Mysql用户useradd mysql3 分别给mysql创建程序安装目录和数据存储目录这里将mysql安装在/opt下数据存储在 /data/mysql下mkdir /opt/mysql-5.6.39chown -R mysql.mysql /opt/mysql-5.6.39 (授权)mkdir /data/mysql/{log,data} -pchown -R mysql.mysql /data/mysql (授权)mkdir /var/lib/mysqlchown -R mysql.mysql /var/lib/mysql (授权)3 下载/解压 Mysqltar -xvf mysql-5.6.39.tar.gz编译(1)cmake \-DCMAKE_INSTALL_PREFIX/opt/mysql-5.6.39 \-DMYSQL_DATADIR/data/mysql \-DSYSCONFDIR/etc \-DWITH_MYISAM_STORAGE_ENGINE1 \-DWITH_INNOBASE_STORAGE_ENGINE1 \-DWITH_MEMORY_STORAGE_ENGINE1 \-DWITH_READLINE1 \-DMYSQL_UNIX_ADDR/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT3306 \-DENABLED_LOCAL_INFILE1 \-DWITH_PARTITION_STORAGE_ENGINE1 \-DEXTRA_CHARSETSall \-DDEFAULT_CHARSETutf8 \-DDEFAULT_COLLATIONutf8_general_ci(2)make (大约20分钟)(3)make install4 初始化数据库cd /opt/mysql-5.6.39scripts/mysql_install_db --basedir/usr/local/mysql --datadir/usr/local/mysql/data --usermysql5 添加servicecp support-files/mysql.server /etc/init.d/mysqlchkconfig mysql onservice mysql start —启动MySQL修改vim /etc/profile文件在文件末尾添加PATH/usr/local/mysql/bin:$PATHexport PATHsource /etc/profile
