5 個簡單的步驟讓您重置MySQL root權限的密碼


重置MySQL root密碼

MySQL的 root 密碼可允許root權限的使用者擁有對MySQL資料庫的完全控制的最高權限。

但是多年之後, 您也可能跟我一樣, 當初設置的密碼怎麼就是想不起來了。或者是MySQL server 出現了一些狀況而導致root 權限的密碼不在能夠使用了。那您就必須要使用以下的方式來重置MySQL root 權限的密碼了。

先要確定的是您必須具要有（Linux）shell或（Windows）管理員權限登入到MySQL的服務器的才能重置MySQL root密碼。

使用以下步驟使用命令行界面重置MySQL root密碼。

1. 停止MySQL服務

如果是用 MySQL server, 執行以下命令：

> sudo service mysql stop

如果是用 MariaDB server, 執行以下命令：

> sudo service mariadb stop

2. 連接到MySQL safe-mode

執行以下命令：

> sudo mysqld_safe --skip-grant-tables &
> mysql

3. 設置新的MySQL root密碼

執行以下命令：

> use mysql;

> update user set plugin='mysql_native_password' WHERE User='root';

> flush privileges;

> update mysql.user set password=PASSWORD('newpassword') where User='root';

> flush privileges;

> quit

4. 停止並啟動MySQL服務

> sudo mysqladmin -u root -p shutdown

 > sudo service mysql restart

or

> sudo service mariadb restart

5. 登錄數據庫

執行以下命令來測試登錄數據庫測試新密碼：

> mysql -u root -p

系統會提示您輸入新密碼。

如果一切都順利的話, 您就會沒問題的用root+password 登入進MySQL了。

還是會怕怕的嗎 ? 沒關係! 請隨時跟我們聯絡. 讓專業人士來協助您.
www.KonijnStudio.com

Comments

Post a Comment

Popular posts from this blog

What are the financial consequences of power outages for industrial facilities?

Image
  Power outages can have severe financial consequences for industrial facilities, some of which include: 1. Production Losses: One of the most significant financial consequences of power outages is production losses. When the power goes out, industrial processes are often disrupted, leading to missed deadlines and lost production. These losses can result in reduced productivity and lost revenue for the facility. Some industrial facilities may find it challenging to make up for lost production once power is restored, resulting in longer-term financial impacts. 2. Increased Costs: Power outages can increase the operating costs of industrial facilities. Facilities may need to purchase temporary generators or other equipment to restore power and maintain operations during the outage. These additional expenses can add up quickly, leading to increased production costs. 3. Equipment Damage: Power outages can also damage sensitive industrial equipment. When the power goes out and comes bac...
Read more

What are the major differences between RISC-V and traditional RISC CPUs?

Image
For those of you new to RISC-V, it is an open-source Instruction Set Architecture (ISA) that began as a 2010 project of UC Berkeley’s Parallel Computing Laboratory and is now ushering in a new era of chip design and innovation. As the adoption of RISC-V accelerates, it will be used to support a plethora of devices and products, from automotive to 5G and wireless networking, to data centers and beyond. We are seeing new RISC-V architectures that are, for example, designed to deliver new capabilities for pre-silicon development, allowing new ways for SoC (System-on-Chip) architects and system software developers to define new products. This enables organizations to quickly prototype a product, including products for automotive with safety packages. (an excerpt from “Driving the Future of Chip Innovation: Top Three Reasons to Adopt RISC-V” by Desi Banatao) As a RISC architecture, the RISC-V ISA is a  load–store architecture . Its floating-point instructions use  IEEE 754 ...
Read more

Let’s start the new year with a bang!

Image
  Ushering in a new year comes with tons of excitement, anticipation and, of course, setting up new goals to be completed. Whether you’re choosing to ring in 2023 with a resolution to boost your business or to start a new venture, chances are you can take a few cues from Konijn Design Studio where we have mentored and guided hundreds of start-up companies and well-established corporations. To focus on a business direction, it can be helpful to: Clearly define your goals and objectives. Conduct market research to understand the needs and wants of your target audience. Identify the unique value proposition of your business and how it differentiates from competitors. Develop a detailed business plan outlining the steps you will take to achieve your goals. Prioritize and execute on the most important tasks and activities that align with your business direction. Continuously evaluate and adjust your strategy as needed based on market conditions and customer feedback. Stay disciplined an...
Read more