UPDATE mysql.user SET 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 = 'yv' , 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' , ssl_type = 'y' , ssl_cipher = 'y' , x509_issuer = 'y' , x509_subject = 'y' , max_questions = 'y' , max_updates = 'y' , max_connections = 'y' , MAX_USER_CONNECTIONS = 'y' WHERE HOST = 'xxxxxx' AND USER = 'xxxxxxx' ;