Linux - Reset a MySQL root password
2024-04-07 17:24:35
Use the following steps to reset a MySQL root password by using the command line interface.
Stop the MySQL service
(Ubuntu and Debian) Run the following command:
sudo /etc/init.d/mysql stop
(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command:
sudo /etc/init.d/mysqld stop
Start MySQL without a password
Run the following command. The ampersand (&) at the end of the command is required.
sudo mysqld_safe --skip-grant-tables &
Connect to MySQL
Run the following command:
mysql -uroot
Set a new MySQL root password
Run the following command:
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit
Stop and start the MySQL service
(Ubuntu and Debian) Run the following commands:
sudo /etc/init.d/mysql stop
...
sudo /etc/init.d/mysql start
(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands:
sudo /etc/init.d/mysqld stop
...
sudo /etc/init.d/mysqld start
Log in to the database
Test the new password by logging in to the database.
mysql -u root -p
You are prompted for your new password.
最新文章
- java并发编程（十八）阻塞队列和阻塞栈
- animate动画jquery
- 2016 ACM/ICPC Asia Regional Dalian Online
- jvm的client和server
- 3D 转换
- 框架技术--Spring自动加载配置
- JAVA编程相关:eclipse如何导入已有工程
- UVA 1513 - Movie collection(树状数组)
- 开发团队在TFS中使用Git Repository （一）
- Linux中kettle自动化部署脚本
- java集合（3）- Java中的equals和hashCode方法详解
- pku 1401 Factorial 算数基本定理 && 51nod 1003 阶乘后面0的数量
- 分布式文件系统FastDFS如何做到高可用
- 验证码的设计与记住我存储用户名密码cookie的技术及单选按钮选择登录人身份的实现
- c# 多线程简化
- proxyServer Squid 3.5.5 / 20181111
- css selector 用法
- PTA 7-1 整数分解为若干项之和（20 分）
- android.net.Uri 简介 API
- [教程]Ubuntu下完整配置自动壁纸切换