Setting, Changing And Resetting MySQL Root Passwords
来源:互联网 发布:linux用户权限同组 编辑:程序博客网 时间:2024/05/21 20:38
mysqladmin Command To Change Root Password
Method 1 - Set up root password for the first time
If you have never set a root password for MySQL, the server does notrequire a password at all for connecting as root. To set up a rootpassword for the first time, use the mysqladmin command at the shell prompt asfollows:
$ mysqladmin -u root password newpass
If you want to change (or update) a root password, then you need to use the following command:
$ mysqladmin -u root -p oldpassword newpass
Enter password:
If you get...
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
then follow the instructions below on how to recover your MySQL password.
Change MySQL password for other users
To change a normal user password you need to type:
$ mysqladmin -u user-name -p oldpassword newpass
Method 2 - Update or change password
MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords:
1) Login to the MySQL server, type the following command at the shell prompt:
$ mysql -u root -p
2) Use the mysql database (type commands at the mysql> prompt):
mysql> use mysql;
3) Change password for a user:
mysql> update user set password=PASSWORD("newpass") where User='ENTER-USER-NAME-HERE';
4) Reload privileges:
mysql> flush privileges;
mysql> quit
This method you need to use while using PHP or Perl scripting.
Recover MySQL root password
You can recover a MySQL database server password with the following five easy steps:
Step # 1: Stop the MySQL server process.
Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for a password.
Step # 3: Connect to the MySQL server as the root user.
Step # 4: Set a new root password.
Step # 5: Exit and restart the MySQL server.
Here are the commands you need to type for each step (log in as the root user):
Step # 1 : Stop the MySQL service:
# /etc/init.d/mysql stop
Output:
Stopping MySQL database server: mysqld.
Step # 2: Start the MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Output:
[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started
Step # 3: Connect to the MySQL server using the MySQL client:
# mysql -u root
Output:
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql>
Step # 4: Set a new MySQL root user password:
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
Step # 5: Stop the MySQL server:
# /etc/init.d/mysql stop
Output:
Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6186]: ended
[1]+ Done mysqld_safe --skip-grant-tables
Start the MySQL server and test it:
# /etc/init.d/mysql start
# mysql -u root -p
- Setting, Changing And Resetting MySQL Root Passwords
- Resetting a forgotten MySql root password
- Security Tutorials系列文章第十三章:Recovering and Changing Passwords
- FNDCPASS Troubleshooting Guide For Login and Changing Applications Passwords
- Changing the root password on MySQL
- Resetting the Root Password: Unix Systems
- Misha and Changing Handles
- Misha and Changing Handles
- Misha and Changing Handles
- Misha and Changing Handles
- Changing machine name by setting registry
- Passwords
- Perfect Passwords : Selection, Protection and Authentication
- How To Choose and Use Strong Passwords
- ZIP and UNZIP with Passwords in Java
- B. Roma and Changing Signs
- B - Misha and Changing Handles
- B. Misha and Changing Handles
- DHC log 2009-1-17
- CXF全接触(一) --- WS-Security的实现
- C#异步方法调用
- 23岁以上的那女生们都来看看!(转载自网络)
- WCF - IsInitiating & IsTerminating
- Setting, Changing And Resetting MySQL Root Passwords
- spring_security-安全框架
- Java画图程序设计
- 世界顶级精英们的人生哲学!
- 与GIS相关的SCI、EI期刊
- df du mpstat
- WCF - IDisposable
- wireshark开发手册
- asp.net输出rss