mysql 5.5 修改 root 密码

发表于2019-05-28|更新于2026-05-03|mysql

启动数据库

1	mysqld --skip-grant-tables

更新密码

1 2	use mysql; UPDATE user SET Password=PASSWORD('root') where USER='root';

文章作者: developer

文章链接: http://example.com/2019/05/28/mysql%205.5%20%E4%BF%AE%E6%94%B9%20root%20%E5%AF%86%E7%A0%81/

版权声明: 本博客所有文章除特别声明外，均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来源 Dev！

mysql 密码修改 5.5 root

相关推荐

mysql_fetch_array

mysql_fetch_array从mysql_query的执行结果中取出一行结果放在2个数组中， MYSQL_ASSOC - 关联数组（键名和键值）MYSQL_NUM - 数字数组MYSQL_BOTH - 默认。同时产生关联和数字数组

mysql 找出重复数据

1SELECT * , count(openid) as count FROM `cul_logindata` GROUP BY `openid` HAVING count>1

mysql 统计重复记录数量

123456SELECT COUNT(*) as total FROM ( SELECT count(openid) as t FROM user GROUP BY `openid` HAVING t > 1 limit 1000) as a 如果下面写法会很慢 123456SELECT COUNT(*) as total FROM form_user WHERE id IN( SELECT count(id) FROM form_user GROUP BY `openid` HAVING COUNT(openid) > 1 limit 1000)

mysql 数据库升级

本机把mysql5.5升级到mysql8.0记录备份数据在mysql5.5执行mysqldump 1mysqldump -u root -pPASSWORD --all-databases > ./all.sql 停止mysql5 安装mysql8,导入数据 12mysql -uroot -p rootsource ./all.sql 启动mysql8 升级不兼容表 1mysql_upgrade -u root -p

mysql 优化方向

https://segmentfault.com/a/1190000018705500 优化工具 mysql show命令 show [SESSION | GLOBAL] variables; 查看数据库参数信息 show [SESSION | GLOBAL] status; SHOW ENGINE INNODB STATUS; Innodb引擎的所有状态 SHOW PROCESSLIST; 查看当前所有连接session状态 show index：查看表的索引信息 explain：获取查询语句的执行计划 slow-log：记录慢查询语句,配置文件打开 mysqldumpslow mysql慢查询日志分析工具详细介绍突然卡顿解决步骤 show processlist； explain select id ,name from stu where name=’clsn’; #意思问题sql show index from table; #分析索引通过执行计划判断，索引问题（有没有、合不合理）或者语句本身问题； show status like ‘%lock%’; ...

创建数据库1CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci; 创建用户1create user 'user'@'%' identified by '123'; 授权用户1grant all privileges on db.* to 'user'@'%'; 查看用户1show grants for 'user'@'%'; 修改密码123use mysql; update user set password=password('123') where user='root' and host='localhost'; flush privileges; mysql8密码问题1ALTER USER 'native'@&...

数据加载中