一、下载mysql免编译包：
wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
二、安装
1、解压
tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz 2、移动文件到/usr/local/mysql
mv mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql 3、针对mysql增加用户
groupadd mysql useradd -g mysql -M mysql 4、将文件存入到/mnt/sata1/mysql/data ,并授权
mkdir -p /mnt/sata1/mysql/data chown -R mysql:mysql /mnt/sata1/mysql/data
yum install perl -y yum install -y perl-Module-Install.noarch
5、初始化MySQL数据库
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/sata1/mysql/data --user=mysql 6、#修改配置文件 sed -i "s?# basedir = .....?basedir = /usr/local/mysql?g" /usr/local/mysql/my.cnf sed -i "s?# datadir = .....?datadir = /mnt/sata1/mysql/data?g" /usr/local/mysql/my.cnf sed -i "s?# port = .....?port = 3306?g" /usr/local/mysql/my.cnf
7、添加mysqld 成为系统服务并设置自启动 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld chkconfig --add mysqld chkconfig mysqld on mkdir /var/log/mariadb
8、启动 /etc/init.d/mysqld start ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
9、设置密码 /usr/local/mysql/bin/mysqladmin -u root password ‘1234‘ service mysqld restart echo ‘export MYSQL_HOME=/usr/local/mysql‘ >> /etc/profile echo ‘export PATH=$PATH:$MYSQL_HOME/bin‘ >> /etc/profile source /etc/profile
10、开启远程访问 mysql -uroot -p1234 -e "GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘1234‘ WITH GRANT OPTION;FLUSH PRIVILEGES;" #删除多于用户用于远程CDH在安装时密码不正确 mysql -uroot -p1234 -e "delete from mysql.user where host<>‘%‘;" service mysqld restart
三、安装时遇到的相关错误总结
1、初始化MySQL数据库时：
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/sata1/mysql/data --user=mysql
出现以下错误：
/usr/local/mysql/scripts/mysql_install_db: /usr/bin/perl: 坏的解释器: 没有那个文件或目录
解决方法：
yum install perl
安装以后再次初始化数据库
报错：
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/sata1/mysql/data --user=mysql
出现：
FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:
Data::Dumper
解决办法：
yum install -y perl-Module-Install.noarch
安装以后再次初始化数据库
2、设置密码时错误
/usr/local/mysql/bin/mysqladmin -u root password ‘1234‘
出现以下错误：
/usr/local/mysql/bin/mysqladmin: connect to server at ‘localhost‘ failed
error: ‘Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)‘
Check that mysqld is running and that the socket: ‘/tmp/mysql.sock‘ exists!
解决办法：
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
原文：https://www.cnblogs.com/yfb918/p/10594069.html