安装:
mysql二进制安装步骤 二进制安装是压缩包中放的是已经编译好的文件只需要配置my.cnf配置文件和启停脚本。
安装步骤:
1、在进行安装前需要进行查看内存空间、查看磁盘情况、查看几个核、查看当前系统版本、查看防火墙情况、查看selinux是否关闭。
free -h
df -h
nproc (number of processes)
ca /etc/redhat-release
iptables -L
getenforce
2、安装相应的依赖包。(二进制这一步不需要,可以在安装过程中缺啥补啥)
yum install -y ncurses-devel libaio-devel gcc make cmake
3、wget下载相应的压缩包,解压缩。
wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.49-linux-glibc2.12-x86_64.tar.gz
4、多实例管理,准备两个端口的配置文件,启停脚本,生成mysql的初始化data数据。
5、启动mysql,如果报错查看1)my.cnf配置文件 2)启停文件mysqld_3306 3)权限 4)初始化命令
启停脚本分3306和3307,如果不是多实例安装基本不用动默认的启停文件mysqld
[root@worker01 3307]# cat mysql_3307
port=3307
mysql_user="mysql"
cmdpath="/usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/bin/"
mysql_sock="/data/my_sql/${port}/mysql.sock"
mysqld_pid_file_path=/data/my_sql/${port}/mysqld_${port}.pid
start(){
if [ ! -e "$mysql_sock" ];then
printf "starting MySQL...\n"
/bin/sh ${cmdpath}/mysqld_safe --defaults-file=/data/my_sql/${port}/my.cnf --pid-file=$mysqld_pid_file_path 2>&1 > /dev/null &
sleep 3
else
printf "MySOL is running...\n"
exit 1
fi
}
stop(){
if [ ! -e "$mysql_sock" ];then
printf "MySOL is stopped...\n"
exit 1
else
printf "stoping MySQL...\n"
mysqld_pid=`cat "$mysqld_pid_file_path"`
if (kill -0 $mysqld_pid 2>/dev/null)
then
kill $mysqld_pid
sleep 2
fi
fi
}
restart(){
printf "Restarting MySQL...\n"
stop
sleep 2
start
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart)
restart
;;
*)
printf "Usage: /data/my_sql/${port}/mysql{start|stop|restart}\n"
esac
my.cnf配置文件,分3306和3307两个
[root@worker01 3307]# cat my.cnf
[client]
[mysqld]
port=3307
socket=/data/my_sql/3307/mysql.sock
basedir=/usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/
datadir=/data/my_sql/3307/data
log-bin=/data/my_sql/3307/mysql-bin
server-id=2
language = /usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share/english/
[mysqld_safe]
log-error=/data/my_sql/3307/mysql_3307_error.log
pid-file=/data/my_sql/3307/mysqld_3307.pid
6、使用netstat -tunlp | grep mysql查看是否成功
错误Error message file ‘/usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share/errmsg.sys’ had only 886
在其中遇到了Error message file ‘/usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share/errmsg.sys’ had only 886
检查/usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share此目录下是否有errmsg.sys这个文件,如果有在my.cnf中的[mysqld]下及一句
language = /usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share/
如果/usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share此目录下没有errmsg.sys这个文件,看usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share/english/这个目录下是否有,如果有加上
language = /usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/share/english/
以上是新手小白安装中遇到的问题,及解决方法。