当前位置：网站首页>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
边栏推荐
- Multithreading
- Analysis and understanding of atomicintegerarray source code
- [code analysis (4)] communication efficient learning of deep networks from decentralized data
- 【报名】TF54：工程师成长地图与卓越研发组织打造
- Chapter 15 new technologies of software engineering
- STM32 learning record 0007 - new project (based on register version)
- 【vmware】vmware tools 地址
- Basic knowledge learning record
- Decentralized Collaborative Learning Framework for Next POI Recommendation
- Crontab timing task output generates a large number of mail and runs out of file system inode problem processing
猜你喜欢
![[VMware] address of VMware Tools](/img/0e/13f263bd69c8224f7c755258d94777.png)
随机推荐
Leetcode? The first common node of two linked lists
Analysis and understanding of atomicintegerarray source code
大专的我，闭关苦学 56 天，含泪拿下阿里 offer，五轮面试，六个小时灵魂拷问
联想产品经理林林：天津当地网络运营商网络故障 ZUI系统后台服务器暂时无法正常工作
Quartus prime hardware experimental development (de2-115 board) experiment II function adjustable comprehensive timer design
金蝶云星空API调用实践
Problems encountered in the project (V) understanding of operating excel interface poi
Nacos+AspnetCore+Ocelot实战编码
趣谈网络协议
[code analysis (3)] communication efficient learning of deep networks from decentralized data
Special test 05 · double integral [Li Yanfang's whole class]
Small case of web login (including verification code login)
leetcode--977. Squares of a Sorted Array
JS force deduction brush question 103 Zigzag sequence traversal of binary tree
Chapter 15 new technologies of software engineering
Express②(路由)
[code analysis (5)] communication efficient learning of deep networks from decentralized data
Tensorflow & pytorch common error reporting
Neuron and neural network
Reading notes: fedgnn: Federated graph neural network for privacy preserving recommendation