一   下載

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*