腾讯云centos7安装mysql5.7

news/2024/4/24 18:07:08/文章来源:https://blog.csdn.net/weixin_52605156/article/details/127627132

昨天服务器上的数据库被勒索了,重装系统之后不得不再装一次数据库,踩了很多坑,在此记录安装过程。

  • 首先把centos7自带的数据库mariadb卸载掉,把MySQL的相关文件夹都删掉。

查看组件服务

rpm -qa | grep -i mariadb
rpm -qa | grep -i mysql

查看相关文件夹

find / -name mysql
find / -name mariadb

组件服务删除

rpm -ev --nodeps 组键服务名

文件删除

rm -rf 文件名

演示如下

[root@VM-16-13-centos ~]# rpm -qa | grep -i mariadb
mariadb-libs-5.5.68-1.el7.x86_64[root@VM-16-13-centos ~]# rpm -qa | grep -i mysql
​ ‌‍‍‏​‌‏[root@VM-16-13-centos ~]# find / -name mysql
/etc/selinux/targeted/active/modules/100/mysql
/usr/share/mysql
/usr/lib64/mysql
find: ‘/proc/7206’: No such file or directory[root@VM-16-13-centos ~]# find / -name mariadb
​ ‌‍‍‏​‌‍[root@VM-16-13-centos ~]# rpm -ev --nodeps  ‌‍‍‏mariadb-libs-5.5.68-1.el7.x86_6
error: package ‌‍‍‏mariadb-libs-5.5.68-1.el7.x86_6 is not installed[root@VM-16-13-centos ~]# rm -rf  ‌‍‍‏/etc/selinux/targeted/active/modules/100/mysql
​ ‌‍‍‏​‌‍[root@VM-16-13-centos ~]# rm -rf /usr/share/mysql
​ ‌‍‍‏​‌‍[root@VM-16-13-centos ~]# rm -rf /usr/lib64/mysql
  • 在home文件夹下新建一个data文件夹

演示如下

[root@VM-16-13-centos ~]# cd /home/
​ ‌‍‍‏​‌‍[root@VM-16-13-centos home]# mkdir data
​ ‌‍‍‏​‌‍[root@VM-16-13-centos home]# ls
data  lighthouse[root@VM-16-13-centos home]# cd data
  • 下载 MySQL的yum包,这里我先下载的wget,如果你存在的话就不用安装它,直接使用下面的语句即可:
wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm

如果不存在,请先安装wget:

yum -y install wget

演示如下

[root@VM-16-13-centos data]# yum -y install wget
Loaded plugins: fastestmirror, langpacks
Determining fastest mirrors
epel                                                                                                                                   | 4.7 kB  00:00:00     
extras                                                                                                                                 | 2.9 kB  00:00:00     
os                                                                                                                                     | 3.6 kB  00:00:00     
updates                                                                                                                                | 2.9 kB  00:00:00     
Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version
Nothing to do[root@VM-16-13-centos data]# wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
--2022-10-31 23:05:38--  http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 184.30.152.230
Connecting to repo.mysql.com (repo.mysql.com)|184.30.152.230|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25548 (25K) [application/x-redhat-package-manager]
Saving to: ‘mysql57-community-release-el7-10.noarch.rpm’100%[====================================================================================================================>] 25,548       135KB/s   in 0.2s   2022-10-31 23:05:39 (135 KB/s) - ‘mysql57-community-release-el7-10.noarch.rpm’ saved [25548/25548]
  • 然后安装MySQL源
rpm -Uvh mysql57-community-release-el7-10.noarch.rpm

演示如下

[root@VM-16-13-centos data]# rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
warning: mysql57-community-release-el7-10.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql57-community-release-el7-10 ################################# [100%]
  • 安装mysql的服务
yum install -y mysql-community-server

演示如下

[root@VM-16-13-centos data]# yum install -y mysql-community-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
mysql-connectors-community                                                                                                             | 2.6 kB  00:00:00     
mysql-tools-community                                                                                                                  | 2.6 kB  00:00:00     
mysql57-community                                                                                                                      | 2.6 kB  00:00:00     
(1/3): mysql-connectors-community/x86_64/primary_db                                                                                    |  93 kB  00:00:00     
(2/3): mysql-tools-community/x86_64/primary_db                                                                                         |  89 kB  00:00:01     
(3/3): mysql57-community/x86_64/primary_db                                                                                             | 325 kB  00:00:01     
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.40-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.40-1.el7 for package: mysql-community-server-5.7.40-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.40-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.40-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.40-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.40-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.40-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.40-1.el7 will be obsoleting
--> Finished Dependency ResolutionDependencies Resolved==============================================================================================================================================================Package                                          Arch                        Version                            Repository                              Size
==============================================================================================================================================================
Installing:mysql-community-libs                             x86_64                      5.7.40-1.el7                       mysql57-community                      2.6 Mreplacing  mariadb-libs.x86_64 1:5.5.68-1.el7mysql-community-libs-compat                      x86_64                      5.7.40-1.el7                       mysql57-community                      1.2 Mreplacing  mariadb-libs.x86_64 1:5.5.68-1.el7mysql-community-server                           x86_64                      5.7.40-1.el7                       mysql57-community                      178 M
Installing for dependencies:mysql-community-client                           x86_64                      5.7.40-1.el7                       mysql57-community                       28 Mmysql-community-common                           x86_64                      5.7.40-1.el7                       mysql57-community                      311 kTransaction Summary
==============================================================================================================================================================
Install  3 Packages (+2 Dependent packages)Total download size: 211 M
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.40-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Public key for mysql-community-common-5.7.40-1.el7.x86_64.rpm is not installed
(1/5): mysql-community-common-5.7.40-1.el7.x86_64.rpm                                                                                  | 311 kB  00:00:01     
(2/5): mysql-community-libs-5.7.40-1.el7.x86_64.rpm                                                                                    | 2.6 MB  00:00:02     
(3/5): mysql-community-libs-compat-5.7.40-1.el7.x86_64.rpm                                                                             | 1.2 MB  00:00:00     
(4/5): mysql-community-client-5.7.40-1.el7.x86_64.rpm                                                                                  |  28 MB  00:00:12     
(5/5): mysql-community-server-5.7.40-1.el7.x86_64.rpm                                                                                  | 178 MB  00:00:55     
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                         3.5 MB/s | 211 MB  00:01:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5Package    : mysql57-community-release-el7-10.noarch (installed)From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysqlPublic key for mysql-community-client-5.7.40-1.el7.x86_64.rpm is not installedFailing package is: mysql-community-client-5.7.40-1.el7.x86_64GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

然后我们发现有一个bug,就是:

Public key for mysql-community-client-5.7.40-1.el7.x86_64.rpm is not installed

解决方法:

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

然后继续安装mysql的服务:

yum install mysql-server

演示过程

[root@VM-16-13-centos data]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
​ ‌‍‍‏​‌‍[root@VM-16-13-centos data]# yum install mysql-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.40-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.40-1.el7 for package: mysql-community-server-5.7.40-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.40-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.40-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.40-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.40-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.40-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.40-1.el7 will be obsoleting
--> Finished Dependency ResolutionDependencies Resolved==============================================================================================================================================================Package                                          Arch                        Version                            Repository                              Size
==============================================================================================================================================================
Installing:mysql-community-libs                             x86_64                      5.7.40-1.el7                       mysql57-community                      2.6 Mreplacing  mariadb-libs.x86_64 1:5.5.68-1.el7mysql-community-libs-compat                      x86_64                      5.7.40-1.el7                       mysql57-community                      1.2 Mreplacing  mariadb-libs.x86_64 1:5.5.68-1.el7mysql-community-server                           x86_64                      5.7.40-1.el7                       mysql57-community                      178 M
Installing for dependencies:mysql-community-client                           x86_64                      5.7.40-1.el7                       mysql57-community                       28 Mmysql-community-common                           x86_64                      5.7.40-1.el7                       mysql57-community                      311 kTransaction Summary
==============================================================================================================================================================
Install  3 Packages (+2 Dependent packages)Total size: 211 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.Installing : mysql-community-common-5.7.40-1.el7.x86_64                                                                                                 1/6 Installing : mysql-community-libs-5.7.40-1.el7.x86_64                                                                                                   2/6 Installing : mysql-community-client-5.7.40-1.el7.x86_64                                                                                                 3/6 Installing : mysql-community-server-5.7.40-1.el7.x86_64                                                                                                 4/6 Installing : mysql-community-libs-compat-5.7.40-1.el7.x86_64                                                                                            5/6 Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                         6/6 
warning: file /usr/lib64/mysql/plugin/mysql_clear_password.so: remove failed: No such file or directory
warning: file /usr/lib64/mysql/plugin/dialog.so: remove failed: No such file or directory
warning: file /usr/lib64/mysql/libmysqlclient.so.18.0.0: remove failed: No such file or directoryVerifying  : mysql-community-client-5.7.40-1.el7.x86_64                                                                                                 1/6 Verifying  : mysql-community-server-5.7.40-1.el7.x86_64                                                                                                 2/6 Verifying  : mysql-community-common-5.7.40-1.el7.x86_64                                                                                                 3/6 Verifying  : mysql-community-libs-5.7.40-1.el7.x86_64                                                                                                   4/6 Verifying  : mysql-community-libs-compat-5.7.40-1.el7.x86_64                                                                                            5/6 Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                         6/6 Installed:mysql-community-libs.x86_64 0:5.7.40-1.el7       mysql-community-libs-compat.x86_64 0:5.7.40-1.el7       mysql-community-server.x86_64 0:5.7.40-1.el7      Dependency Installed:mysql-community-client.x86_64 0:5.7.40-1.el7                                  mysql-community-common.x86_64 0:5.7.40-1.el7                                 Replaced:mariadb-libs.x86_64 1:5.5.68-1.el7                                                                                                                          Complete!
  • 启动mysql服务
systemctl start mysqld.service
  • 查看mysql服务是否已经启动
systemctl status mysqld.service

演示过程

[root@VM-16-13-centos data]# systemctl start mysqld.service
​ ‌‍‍‏​‌‍[root@VM-16-13-centos data]# systemctl status mysqld.service
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: active (running) since Mon 2022-10-31 23:09:22 CST; 8s agoDocs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.htmlProcess: 320 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)Process: 32489 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)Main PID: 323 (mysqld)CGroup: /system.slice/mysqld.service└─323 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pidOct 31 23:09:17 VM-16-13-centos systemd[1]: Starting MySQL Server...
Oct 31 23:09:22 VM-16-13-centos systemd[1]: Started MySQL Server.
  • 查看生成的临时密码
grep 'temporary password' /var/log/mysqld.log 

演示过程
如下,&tbS5gCo5;Ka就是临时密码

[root@VM-16-13-centos data]# grep 'temporary password' /var/log/mysqld.log 
2022-10-31T15:09:18.499659Z 1 [Note] A temporary password is generated for root@localhost: &tbS5gCo5;Ka
  • 登录MySQL
mysql -uroot -p (临时密码)

然后这里出现了一个错误,也就是虽然输入了正确的密码,但是还是无法进入,提示如下:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决方法:
初期考虑是服务器的端口有问题,修改了端口后,还是不行,于是进行配置文件的修改:

vim /etc/my.cnf

编辑 /etc/my.cnf ,在[mysqld] 部分最后添加一行

skip-grant-tables  

保存后,重启mysql

service mysqld restart  

然后重新登陆mysql,此时就不需要密码就可以登录了

演示过程

[root@VM-16-13-centos data]# vim /etc/my.cnf
​ ‌‍‍‏​‌‍[root@VM-16-13-centos data]# service mysqld restart  
Redirecting to /bin/systemctl restart mysqld.service[root@VM-16-13-centos data]# mysql -uroot 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -AWelcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.40 MySQL Community Server (GPL)Copyright (c) 2000, 2022, Oracle and/or its affiliates.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.
  • 然后设置新的密码
set password for root@localhost = password('你的新密码');

然后此时出现了报错:

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

解决方法

flush privileges;
set password for root@localhost = password('你的新密码');
flush privileges;
vim /etc/my.cnf  #(把最后添加的代码注释掉:skip-grant-tables  )
service mysqld restart  

演示过程

mysql> set password for root@localhost = password('你的新密码');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> set password for root@localhost = password('你的新密码');
Query OK, 0 rows affected, 1 warning (0.01 sec)mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye[root@VM-16-13-centos data]# vim /etc/my.cnf
​ ‌‍‍‏​‌‍[root@VM-16-13-centos data]# service mysqld restart  
Redirecting to /bin/systemctl restart mysqld.service
  • 登录MySQL,成功登录
[root@VM-16-13-centos data]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.40 MySQL Community Server (GPL)Copyright (c) 2000, 2022, Oracle and/or its affiliates.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> exit
Bye
  • 使用navicat连接腾讯云上搭建的数据库

在我连接的时候,出现了报错,如下所示:
在这里插入图片描述

解决方法:
在终端登录到数据库之后,选择mysql数据库,具体操作如下:

mysql -u root -p
show databases;
use mysql
select Host, User,'你的新密码' from user;
update user set Host='%' where User='root';
flush privileges;
exit

演示过程

[root@VM-16-13-centos data]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.40 MySQL Community Server (GPL)Copyright (c) 2000, 2022, Oracle and/or its affiliates.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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changedmysql> select Host, User,'你的新密码' from user;
+-----------+---------------+----------------+
| Host      | User          | TUT!xlfdAPP666 |
+-----------+---------------+----------------+
| localhost | mysql.session | TUT!xlfdAPP666 |
| localhost | mysql.sys     | TUT!xlfdAPP666 |
| localhost | root          | TUT!xlfdAPP666 |
+-----------+---------------+----------------+
3 rows in set (0.00 sec)mysql> update user set Host='%' where User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye

此时再测试连接:
在这里插入图片描述
在这里插入图片描述

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.luyixian.cn/news_show_410275.aspx

如若内容造成侵权/违法违规/事实不符,请联系dt猫网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

Mybatics-连接配置

1、mysql连接数_MySQL配置参数优化 1.1、优化最大连接数max_connections 是MySQL最大并发连接数默认值是151 MySQL允许的最大连接数上限是32767 实际连接数是最大连接数的85%较为合适 查询数据库目前设置的最大并发连接数是多少 查询数据库目前实际连接的并发数是多少 在MyS…

SpringBoot集成JWT(极简版):

文章目录1.JWT依赖2.JWT工具类TokenUtils.java3.token示例4.拦截器JwtInterceptor.java5.拦截器设置InterceptorConfig.java6.统一接口WebConfig.java7.设置自定义头配置 CorsConfig .java8.GlobalExceptionHandler.java9.ServiceException.java10.设置token:11.最终效果&#…

离线下IDEA打开拷贝的完整工程,解决工程代码大量报错的问题

一、背景 在日常工作中&#xff0c;代码工程的保存和协作开发一般是通过代码仓库实现的。但是对于正常的多人研究开发时&#xff0c;工程代码的物理拷贝也是需要的&#xff0c;这可以节省工程代码依赖环境的安装和配置&#xff0c;同时也能保证代码完整和版本一致。 在大部分企…

【测试沉思录】9. 数据工厂低代码平台探索与实践

欢迎订阅我的新专栏《现代命令行工具指南》&#xff0c;精讲目前最流行的开源命令行工具&#xff0c;大大提升你的工作效率。 作者&#xff1a;吴锺瑞、刘洪初 编辑&#xff1a;毕小烦 一. 需求背景 造数据可能是日常迭代中最频繁也是最耗时的工作。 我们在20年8月对部门内的…

HashSet实现类的使用

【1】放入Integer类型数据package com.msb.test06;import java.util.HashSet;/*** @author : liu* 日期:10:36:57* 描述:IntelliJ IDEA* 版本:1.0*/ public class TestInteger {//这是一个main方法:是程序的入口public static void main(String[] args) {//创建一个HashSet集合…

Cannon.js -- 3d物理引擎

文章目录前言一、关于Cannon.js二、Cannon.js的使用最后注意点&#xff1a;优化事件其他本文完整代码下载&#xff1a;相关链接&#xff1a;前言 本篇将介绍Cannon.js -- 3d物理引擎的基础使用&#xff0c;并用Cannon.js与three.js写一个简单的demo 一、关于Cannon.js Q&…

什么是轮廓阴影和圆角

目录 outline box-shadow 将元素设置为一个圆形 outline outline 用来设置元素的轮廓线&#xff0c;用法和border一模一样 轮廓和边框不同的点&#xff0c;就是轮廓不会影响到可见框的大小 <!DOCTYPE html> <html lang"en"> <head><meta ch…

【CV】第 6 章:使用迁移学习的视觉搜索

&#x1f50e;大家好&#xff0c;我是Sonhhxg_柒&#xff0c;希望你看完之后&#xff0c;能对你有所帮助&#xff0c;不足请指正&#xff01;共同学习交流&#x1f50e; &#x1f4dd;个人主页&#xff0d;Sonhhxg_柒的博客_CSDN博客 &#x1f4c3; &#x1f381;欢迎各位→点赞…

Protocol Buffers学习【Qt】

文章目录参考前言开发环境# 一、下载1. 打开网页2. 点击download3. 下载二、 编译1. 解压2. 用QC打开项目3. 编译并等待4. 打开 extract_includes.bat5. 新建lib文件夹三、使用1. 新建 lm.helloworld.proto2. Qt 新建 HelloProtobuf 子目录项目3. lib_protobuf 目录4. Writer 工…

腾讯云创建SVN支持多人协同办公

本文参考自&#xff1a; 如何在腾讯云轻量级服务器搭建svn_我的天才女友的博客-CSDN博客_腾讯云 svn 搭建SVN服务器-腾讯云 - 夜页子 - 博客园 一、配置要求 选择腾讯云CentOS的镜像进行安装 二、SVN服务端 1.SVN服务端的安装 yum install subversion 接下来输入y按回车继…

C语言练习---【求素数】(一篇带你掌握素数求解)

&#x1f996;作者&#xff1a;学写代码的恐龙 &#x1f996;博客主页&#xff1a;学写代码的恐龙博客主页 &#x1f996;专栏&#xff1a;【初级c语言】 &#x1f996;语录&#xff1a;❀未来的你&#xff0c;一定会感谢现在努力奋斗的自己❀ C语言练习---【求素数】&#x1…

数据分析 | Pandas 200道练习题,每日10道题,学完必成大神(7)

文章目录前期准备1. 以df的列名创建一个DataFrame2. 打印所有换手率为非数字的行3. 删除所有换手率为非数字的行4. 重置df的行号5. 绘制‘还手’密度曲线6. 计算后一天和前一天收盘价的差值7. 计算后一天与前一天收盘价的变化率8. 设置时间索引9. 使用时间索引&#xff0c;分别…

JavaScript 49 JavaScript 作用域

JavaScript 文章目录JavaScript49 JavaScript 作用域49.1 JavaScript 函数作用域49.2 局部 JavaScript 变量49.3 全局 JavaScript 变量49.4 JavaScript 变量49.5 自动全局49.6 严格模式49.7 HTML 中的全局变量49.8 警告49.9 JavaScript 变量的有效期49.10 函数参数49 JavaScrip…

Mysql深度解析(一)索引底层数据结构与算法

MySQL底层索引是用B树实现的 传送门&#xff1a;什么是B-树、B树、B*树 传送门&#xff1a;深入理解MySQL索引底层数据结构与算法 传送门&#xff1a;MySQL中Innodb的索引 1 索引是什么? 索引&#xff1a;帮助Mysql高效获取数据的排好序的数据结构。 2 Mysql索引为什么用…

Sping的IoC容器和依赖注入

IoC Inversion of Control 使用对象时&#xff0c;由主动new产生对象转换为由外部提供对象&#xff0c;此过程中对象创建控制权由程序转移到外部&#xff0c;此思想称为控制反转 Spring实现了IoC的思想&#xff0c;Spring提供了一个容器&#xff0c;称为IoC容器&#xff0c;用…

【CSS】CSS选择器全解指南【CSS基础知识详解】

&#x1f468;‍&#x1f4bb;个人主页&#xff1a;花无缺 欢迎 点赞&#x1f44d; 收藏⭐ 留言&#x1f4dd; 加关注✅! 本文由 花无缺 原创 本文章收录于专栏 【CSS】 【CSS专栏】已发布文章 &#x1f4c1;【CSS基础认知】 本文目录【CSS选择器全解指南】&#x1f319;CSS注…

SpringBoot 转发请求至指定页面

1、前言 原先的页面访问地址为&#xff1a;http://127.0.0.1:8888/office/schdule/index/&#xff0c; 重构项目&#xff0c;SpringBoot 项目&#xff0c;前后分离&#xff0c;前端文件放置静态目录&#xff08;static&#xff09;下&#xff0c;访问地址&#xff1a;http://12…

计算机毕业设计(附源码)python疫情管理系统

项目运行 环境配置&#xff1a; Pychram社区版 python3.7.7 Mysql5.7 HBuilderXlist pipNavicat11Djangonodejs。 项目技术&#xff1a; django python Vue 等等组成&#xff0c;B/S模式 pychram管理等等。 环境需要 1.运行环境&#xff1a;最好是python3.7.7&#xff0c;…

URP下的OffScreen Particle Render

【博物纳新】专栏是UWA旨在为开发者推荐新颖、易用、有趣的开源项目,帮助大家在项目研发之余发现世界上的热门项目、前沿技术或者令人惊叹的视觉效果,并探索将其应用到自己项目的可行性。很多时候,我们并不知道自己想要什么,直到某一天我们遇到了它。随着越来越多的项目使用…