Elimar el root de MySQL Centos

[servervirto]

Creo que jer64 dijo que borro el usuario root de mysql no que necesitaba resetear el password de root.


Adiciona 'skip-grant-tables' a tu fichero my.cnf debajo de la sesion [mysqld]
reinicia mysql

escribe mysql solamente sin password y has click en enter

corre esto:

DELETE FROM mysql.user
WHERE user = 'root'
AND host = 'localhost';

INSERT INTO mysql.user
SET user = 'root',
host = 'localhost',
password = Password('whatevernewpassword'),
super_priv = 'y',
select_priv = 'y',
insert_priv = 'y',
update_priv = 'y',
delete_priv = 'y',
create_priv = 'y',
drop_priv = 'y',
reload_priv = 'y',
shutdown_priv = 'y',
process_priv = 'y',
file_priv = 'y',
grant_priv = 'y',
references_priv = 'y',
index_priv = 'y',
alter_priv = 'y',
show_db_priv = 'y',
create_tmp_table_priv = 'y',
lock_tables_priv = 'y',
execute_priv = 'y',
repl_slave_priv = 'y',
repl_client_priv = 'y',
create_view_priv = 'y',
show_view_priv = 'y',
create_routine_priv = 'y',
alter_routine_priv = 'y',
create_user_priv = 'y';

sal de mysql

quita 'skip-grant-tables' de my.cnf [mysqld]

reinicia mysql