I
I
Ilya Beloborodov2016-11-02 17:08:38
MySQL
Ilya Beloborodov, 2016-11-02 17:08:38

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');

all clear. but at the command sudo /etc/init.d/mysql stopthey 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 question

Ask a Question

731 491 924 answers to any question