《mysql5.6.34编译安装步骤教程》由会员分享，可在线阅读，更多相关《mysql5.6.34编译安装步骤教程（3页珍藏版）》请在金锄头文库上搜索。
1、mysql5.6.34mysql5.6.34 编译安装步骤教程编译安装步骤教程1.添加用户名? 1 2 3rootweb01 tools# useradd -s /sbin/nologin -M mysql rootlb01 # id mysql uid=27(mysql) gid=27(mysql) groups=27(mysql)2.安装相关依赖? 1 2 3 4yum install ncurses-devel libaio-devel -y rpm -qa ncurses-devel libaio-devel yum install cmake -y rpm -qa cmake3.下载
2、 mysql 并解压? 1 2 3 4cd /data wget https:/ tar xf mysql-5.6.34.tar.gz -C /data/ cd /data/mysql-5.6.344.cmake 指定路径? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16cmake . -DCMAKE_INSTALL_PREFIX=/data/mysql-5.6.34 -DMYSQL_DATADIR=/data/mysql-5.6.34/data -DMYSQL_UNIX_ADDR=/data/mysql-5.6.34/tmp/mysql.sock -DDEFAU
3、LT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITH_ZLIB=bundled -DWITH_SSL=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_EMBEDDED_SERVER
4、=1 -DENABLE_DOWNLOADS=1 -DWITH_DEBUG=05.编译安装? 1make & make install6.建立软连接 #防错? 1ln -s /data/mysql-5.6.34/ /data/mysql7.初始化数据库且设置权限? 1 2 3 4cp support-files/my*.cnf /etc/f cd /application/mysql /data/mysql/scripts/mysql_install_db -basedir=/data/mysql/ -datadir=/data/mysql/data -user=mysql 035 棋牌 ch
5、own -R mysql.mysql /data/mysql/8.设置 mysql 命令及密码? 1 2 3 4 5 6 7 8echo PATH=/data/mysql/bin/:$PATH /etc/profile tail -1 /etc/profile source /etc/profile echo $PATH mysql mysqladmin -u root password oldboy123 mysql -uroot -poldboy1239.解决报错1.故障:ERROR! The server quit without updating PID file1.权限.chown
6、-R mysql.mysql2.killall mysqld2.报错? 1Warning TIMESTAMP with implicit DEFAULT value is deprecated. Please use -explicit_defaults_for_timestamp server option (see documentation for more details).易火棋牌 （中文大意：强烈建议不要使用带有隐式默认值的 TIMESTAMP。请使用explicit_defaults_for_timestamp 选项）在/etc/f 下添加explicit_defaults_for_timestamp=true
