qq_42339350的博客

进入目录cd /etc备份cp my.cnf my.cnf.bak在[mysqld]下加一行重启mysqlsystemctl restart mysqld查看mysql运行状态systemctl status mysqld进入数据库后，查看端口号show variables like 'port';其他服务器防火墙端口号记得放开...

检查是否已安装过查看该操作系统上是否已经安装了mysql数据库。返回空则代表没有rpm -qa | grep mysql　如果有则删除（百度下）开始安装// 配置扩展源rpm -ivh http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64/mysql80-community-release-el7-6.noarch.rpm// 安装yum install mysql-community-server -y --nogpgchec

查看安装的mysqlrpm -qa|grep mysql卸载yum remove mysql mysql-server mysql-libs mysql-server查询剩余文件rpm -qa|grep mysql删除剩余文件 rpm -ev mysql-community-common-5.7.36-1.el7.x86_64rpm -ev mysql57-community-release-el7-10.noarch...

数据库连接url加参数xml 配置文件中<property name="url" value="jdbc:mysql://localhost:3306/user_db?useUnicode=true&amp;characterEncoding=utf8" />普通String字符串jdbc:mysql://localhost:3306/user_db?useUnicode=true&characterEncoding=utf8...

1 控制台进入数据库2输入下方两句ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';FLUSH PRIVILEGES;然后问题解决

方法1在mysql下的bin目录 输入无密码mysql -u root -r有密码mysql -u root -p方法2配置系统path环境变量，然后在任意目录都能用上面命令进入数据库效果