当前位置：网站首页>linux安装mysql后修改密码
linux安装mysql后修改密码
2022-04-23 14:00:00 【白云碎里一蓑舟】
1. 修改my.cnf文件
添加skip-grant-tables #修改密码
2. 重启并修改密码
#重启mysql
systemctl restart mysql_slave.service
#进入mysql
mysql -S /data/mysql_storage/mysql.sock
#修改密码
update mysql.user set authentication_string=password('12349') where user='root';
#刷新权限
flush privileges;
#退出
exit
3. 在my.cnf文件删掉skip-grant-tables，并重启mysql
结束啦~
版权声明
本文为[白云碎里一蓑舟]所创，转载请带上原文链接，感谢
https://blog.csdn.net/m0_49513507/article/details/123549126
边栏推荐
猜你喜欢
Reading notes: meta matrix factorization for federated rating predictions
Android 面试主题集合整理
Universal template for scikit learn model construction
JS 烧脑面试题大赏
Jenkins construction and use
2021年秋招，薪资排行NO
【报名】TF54：工程师成长地图与卓越研发组织打造
Program compilation and debugging learning record
crontab定时任务输出产生大量邮件耗尽文件系统inode问题处理
cnpm的诡异bug
随机推荐
Taobao released the baby prompt "your consumer protection deposit is insufficient, and the expiration protection has been started"
JS brain burning interview question reward
1256：献给阿尔吉侬的花束
BUG_me
生成随机高质量符合高斯分布的随机数
MySQL [acid + isolation level + redo log + undo log]
剑南春把文字游戏玩明白了
About note 1
Es introduction learning notes
Basic SQL query and learning
Multithreading
Program compilation and debugging learning record
How does redis solve the problems of cache avalanche, cache breakdown and cache penetration
UNIX final exam summary -- for direct Department
Android: answers to the recruitment and interview of intermediate Android Development Agency in early 2019 (medium)
JS 力扣刷题 103. 二叉树的锯齿形层序遍历
What is the difference between blue-green publishing, rolling publishing and gray publishing?
Neuron and neural network
freeCodeCamp----arithmetic_ Arranger exercise
AtomicIntegerArray源码分析与感悟