reset password mysql

reset.sh

# Stop MySQL
```bash
  sudo /etc/init.d/mysql start
```
# Make MySQL service directory & give MySQL user permission to write to the service directory.
```bash
  sudo mkdir /var/run/mysqld && sudo chown mysql: /var/run/mysqld
```
# Start MySQL manually, without permission checks or networking.
```bash
  sudo mysqld_safe --skip-grant-tables --skip-networking &
```
# Log in without a password.
```bash
  mysql -uroot mysql
```
# Update the password for the root user.
```sql
  USE mysql;
  update user set authentication_string=password('password') where user='root';
  flush privileges;
```
# Turn off MySQL.
```bash
  sudo /etc/init.d/mysql stop
```
# Start the MySQL service normally.
```bash
  sudo /etc/init.d/mysql start
```