目录
(4) (WebStorm软件对格式要求很严,敲完代码后Ctrl+Alt+L加手动)
(9) import java.util.Date; 中Date报错
(1) 安装mysql Install/Remove of the Service Denied!错误的解决办法
(2) ERROR 1044 (42000): Access denied for user 'root'@'localhost'
1、 IDEA
(1) 数据库用户与密码错误
Access denied for user 'root'@'localhost' (using password:YES)
意思就是不能访问数据库
(2) 端口被占用
(3) 依赖爆红:
解决办法:复制改插件,粘贴一下
(4) (WebStorm软件对格式要求很严,敲完代码后Ctrl+Alt+L加手动)
(5) 属性报错:
解决:
(6) 对象报错:
EstateService**.java(房地产服务)**
解决:
EstateService**.java(房地产服务)**
EstateController**.java(房地产控制器)**
添加:
(7) 定义类的时候未加东西:![](https://img-blog.csdnimg.cn/1df8adec9cde4bcb86f0648ffdafb352.png)
方式一:只在调试类下加一个即可
方式二:每个类都加包括下图的类
Unsatisfied dependency expressed through field 'baseMapper'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.mashibing.mapper.FcBuildingMapper' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
(8) 关于选择栏
(只有两个选项栏**)**
========================================================
改成:
(四个选项栏)
WebStorm**软件中:**
(9) import java.util.Date; 中Date报错
解决办法:重新装jdk1.8,
重装方式:
2、 MySQL
(1) 安装
检测是否安装:
如mysql -V(V要大写)
(1) 安装mysql Install/Remove of the Service Denied!错误的解决办法
报错:
Install/Remove of the Service Denied
解决办法:
打开cmd.exe程序的时候选择“用管理员身份打开”
(2) MySQL5.7配置
方式一
https://www.jianshu.com/p/18762ddb6060
1. 安装
`#1. ``检查mariadb包```
`rpm -qa|grep mariadb ```
`#2. #``将检查到mariadb卸载```
`rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64 ```
`#3. ``授权```
`chmod -R 777 /tmp```
`#4. ``安装,注意安装顺序```
`rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm ```
`rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm ```
`rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm ```
`rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm```
`#``安装server报Failed dependencies:libnuma.so......,则安装numactl```
`yum install -y numactl```
2. 初始化与修改密码
`#1. ``初始化```
`mysqld --initialize --user=mysql```
`#2. ``启动服务```
`systemctl start mysqld.service```
`#3. ``查看初始化密码,一共12位```
`grep 'temporary password' /var/log/mysqld.log```
`#4. ``登陆```
`mysql -uroot -p```
`#5. ``修改密码```
`ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';```
3. 授予**MySQL远程连接**
`#1. ``授权```
`grant all privileges on . to root@'%' identified by 'root'; ```
`#2. ``刷新权限```
`flush privileges;```
4. 关闭防火墙
`# ``本次关闭```
`systemctl stop firewalld.service```
`# ``永久关闭```
`systemctl disable firewalld.service```
5. 卸载
`#1. ``检查```
`rpm -qa|grep -i mysql```
`#2. ``关闭服务```
`systemctl stop mysqld.service```
`#3. ``卸载,注意顺序```
`rpm -ev --nodeps mysql-community-client-5.7.29-1.el7.x86_64```
`rpm -ev --nodeps mysql-community-server-5.7.29-1.el7.x86_64```
`rpm -ev --nodeps mysql-community-common-5.7.29-1.el7.x86_64```
`rpm -ev --nodeps mysql-community-libs-5.7.29-1.el7.x86_64```
`#4. ``查找目录```
`find / -name mysql```
`#5. ``删除查到的目录```
`rm -rf ...```
`#6. ``再次检查确认```
rpm -qa|grep -i mysql
方式二:(暴力删除)
参考以下两个链接:
MySQL 学习(一)—— MySQL 5.7的完全卸载、安装、问题总结_向风来的博客-CSDN博客_mysql5.7完全卸载