Linux安装MySQL

Linux安装MySQL-rpm版本

一、查看之前是否有安装mysql

rpm -qa | grep -i mysql
// 卸载，如果有关联文件，不能直接卸载。可以强制卸载
rpm -e [mysql文件名]
rpm -e --nodeps [mysql文件名]

二、安装mysql

1.解压 mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar 文件

tar -xvf mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar

2.安装解压出的rpm文件，要按顺序解压

rpm -ivh mysql-community-common-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.16-1.el7.x86_64.rpm

3.在安装rpm的过程中会出现各种各样的错误

• 之前自己随便建了一个目录，一直报找不到依赖。
  
  尝试了各种方法都不行，就把安装包拷贝到/home目录下，才解决的。
• 少的依赖

[root@hecs-217624 home]# rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.16-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	libaio.so.1()(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64
	libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64
	libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64

yum install libaio

三、修改配置

vim /etc/my.cnf

在后面新增
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
validate_password=off
default-storage-engine=INNODB

四、启动服务

1. 启动 MySQL 服务：systemctl start mysqld
2. 重启 MySQL 服务：systemctl restart mysqld
3. 关闭 MySQL 服务：systemctl stop mysqld
4. 查看3306端口是否开启：netstat -ln | grep 3306

五、修改密码

1. 启动mysql服务
2. cat /var/log/mysqld.log |grep password 查看临时密码

[root@hecs-217624 home]# cat /var/log/mysqld.log |grep password
2022-06-30T09:16:56.190057Z 1 [Note] A temporary password is generated for root@localhost: nq.uUbaEq2n_
2022-06-30T09:22:51.571205Z 0 [Note] Shutting down plugin 'validate_password'
2022-06-30T09:22:52.885817Z 0 [Note] Shutting down plugin 'sha256_password'
2022-06-30T09:22:52.885820Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-06-30T09:22:53.262191Z 0 [Note] Plugin 'validate_password' is disabled.

3.先登录mysql界面，在修改用户密码，要是提示密码过于简单，可以去修改配置参数就行了

mysql -u root -p
set password for root@localhost = password('123456');

六、本地数据工具连接

由于MySQL服务器端远程连接权限没有对外开放，所以需要我们去开放。
先服务器登录进入mysql，执行下面的命令

GRANT ALL PRIVILEGES ON *.*  TO 'root'@'%' IDENTIFIED BY '数据库密码' WITH GRANT OPTION;

要是没有错误的话，直接刷新权限即可

flush privileges;

要是出现错误的话，按照对应的错误解决即可。