CentOS 6.5 MySQL5.6.26源码安装

来源：互联网发布：mac 选项卡切换快捷键编辑：程序博客网时间：2024/06/06 12:53

一、源码安装cmake工具

从mysql5.5起，mysql源码安装开始使用cmake

wget http://cmake.org/files/v3.2/cmake-3.2.3.tar.gztar zxvf cmake-3.2.3.tar.gzcd cmake-3.2.3./bootstrapmakemake installcd ..

二、安装MySQL所需依赖包

yum -y install ncurses-devel libtool openssl-devel

三、安装MySQL

wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.26.tar.gzuseradd -r -s /sbin/nologin mysqlmkdir -pv /usr/local/mysql/datatar zxvf mysql-5.6.26.tar.gzcd mysql-5.6.26cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data/ -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DSYSCONFDIR=/etc -DENABLE_DOWNLOADS=1#出现错误，下次需要：rm -rf CMakeCache.txt makemake installrm -rf /etc/my.cnfcp support-files/my-default.cnf /etc/my.cnfcp support-files/mysql.server /etc/init.d/mysqldchmod 755 /etc/init.d/mysqldchown -R mysql.mysql /usr/local/mysql/##初始化数据库chmod +x scripts/mysql_install_dbscripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ln -s /usr/local/mysql/bin/* /usr/bin/ln -s /usr/local/mysql/lib/* /usr/lib/ln -s /usr/local/mysql/lib/* /usr/lib64/ln -s /usr/local/mysql/man/man1/*  /usr/share/man/man1ln -s /usr/local/mysql/man/man8/*  /usr/share/man/man8ln -s /usr/local/mysql/libexec/*  /usr/local/libexec

四、启动mysql服务并加入开机自启动

service mysqld startchkconfig mysqld on

五、验证mysql服务是否启动

netstat -tulnp | grep 3306  mysql

六、运行MySQL安全设置脚本

修改MySQL用户root的密码，同时可禁止root远程连接，移除test数据库和匿名用户。

mysql_secure_installation

所有选Y即可，也可根据个人爱好

七、MySQL相关

设置mysql登陆密码
例：

mysqladmin -u root password "111111"

0 0