• ⚡软件安装

  • ⚡mysql

    sudo apt-get update
    # 直接装老版本5.7
    sudo apt-get install mysql-server

    • 修改root用户密码

      在debain系的Linux下，mysql是有默认的debian-sys-maint用户的

      其密码在/etc/mysql/debain.cnf下

      mysql -udebian-sys-maint -ppassword

      use mysql;
      
      update user set authentication_string=password('root') where user='root' and Host='localhost';
      
      update user set plugin="mysql_native_password";
              
      flush privileges;
      
      quit;

    • 创建用户，授予权限

      # 创建用户
      create user 'guest' identified by '密码';
      
      # 授予databaseName数据库的所有权限
      grants all privileges on databaseName.* to 'guest'@'%' with grant option;
      
      flush privileges;
      
      # 或者授予mysql所有权限
      grants all privileges on *.* to 'guest'@'%' with grant option;
      
      # 查看权限
      show grants for guest;

    • 开启远程连接

      cd /etc/mysql/mysql.conf.d/
      
      sudo vim mysqld.cnf

      # 把下面这行注释掉
      bind-address = 127.0.0.1

      # 重启
      sudo systemctl restart mysql

  • JDK8(Oracle)

    网上ppa源的办法已失效，只能手动去官网下载jdk8的tar.gz包

    1. 在本地下载好scp传到服务器

    2. 在服务器端解压