Tecnologia e Conhecimento em um só lugar

Execute:

SELECT client_name,session_id, current_timestamp-start_time - 
AS ElapTime, commmethod, state, CAST(bytes_sent/1024/1024 AS DEC(8,1)) - 
AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,1)) AS "MB_Rcvd", - 
cast((cast(bytes_sent as dec(18,0))/cast((current_timestamp-start_time) - 
seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,1)) AS "Sent_MB/s", -
cast((cast(bytes_received as dec(18,0))/cast((current_timestamp-start_time) - 
seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,1)) AS "Rcvd_MB/s" -
  FROM sessions WHERE session_type='Node'

 service mysql stop

Aguarde o banco parar. Execute:

 mysqld_safe --skip-grant-tables &

Então poderá agora logar sem senha usando o root

 mysql -uroot mysql 

Na linha de comando, logado no banco MYSQL, execute

 UPDATE user SET password=PASSWORD("sua senha") WHERE user="root"; 
 FLUSH PRIVILEGES;