Breaking News: Grepper is joining You.com. Read the official announcement!

Login to mysql in safe mode

Ben Kiboma answered on September 1, 2020 Popularity 7/10 Helpfulness 2/10

answer Login to mysql in safe mode

related mysql safe mode

Login to mysql in safe mode

Comment

If you've forgotten the root password for MySQL, 
you can reset it using the following steps. 
1. **Stop the MySQL Service**:

    ```bash
     sudo systemctl stop mysql

      mkdir -p /var/run/mysqld
      chown mysql:mysql /var/run/mysqld

     ```

2. **Start MySQL in Safe Mode**:

You'll start MySQL in safe mode, which allows you to log in 
as the root user without a password and make changes to 
the user accounts:

     ```bash
     sudo mysqld_safe --skip-grant-tables &
     ```

3. **Connect to MySQL**:

   Open a new terminal or command prompt window and connect to 
   MySQL as the root user without a password:

   ```bash
   mysql -u root
   ```

4. **Update the Root Password**:

   Run the following SQL query to update the root password. 
   Replace `'new_password'` with your desired new password:

   ```sql
   FLUSH PRIVILEGES;
   ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
ALTER USER 'admin'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'new_password';
   ```

5. **Flush Privileges**:

   ```sql
   FLUSH PRIVILEGES;
   ```

6. **Exit MySQL**:

   Type `exit` to exit the MySQL shell:

   ```sql
   exit
   ```

7. **Restart MySQL**:

     ```bash
     sudo systemctl start mysql
     ```

Popularity 7/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: reset safe-mode sql

Link to this answer
Share Copy Link

Contributed on Sep 23 2023

Ben Kiboma

0 Answers Avg Quality 2/10

Closely Related Answers

mysql safe mode

Comment

SET SQL_SAFE_UPDATES = 0;

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Sep 01 2020

Easy Eland

0 Answers Avg Quality 2/10

Login to mysql in safe mode

Contents

More Related Answers

Login to mysql in safe mode

Closely Related Answers

mysql safe mode

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.