I've never stopped using the root user for mysql on my server, so i felt it was time to create a new user and start using this one instead of root. Also i wanted to update the mysql root password with a better password.

# Log into the server then # Log into mysql

mysql -u root -p

## Create a new user

mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';

## Grant everything to the new guy

mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' WITH GRANT OPTION;

## Check if the user was created via

mysql> select User from mysql.user;

## Exit out of mysql and if you want to change the root password you can do so using this command