Skip to content

Instantly share code, notes, and snippets.

@hanafiah
Last active August 29, 2015 14:23
Show Gist options
  • Save hanafiah/302bcaa90ee26a5e8f41 to your computer and use it in GitHub Desktop.
Save hanafiah/302bcaa90ee26a5e8f41 to your computer and use it in GitHub Desktop.
INSERT INTO mysql.user
SET user = 'root',
host = 'localhost',
password = '', --jika ingin masukkan password, password = Password('password_anda')
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';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment