MySQL Change Root Password

1. **Log in to MySQL**: Open your terminal or command prompt and log in to MySQL with the root user.

mysql -u root -p

Enter your current root password when prompted.

2. **Change the authentication plugin**: You can update the authentication method for the root user to `mysql_native_password`. Run the following SQL command:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';

Replace `'your_new_password'` with the desired password for the root user.

3. **Flush privileges**: To ensure that MySQL recognizes the changes, run:

FLUSH PRIVILEGES;

4. **Exit MySQL**:

EXIT;

5. **Test the new password**: You can now test logging in with the new password:

mysql -u root -p

This process sets the root user to use the native password authentication method, which is compatible with various MySQL clients. Make sure to choose a strong password for security purposes.

### 1. Access Your MySQL Docker Container

First, you need to access your running MySQL container. You can find the container name or ID using the following command:

docker ps

Then, use `docker exec` to access the MySQL shell:

docker exec -it <your_mysql_container_name> mysql -u root -p

Replace “ with the name or ID of your MySQL container.

### 2. Change the Authentication Method

Once you're in the MySQL shell, you can change the authentication method for the root user. Execute the following SQL commands:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES;

Replace `'your_new_password'` with the desired password for the root user.

### 3. Exit MySQL

After making the changes, exit the MySQL shell:

EXIT;

### 4. (Optional) Update Your Docker Compose File

If you are using Docker Compose and want to set the root password as part of your configuration, you can specify the `MYSQL_ROOT_PASSWORD` environment variable in your `docker-compose.yml` file:

version: '3.8'

services:
  mysql:
    image: mysql:latest
    environment:
      MYSQL_ROOT_PASSWORD: your_new_password
    ports:
      - "3306:3306"
    volumes:
      - mysql_data:/var/lib/mysql

volumes:
  mysql_data:

### 5. Restart the MySQL Container (if necessary)

If you updated your `docker-compose.yml`, restart your container to apply the changes:

docker-compose down
docker-compose up -d

### 6. Test the New Password

Finally, test the new password by trying to log in again:

docker exec -it <your_mysql_container_name> mysql -u root -p

This should successfully log you in using the native password authentication.