新服务器配置

  • 安装 mysql
sudo apt install mysql-server
  • 安装 nginx
sudo apt install nginx
  • 安装 openjdk
sudo apt-get install openjdk-8-jdk
  • 安装 php、php-fpm、php-mysql
sudo apt-get install php
sudo apt-get install php-fpm
sudo apt-get install php-mysql
  • 验证mysql 运行情况
sudo systemctl status mysql
  • 首次以 root 身份登录
sudo mysql
  • 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

创建数据库并设定字符集

CREATE DATABASE database_name
  CHARACTER SET utf8
  COLLATE utf8_general_ci;

另外再创建一个用户并授予所有权限

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';

停止服务

sudo service mysql stop

重启服务

sudo service mysql restart
sudo service nginx restart