重置系统(非必须)
- 停止系统
搭建环境
- JDK
https://www.oracle.com/technetwork/java/javase/downloads/jdk13-downloads-5672538.html
- Tomcat
https://tomcat.apache.org/download-90.cgi
- Mysql
https://dev.mysql.com/downloads/repo/yum/
这里是repo源,通过centos自带的yum安装
- redis
安装JDK
rpm -ivh jdk-13.0.2_linux-x64_bin.rpm
安装Mysql
- 安装用来配置mysql的yum源的rpm包
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
- 安装mysql
yum install mysql-community-server
- 开启mysql服务
service mysqld start
mysql安装成功后创建的超级用户“root@localhost”的密码会被存储仔/var/log/mysqld.log中,可以使用如下命令查看密码
grep 'temporary password' /var/log/mysqld.log
使用root用户和临时密码登录数据库,用如下命令修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
问题1: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
解决:密码输错了
问题2: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决:ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; 注意单引号
问题3: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
密码由8位组成,必须包括大小写字母,数字,特殊字符,如’NRd94**’
SHOW VARIABLES LIKE ‘validate_password%’;
set global validate_password.policy=LOW;
set global validate_password.length=8;不能少于6
set global validate_password.mixed_case_count=4;
set global validate_password.number_count=0;
set global validate_password.special_char_count=0;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootroot';
- 开启远程连接
通过阿里云控制台开放3306端口
- 配置一个支持远程登录的账号
GRANT SELECT, UPDATE, INSERT, DELETE ON *.* TO 'work'@'%' identified by 'rootroot';
问题1: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'rootroot''
原因:新版的mysql将创建账户和赋予权限的方式分开了
解决:
创建账户:create user ‘work’@’%’ identified by ‘rootroot’;
赋予权限: GRANT SELECT, UPDATE, INSERT, DELETE ON *.* TO 'work'@'%';
grant all privileges on *.* to root@"xxx.xxx.xxx.xxx" identified by "密码";
flush privileges;
本地登录: mysql -uwork -P3306 -h 123.57.75.143 –p
update user set host='%' where user = 'root';
问题1:SQLyog连接mysql8.0时报错:错误号码2058
解决: ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码.';
安装redis
tar -zxvf redis-5.0.7.tar.gz
vim redis-5.0.7/redis.conf
安装:
启动redis服务:
src/redis-server redis.conf
连接测试:
安装tomcat
tar -zxvf apache-tomcat-9.0.30.tar.gz
启动:
./apache-tomcat-9.0.30/bin/startup.sh
发布项目
vi apache-tomcat-9.0.30/conf/server.xml
重启:
./apache-tomcat-9.0.30/bin/shutdown.sh
./apache-tomcat-9.0.30/bin/startup.sh
Mysql常用命令
- 查看端口号:
show global variables like 'port';
问题1:tomcat启动,访问不了首页
解决:
linux常用命令
- 删除文件rm -rf apache-tomcat-9.0.30