MySQL Administration

HOW TO RESET  MYSQL ROOT PASSWORD

  # start MySQL without permissions
  /usr/local/bin/mysqld_safe --skip-grant-tables &

  # login to mysql as root without password
  mysql -uroot

  # flush privileges
  flush privileges;

  # change root password
  set password for 'root'@'localhost' = PASSWORD('new-password');


OTHER COMMANDS

# show version
select version();

# change root password
set password for 'root'@'localhost' = PASSWORD('new-password');