杨校老师课堂之Java项目部署到云端服务器之安装MySQL、Jdk、Tomcat

港控/mmm° 2023-05-22 05:00 2阅读 0赞

##### 部署项目到公网上去思路剖析 #####

--------------------

· 公网服务器
    	· 数据库
    		·     下载、安装、配置、远程连接
       							   ·  使用本地的Navicat去远程连接 操作数据库 
    	· JDK	  安装Tomcat的前提 
    	· tomcat 
    		·目录结构
    			· webapps
    				 ·放入你的项目

--------------------

##### 拥有一台服务器，安装centos系统 #####

1.  Centos7.x

# 安装Centos的wget插件
       yum  install wget  -y
        # MySQL的选择网站:http://repo.mysql.com/ 网站有诸多版本，选择合适的下载即可。
        # 如下，我选择的是MySQL5.7
       wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm

#### 安装MySQL5.7 ####

sudo rpm -ivh mysql57-community-release-el7-10.noarch.rpm
    
    sudo yum install mysql-server

效果图如下：  
效果图如下：

###### 安装细节 ######

1.  安装MySQL过程中，如果是安装的`MySQL5.6`，安装后默认密码是**为空**的，可直接进入数据库的，  
    若是安装的是`Mysql5.7`就需要**初始密码**
2.  若不想查询初始密码，可以跳过MySQL权限验证操作，进入数据库进行修整密码，然后在打开权限验证即可。

# 方式一： 查询初始密码：
    mysql5.6安装后默认密码是为空的，可直接进入数据库的，但是mysql5.7就需要初始密码 
    2. cat /var/log/mysqld.log | grep password 查询MySQL5.7密码
    3.     [root@izb6rc3amsrxv6z local]# cat /var/log/mysqld.log | grep password
           # 初始化密码: soadrod;c9Pr
           2020-04-16T01:34:20.422336Z 1 [Note] A temporary password is generated for root@localhost: soadrod;c9Pr
           2020-04-16T01:52:45.445074Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T01:52:45.445078Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T01:52:54.766386Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
           2020-04-16T02:30:43.300676Z 0 [Note] Shutting down plugin 'validate_password'
           2020-04-16T02:30:44.813774Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T02:30:44.813777Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T02:42:29.107064Z 0 [Note] Shutting down plugin 'validate_password'
           2020-04-16T02:42:30.119448Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T02:42:30.119451Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T02:43:33.339551Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T02:43:33.339554Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T02:45:39.090209Z 0 [Note] Shutting down plugin 'validate_password'
           2020-04-16T02:45:40.607605Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T02:45:40.607608Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T02:49:08.842072Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T02:49:08.842075Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T02:49:25.046531Z 0 [Note] Shutting down plugin 'sha256_password'
           2020-04-16T02:49:25.046534Z 0 [Note] Shutting down plugin 'mysql_native_password'
           2020-04-16T02:53:45.817187Z 8 [Note] Access denied for user 'root'@'localhost' (using password: YES)
           2020-04-16T02:59:24.456338Z 14 [Note] Access denied for user 'root'@'223.96.218.217' (using password: YES)
           2020-04-16T02:59:26.824028Z 15 [Note] Access denied for user 'root'@'223.96.218.217' (using password: YES)
           [root@izb6rc3amsrxv6z local]# 
           
    4. 密码修改，代码如下
    mysql> alter user 'root'@'localhost' identified by 'Admin123..';
    ---------------------------------------------------------------
    # 方式二： 跳过权限验证
    [root@izb6rc3amsrxv6z /]# vi /etc/my.cnf
           # For advice on how to change settings please see
           # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
           
           [mysqld]
           #
           # Remove leading # and set to the amount of RAM for the most important data
           # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
           # innodb_buffer_pool_size = 128M
           #
           # Remove leading # to turn on a very important data integrity option: logging
           # changes to the binary log between backups.
           # log_bin
           #
           # Remove leading # to set options mainly useful for reporting servers.
           # The server defaults are faster for transactions and fast SELECTs.
           # Adjust sizes as needed, experiment to find the optimal values.
           # join_buffer_size = 128M
           # sort_buffer_size = 2M
           # read_rnd_buffer_size = 2M
           
           # 跳过MySQL的权限机制 就不需要输入密码 进去 更改密码 再将本命令删除 或 注释
           skip-grant-tables
           
           datadir=/var/lib/mysql
           socket=/var/lib/mysql/mysql.sock
           
           # Disabling symbolic-links is recommended to prevent assorted security risks
           symbolic-links=0
           
           log-error=/var/log/mysqld.log
           pid-file=/var/run/mysqld/mysqld.pid
           # 以下是在重启数据库
           # 尝试了老命令 发现不行 结果告诉我了一个新的命令“systemctl restart mysql.service”
           [root@izb6rc3amsrxv6z etc]# service mysql restart
               Redirecting to /bin/systemctl restart  mysql.service
               Failed to restart mysql.service: Unit not found.
           # 重启数据库的服务
           [root@izb6rc3amsrxv6z etc]# systemctl restart mysqld

# 1. 注意：在MySQL5.7版本又出现了不同的地方，即在mysql数据库中的user用户表中，没有password这个字段属性了，而是更改为了authentication_string
    # 2. 修改语句如下：（下方的sorry则是我的数据库密码）
    update mysql.user set authentication_string = password('sorry') where user = 'root';

--------------------

centOS7下找回mysql的密码 | 忘记密码,这么办？
         更改数据库密码步骤
          1. 配置文件[/etc/my.cnf] 设置 跳过密码验证
          2. 重启数据库服务
          3. 进入数据库之后？ 选中数据库  运行修改密码的语句  
          4. 退出 重启数据库

--------------------

关于MySQL 远程连接访问:
    
    1. 如果想把密码的要求设置的简单一些时，可以按照如下截图操作:
       	
    2. 赋予root用户可以接收任意主机(%)访问
        ` grant all privileges on *.* to 'root'@'%' identified by 'Admin123..';`
    3. 刷新权限 【单单赋予权限是不行的，一定要记得刷新操作】
           `flush privileges;`

#### 安装上传软件 ####

--------------------

[root@izb6rc3amsrxv6z /]# yum install lrzsz -y
        Loaded plugins: fastestmirror
        Loading mirror speeds from cached hostfile
        Resolving Dependencies
        --> Running transaction check
        ---> Package lrzsz.x86_64 0:0.12.20-36.el7 will be installed
        --> Finished Dependency Resolution
        
        Dependencies Resolved
        
        ============================================================================================
         Package                Arch                        Version                            Repository                                Size
        ======================================
        Installing:
         lrzsz                   x86_64                     0.12.20-36.el7                     base                                    78 k
        
        Transaction Summary
        ======================================
        Install  1 Package
        
        Total download size: 78 k
        Installed size: 181 k
        Downloading packages:
        lrzsz-0.12.20-36.el7.x86_64.rpm                                                                                                                                                           |  78 kB  00:00:00     
        Running transaction check
        Running transaction test
        Transaction test succeeded
        Running transaction
          Installing : lrzsz-0.12.20-36.el7.x86_64                                                                                                                                                                   1/1 
          Verifying  : lrzsz-0.12.20-36.el7.x86_64                                                                                                                                                                   1/1 
        
        Installed:
          lrzsz.x86_64 0:0.12.20-36.el7                                                                                                                                                                                  
        
        Complete!
        [root@izb6rc3amsrxv6z /]#

#### Jdk环境搭建 ####

[root@izb6rc3amsrxv6z /]# cd /www/develop/java
        [root@izb6rc3amsrxv6z java]# ls
        [root@izb6rc3amsrxv6z java]# rz -E
        rz waiting to receive.
        [root@izb6rc3amsrxv6z java]# ls
        jdk-8u211-linux-x64.tar.gz
        [root@izb6rc3amsrxv6z java]# tar -zxf jdk-8u211-linux-x64.tar.gz 
        [root@izb6rc3amsrxv6z java]# ls
        jdk1.8.0_211  jdk-8u211-linux-x64.tar.gz
        #配置jdk的环境变量 /etc/profile
        #在 /etc/profile内的最后加上以上内容，路径下写你自己设置的路径
        export JAVA_HOME=/www/develop/www/develop/java/jdk1.8.0_211
        export PATH=$JAVA_HOME/bin:$PATH
        #更新环境变量
        [root@izb6rc3amsrxv6z java]# source /etc/profile
        # 核查jdk是否安装成功 查看版本 查看javac有没有内容输出
        [root@izb6rc3amsrxv6z java]# java -version
        java version "1.8.0_211"
        Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
        Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)

--------------------

#### Tomcat的安装、配置 ####

[root@izb6rc3amsrxv6z /]# cd /www/develop/tomcat
        [root@izb6rc3amsrxv6z java]# ls
        [root@izb6rc3amsrxv6z java]# rz -E
        rz waiting to receive.
        [root@izb6rc3amsrxv6z java]# ls
        jdk-8u211-linux-x64.tar.gz
        [root@izb6rc3amsrxv6z java]# tar -zxf jdk-8u211-linux-x64.tar.gz 
        [root@izb6rc3amsrxv6z java]# ls
        jdk1.8.0_211  jdk-8u211-linux-x64.tar.gz
        #配置jdk的环境变量 /etc/profile
        #在 /etc/profile内的最后加上以上内容，路径下写你自己设置的路径
        export PATH=$/www/develop/www/develop/apache/apache-tomcat-8.5.40/bin:$PATH
        #更新环境变量
        [root@izb6rc3amsrxv6z /]# source /etc/profile
        #核查jdk是否安装成功 查看版本 查看javac有没有内容输出
        [root@izb6rc3amsrxv6z java]# catalina.sh start
        java version "1.8.0_211"
        Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
        Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)