qq_40572277的博客

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || test_db_tw...

1.下载地址：MySQL# wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm如果没有wget命令，则需要安装：yum -y install wget2.安装mysql8:# yum -y localinstall mysql80-community-release-el7-1.noarc...

修改root的连接限制，host=’%'为允许所有IP都有连接权限# mysql -u root -pEnter password:mysql> use mysql;mysql> select host from user where user='root';mysql>update user set host='%' where user='root';mysql&...

出现2003错误是因为Linux没有开放3306端口。# iptables -L -n //查看开放的端口# iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

# mysql -u root -pEnter password:mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';'password’为MySQL的登录密码。

在centos7安装MySQL后，/var/log/mysqld.log中没有生成临时密码# rm -rf /var/lib/mysqld# systemctl start mysqld# grep 'temporary password' /var/log/mysqld.log2019-01-07T10:38:33.469921Z 5 [Note] [MY-010454] [Server...

先关闭MySQL服务# systemctl stop mysqld进入my.cnf# vi /etc/my.cnf在[mysql] 下添加 skip-grant-table重启MySQL：# systemctl restart mysqld进入MySQL,修改密码# mysql -u root -pEnter password: //回车进入mysql>use m...

下载MySQL8复制链接[root@localhost /]# wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm[root@localhost /]# yum -y localinstall mysql80-community-release-el7-2.noarch.rpm[root@l...

以管理员身份运行cmd(mysql目录下的文件夹bin已加入到环境变量中);先关闭MySQL服务：net stop mysql;再执行：mysqld --console --skip-grant-tables --shared-memory不要关闭该界面，重新以管理员身份运行cmd;更改密码退出重启MySQL服务：net start mysql;...