Answer the question
In order to leave comments, you need to log in
Can't create new root after deletion?
In short, removed the root.
I'm looking to get it all back.
There is this instruction:sudo /etc/init.d/mysql stop
sudo mysqld --skip-grant-tables
sudo mysql
mysql> INSERT INTO mysql.user(Host, User, Password, Select_priv,
Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv,
Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv,
References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv,
Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv,
Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv,
Alter_routine_priv, Create_user_priv)
values('localhost','root',password('newpass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
sudo /etc/init.d/mysql stop
they answer me "stop: Unknown instance:", respectively, I cannot start mysql with the necessary options, since the process is not stopped mysql start/running, process 29828
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question