INSERT INTO mysql.user | |
SET user = 'root', | |
host = 'localhost', | |
password = Password('whatevernewpassword'), | |
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', | |
Super_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', | |
Event_priv = 'y', | |
Trigger_priv = 'y', | |
Create_tablespace_priv = 'y', | |
x509_issuer = 'y', | |
x509_subject = 'y', | |
authentication_string = 'y', | |
ssl_cipher = 'y'; |
I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand.
Please find my social handles as below;
Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND