Linux安装mysql-5.7.26(一条龙服务)

2024-02-09 15:08

本文主要是介绍Linux安装mysql-5.7.26(一条龙服务),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

前期准备:

准备安装包,从官网下载:传送门
选择如下图:
在这里插入图片描述
下载的安装包,通过Xftp上传到linux服务器/usr/local
在这里插入图片描述


开始安装

1、卸载系统自带的Mariadb
[root@VM-0-17-centos local]# rpm -qa|grep mariadb
mariadb-libs-5.5.65-1.el7.x86_64
[root@VM-0-17-centos local]# rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64
2、删除etc目录下的my.cnf文件,若存在
[root@VM-0-17-centos local]# rm /etc/my.cnf
rm: cannot remove ‘/etc/my.cnf’: No such file or directory
3、检查mysql是否存在,若存在则删除
[root@VM-0-17-centos local]# rpm -qa | grep mysql#存在根据安装版本执行删除命令,不存在不用执行
[root@VM-0-17-centos local]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64
4、检查mysql用户组和用户是否存在,如无则创建
[root@VM-0-17-centos local]# cat /etc/group | grep mysql
[root@VM-0-17-centos local]# cat /etc/passwd | grep mysql#若上面两条命令查询为空,则执行一下语句创建用户组和用户
#1.创建mysql用户组
[root@VM-0-17-centos local]# groupadd mysql
#2.创建一个用户名为mysql的用户并加入mysql用户组
[root@VM-0-17-centos local]# useradd -g mysql mysql
5、解压安装安装包到/usr/local
[root@VM-0-17-centos local]# tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 
mysql-5.7.26-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-5.7.26-linux-glibc2.12-x86_64/bin/myisamchk
mysql-5.7.26-linux-glibc2.12-x86_64/bin/myisamlog
mysql-5.7.26-linux-glibc2.12-x86_64/bin/myisampack
mysql-5.7.26-linux-glibc2.12-x86_64/bin/mysql
mysql-5.7.26-linux-glibc2.12-x86_64/bin/mysql_client_test_embedded
mysql-5.7.26-linux-glibc2.12-x86_64/bin/mysql_config_editor
...#将解压后的文件夹移到 /usr/local/mysql
[root@VM-0-17-centos local]# mv mysql-5.7.26-linux-glibc2.12-x86_64/ mysql
6、更改 /usr/local/mysql 所属组和用户
[root@VM-0-17-centos local]# chown -R mysql mysql/
[root@VM-0-17-centos local]# chgrp -R mysql mysql/
[root@VM-0-17-centos local]# cd mysql/
7、在etc下新建配置文件my.cnf,并在该文件内添加以下配置
[root@VM-0-17-centos mysql]# vim /etc/my.cnf[mysqld]
port=3306
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
max_connections=100
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0#防止出现err-1118 - Row size too large
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
innodb_strict_mode=0
max_allowed_packet=16M#忽略大小写
lower_case_table_names=1#设置编码
character-set-server=utf8
collation-server=utf8_general_ci#IP绑定
#bind-address=192.168.8.100[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid#客户端连接设置
[client]
# 和上面要相同才行
socket=/usr/local/mysql/mysql.sockdefault-character-set=utf8
8、安装和初始化

记好root@localhost:后的字符串,此字符串为mysql管理员临时登录密码

[root@VM-0-17-centos mysql]# ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
2021-04-02T16:41:38.871015Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-04-02T16:41:39.187869Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-04-02T16:41:39.231305Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-04-02T16:41:39.287797Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4c070c30-93d2-11eb-971a-005056adeb2f.
2021-04-02T16:41:39.289089Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-04-02T16:41:39.291529Z 1 [Note] A temporary password is generated for root@localhost: TlJYLaBsE8,x

若是上一步出错,提示缺少依赖包libnuma.so.1,则要手动安装依赖包
yum安装的libnuma.so.1,安装时默认安装的是32的,但mysql需要的是64位的,如果已经安装了libnuma.so.1,先删除原有的yum remove libnuma.so.1,再安装64位的yum -y install numactl.x86_64

[root@VM-0-17-centos mysql]# yum remove libnuma.so.1
[root@VM-0-17-centos mysql]# yum -y install numactl.x86_64
9、拷贝启动文件,配置服务
[root@VM-0-17-centos mysql]# cp ./support-files/mysql.server /etc/init.d/mysqld
[root@VM-0-17-centos mysql]# chown 777 /etc/my.cnf
[root@VM-0-17-centos mysql]# chmod +x /etc/init.d/mysqld
10、重启
[root@VM-0-17-centos mysql]# /etc/init.d/mysqld restartERROR! MySQL server PID file could not be found!
Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM-0-17-centos.pid)

出现这种情况,可能是存在mysqld的进程,VM-0-17-centos.pid 没有读写权限;
使用chmod 777VM-0-17-centos.pid授权;
使用ps -ef|grep mysqld 查看是否存在,并kill pid杀死进程

[root@VM-0-17-centos mysql]# cd /usr/local/mysql/data
[root@VM-0-17-centos data]# chmod 777 VM-0-17-centos.pid[root@VM-0-17-centos data]# ps -ef|grep mysqld 
root      2632     1  0 00:43 pts/0    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/kfcs.pid
mysql     2861  2632  1 00:43 pts/0    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/usr/local/mysql/data/kfcs.pid --socket=/usr/local/mysql/mysql.sock --port=3306
root      2891  2350  0 00:43 pts/0    00:00:00 grep --color=auto mysqld[root@VM-0-17-centos data]# kill 2861[root@kfcs mysql]# ps -ef|grep mysqld 
root      2902  2350  0 00:45 pts/0    00:00:00 grep --color=auto mysqld
11、再次重启,ERROR先不用管,后面会解决,此时mysql已启动,往下继续
[root@kfcs mysql]# /etc/init.d/mysqld restartERROR! MySQL server PID file could not be found!
Starting MySQL. SUCCESS!
12、设置开机启动
[root@VM-0-17-centos data]# chkconfig --level 35 mysqld on[root@VM-0-17-centos data]# chkconfig --list mysqld
Note: This output shows SysV services only and does not include nativesystemd services. SysV configuration data might be overridden by nativesystemd configuration.If you want to list systemd services use 'systemctl list-unit-files'.To see services enabled on particular target use'systemctl list-dependencies [target]'.mysqld         	0:off	1:off	2:on	3:on	4:on	5:on	6:off[root@VM-0-17-centos data]# chmod +x /etc/rc.d/init.d/mysqld[root@VM-0-17-centos data]# chkconfig --add mysqld[root@VM-0-17-centos data]# chkconfig --list mysqldNote: This output shows SysV services only and does not include nativesystemd services. SysV configuration data might be overridden by nativesystemd configuration.If you want to list systemd services use 'systemctl list-unit-files'.To see services enabled on particular target use'systemctl list-dependencies [target]'.mysqld         	0:off	1:off	2:on	3:on	4:on	5:on	6:off[root@VM-0-17-centos data]# service mysqld statusSUCCESS! MySQL running (21262)[root@VM-0-17-centos data]# 
13、设置MySQL环境变量
[root@VM-0-17-centos data]# vim /etc/profile
#文件最下面添加:
export PATH=$PATH:/usr/local/mysql/bin#生效配置文件
[root@VM-0-17-centos data]# source /etc/profile
14、登录mysql(密码为初始化时的临时密码)

更改mysql密码为666666

[root@VM-0-17-centos data]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.26Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set PASSWORD = PASSWORD('666666');
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye
15、添加远程访问权限,使用新密码666666登录
[root@VM-0-17-centos data]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.26 MySQL Community Server (GPL)Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '666666' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye
16、重启生效,此时正常,没有ERROR,^_^
[root@VM-0-17-centos data]# service mysqld restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS! 
17、为了在任何目录下可以登录mysql
[root@VM-0-17-centos data]# ln -s /usr/local/mysql/bin/mysql   /usr/bin/mysql
18、开启外部访问数据库
#查看现在防火墙
[root@VM-0-17-centos data]# firewall-cmd --list-all #开放3306端口
[root@VM-0-17-centos data]# firewall-cmd --permanent --add-port=3306/tcp#查看3306端口是否开放
[root@VM-0-17-centos data]# firewall-cmd --query-port=3306/tcp[root@VM-0-17-centos data]# firewall-cmd --list-all 
19、如果开放不好使,那就把防火墙关掉
[root@VM-0-17-centos data]# service iptables stop
Redirecting to /bin/systemctl stop  iptables.service
Failed to stop iptables.service: Unit iptables.service not loaded.[root@VM-0-17-centos data]# /bin/systemctl stop  iptables.service
Failed to stop iptables.service: Unit iptables.service not loaded.[root@VM-0-17-centos data]# yum install iptables-services[root@VM-0-17-centos data]# /bin/systemctl stop  iptables.service[root@VM-0-17-centos data]# systemctl stop firewalld
[root@VM-0-17-centos data]#
20、连接测试

在这里插入图片描述


author:su1573
鄙人记录生活点滴,学习并分享,请多指教!!!
如需交流,请联系 sph1573@163.com,鄙人看到会及时回复

这篇关于Linux安装mysql-5.7.26(一条龙服务)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/694546

相关文章

Linux线程之线程的创建、属性、回收、退出、取消方式

《Linux线程之线程的创建、属性、回收、退出、取消方式》文章总结了线程管理核心知识:线程号唯一、创建方式、属性设置(如分离状态与栈大小)、回收机制(join/detach)、退出方法(返回/pthr... 目录1. 线程号2. 线程的创建3. 线程属性4. 线程的回收5. 线程的退出6. 线程的取消7.

SQL server数据库如何下载和安装

《SQLserver数据库如何下载和安装》本文指导如何下载安装SQLServer2022评估版及SSMS工具,涵盖安装配置、连接字符串设置、C#连接数据库方法和安全注意事项,如混合验证、参数化查... 目录第一步:打开官网下载对应文件第二步:程序安装配置第三部:安装工具SQL Server Manageme

C#连接SQL server数据库命令的基本步骤

《C#连接SQLserver数据库命令的基本步骤》文章讲解了连接SQLServer数据库的步骤,包括引入命名空间、构建连接字符串、使用SqlConnection和SqlCommand执行SQL操作,... 目录建议配合使用:如何下载和安装SQL server数据库-CSDN博客1. 引入必要的命名空间2.

Linux下进程的CPU配置与线程绑定过程

《Linux下进程的CPU配置与线程绑定过程》本文介绍Linux系统中基于进程和线程的CPU配置方法,通过taskset命令和pthread库调整亲和力,将进程/线程绑定到特定CPU核心以优化资源分配... 目录1 基于进程的CPU配置1.1 对CPU亲和力的配置1.2 绑定进程到指定CPU核上运行2 基于

全面掌握 SQL 中的 DATEDIFF函数及用法最佳实践

《全面掌握SQL中的DATEDIFF函数及用法最佳实践》本文解析DATEDIFF在不同数据库中的差异,强调其边界计算原理,探讨应用场景及陷阱,推荐根据需求选择TIMESTAMPDIFF或inte... 目录1. 核心概念:DATEDIFF 究竟在计算什么?2. 主流数据库中的 DATEDIFF 实现2.1

MySQL 多列 IN 查询之语法、性能与实战技巧(最新整理)

《MySQL多列IN查询之语法、性能与实战技巧(最新整理)》本文详解MySQL多列IN查询,对比传统OR写法,强调其简洁高效,适合批量匹配复合键,通过联合索引、分批次优化提升性能,兼容多种数据库... 目录一、基础语法:多列 IN 的两种写法1. 直接值列表2. 子查询二、对比传统 OR 的写法三、性能分析

golang程序打包成脚本部署到Linux系统方式

《golang程序打包成脚本部署到Linux系统方式》Golang程序通过本地编译(设置GOOS为linux生成无后缀二进制文件),上传至Linux服务器后赋权执行,使用nohup命令实现后台运行,完... 目录本地编译golang程序上传Golang二进制文件到linux服务器总结本地编译Golang程序

Linux下删除乱码文件和目录的实现方式

《Linux下删除乱码文件和目录的实现方式》:本文主要介绍Linux下删除乱码文件和目录的实现方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录linux下删除乱码文件和目录方法1方法2总结Linux下删除乱码文件和目录方法1使用ls -i命令找到文件或目录

MySQL中的LENGTH()函数用法详解与实例分析

《MySQL中的LENGTH()函数用法详解与实例分析》MySQLLENGTH()函数用于计算字符串的字节长度,区别于CHAR_LENGTH()的字符长度,适用于多字节字符集(如UTF-8)的数据验证... 目录1. LENGTH()函数的基本语法2. LENGTH()函数的返回值2.1 示例1:计算字符串

Linux在线解压jar包的实现方式

《Linux在线解压jar包的实现方式》:本文主要介绍Linux在线解压jar包的实现方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录linux在线解压jar包解压 jar包的步骤总结Linux在线解压jar包在 Centos 中解压 jar 包可以使用 u