MySQL官方安装方法(Linux Generic Binaries)

下载地址https://downloads.mysql.com/archives/community/
安装文档https://downloads.mysql.com/archives/community/

安装步骤

1.上传tar包

scp root@172.18.163.34:/home/mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz /home

2.用户组

groupadd mysql 
useradd-r-g mysql -s /bin/false mysql

3.解压到/usr/local

tar zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz -C /usr/local/

4.重命名

mv /usr/local/mysql-5.7.35-linux-glibc2.12-x86_64 mysql

5.日志和数据文件

mkdir mysql-files 
chown mysql:mysql mysql-files 
chmod 750 mysql-files

6.初始化

bin/mysqld--initialize--user=mysql

7.环境变量

export PATH=$PATH:/usr/local/mysql/bin

8.自启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server

9.启动

service mysql start

二.可能遇到的问题及处理

1.启动日志文件没权限

mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/

2.mysql启动程序

/usr/local/mysql/support-files/mysql.server

3. 默认mysql.sock位置,启动成功会生成

/var/lib/mysql/mysql.sock

4.mysql 配置文件

/etc/my.cnf

5.报错 原因配置文件是socket路径是myql.sock

ROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock 

6.重置root密码

ALTER USER USER() IDENTIFIED BY '1234';

7.授权远程登录

GRANT ALL  PRIVILEGES ON *.* TO 'user'@'%'IDENTIFIED BY '1234' WITH GRANT OPTION; 

8.指定ip远程登录

GRANT ALL  PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 

9.刷新权限使配置生效

FLUSH  PRIVILEGES