一、linux安装mysql

一、下载mysql免编译包：

wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

二、安装

#1、解压
tar -zxvf /mnt/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
#2、移动文件到/usr/local/mysql
mv /mnt/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 '010209'
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 -p010209 -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '010209' WITH GRANT OPTION;FLUSH PRIVILEGES;"
#删除多于用户用于远程CDH在安装时密码不正确
mysql -uroot -p010209 -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

 3、MySQL [ERROR] Table 'mysql.user' doesn't exist

https://www.cnblogs.com/yfb918/p/10635496.html