MySQL如何重設密碼 linux如何重設新密碼

MySQL如何重設root密碼 linux root帳號重設新密碼

1. 
   1.先將資料庫服務停用:
   
   
#/etc/init.d/mysql stop

   
   
2. 
   2.在「背景」模式執行 mysqld_safe, 並跳過權限檢查
   
   
#mysqld_safe --skip-grant-tables &

   
   
3. 
   3.以 root帳號登入，此時已經不會詢問密碼
   
   
mysql --user=root mysql

   
   
4. 
   4.更換 root密碼，new-pass即是新密碼
   
   
mysql> update user set Password=PASSWORD('new-pass') WHERE User='root';

   
   
5. 
   5.寫入權限 flush privileges
   
   
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

   

   忘了mysql的root密碼

Google secrets: Table of Contents: Become a Google guru with these effective tips, tricks, and techniques

Google secrets: Become a Google guru with these effective tips, tricks, and techniques

Google secrets: Table of Contents

Read This First

Part I Customizing Your Google Experience

Chapter 1 Starting Strong: Google Account and Profile Secrets

Chapter 2 Customizing Your Google Experience with iGoogle

Chapter 3 Increasing Your Knowledge with Google Reader

Part II Google Search Secrets

Chapter 4 Using Your Words: Natural Language Searches

Chapter 5 Refining Your Search

Chapter 6 Staying Close with Local Search

Chapter 7 Learning More with Informational Searches

Chapter 8 Using Multimedia Search to Find Entertainment

Chapter 9 Customizing Search to Your Needs

Part III Google Gmail Secrets

Chapter 10 Harnessing the Power of a Gmail Account

Chapter 11 Managing Messages

Part IV Secrets for Sharing Content with Google Applications

Chapter 12 Getting Your Message Out with Blogger

Chapter 13 Managing Your Blog

Chapter 14 Getting More from YouTube

Chapter 15 Getting the Picture with Picasa and Picnik

Part V Google Social and Collaboration App Secrets

Chapter 16 Google Talk Secrets

Chapter 17 Staying Connected with Google Voice

Chapter 18 Catching the Buzz: Google Buzz

Chapter 19 Socializing with Orkut

Chapter 20 Expanding Knowledge on the Web with Knol

Chapter 21 Getting Involved in Google Groups

Part VI Google Productivity Apps Secrets

Google secrets: Table of Contents: Become a Google guru with these effective tips, tricks, and techniques