当前位置:网站首页>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
边栏推荐
猜你喜欢
趣谈网络协议
低频量化之明日涨停预测
Oracle alarm log alert Chinese trace and trace files
Pytorch 经典卷积神经网络 LeNet
UML Unified Modeling Language
Leetcode brush question 𞓜 13 Roman numeral to integer
Wechat applet
Using Baidu Intelligent Cloud face detection interface to achieve photo quality detection
【报名】TF54:工程师成长地图与卓越研发组织打造
大专的我,闭关苦学 56 天,含泪拿下阿里 offer,五轮面试,六个小时灵魂拷问
随机推荐
SQL learning | complex query
MySQL [SQL performance analysis + SQL tuning]
freeCodeCamp----arithmetic_ Arranger exercise
_模_板_
初识go语言
多线程 @Async 线程池
Decimal 格式化小数位/DateTime 转换处理
Reading notes: meta matrix factorization for federated rating predictions
Spark入门基本操作
Question bank and answer analysis of the 2022 simulated examination of the latest eight members of Jiangxi construction (quality control)
商家案例 | 运动健康APP用户促活怎么做?做好这几点足矣
Reading notes: fedgnn: Federated graph neural network for privacy preserving recommendation
AtomicIntegerArray源码分析与感悟
freeCodeCamp----time_ Calculator exercise
Android篇:2019初中级Android开发社招面试解答(中
[VMware] address of VMware Tools
快捷键(多行)
Android: answers to the recruitment and interview of intermediate Android Development Agency in early 2019 (medium)
JS 力扣刷题 102. 二叉树的层序遍历
金蝶云星空API调用实践