一 下载
https://dev.mysql.com/downloads/
选择mysql community server
https://dev.mysql.com/downloads/mysql/
选择
linux generic
二 安装
参照 https://blog.csdn.net/MySQLJVM/article/details/118752409
574 gunzip mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
575 ls -lrt |grep mysql-5.7.31-linux-glibc2.12-x86_64.tar
577 tar -xvf mysql-5.7.31-linux-glibc2.12-x86_64.tar
589 groupadd mysql
590 useradd
chown -R mysql:mysql /usr/mysql-5.7.31-linux-glibc2.12-x86_64
rpm -qa |grep mariadb
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
rpm -qa |grep mariadb
cd support-files/
cp mysql.server /etc/init.d/mysqld
修改mysqld文件,basedir(安装路径)和datadir(数据存放路径)
basedir=/usr/local/mysql-5.7.31
datadir=/usr/local/mysql-5.7.31/data
/etc/my.cnf
[mysqld]
skip-grant-tables
basedir = /usr/local/mysql-5.7.31
datadir = /usr/local/mysql-5.7.31/data
port=3306
配置mysql环境变量
vi .bash_profile
PATH=$PATH:$HOME/.local/bin:$HOME/bin:/usr/mysql-5.7.31-linux-glibc2.12-x86_64/bin
mkdir -p /usr/local/mysql-5.7.31/data/
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql-5.7.31 --datadir=/usr/local/mysql-5.7.31/data
service mysqld start
三 问题及处理
1
MYSQL ERROR 1130 (HY000) 的错误解决方案
参照 https://blog.csdn.net/qq_22899021/article/details/81034431
2
Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
参照 https://blog.csdn.net/wufaqidong1/article/details/125500551
3 mysql 家目录切换问题
612 cd /home/mysql
613 ls -l
614 pwd
615 ls -la
616 chown -R mysql:mysql .bash_*
617 ls -la
618 chown -R mysql:mysql .bashrc
619 chown -R mysql:mysql .mozilla
620 ls -la
621 chmod a+x .bash*