¿Cómo agregar superpermisos a la base de datos MySQL?

Primero, use la orden DESC para verificar la base de datos MySQL.

mysql>DESC mysql.db;

以下是输出。

+-----------------------+---------------+------+-----+---------+-------+
|　Field　　　　　　　　　　　　　　　　　|　Type　　　　　　　　|　Null　|　Key　|　Default　|　Extra　|
+-----------------------+---------------+------+-----+---------+-------+
|　Host　　　　　　　　　　　　　　　　　　|　char(60)　　　　　　|　NO　　　|　PRI　|　　　　　　　　　|　　　　　　　|
|　Db　　　　　　　　　　　　　　　　　　　　|　char(64)　　　　　　|　NO　　　|　PRI　|　　　　　　　　　|　　　　　　　|
|　User　　　　　　　　　　　　　　　　　　|　char(32)　　　　　　|　NO　　　|　PRI　|　　　　　　　　　|　　　　　　　|
|　Select_priv　　　　　　　　　　　|　enum('N','Y')　|　NO　　　|　　　　　|　N　　　　　　　|　　　　　　　|
|　Insert_priv　　　　　　　　　　　|　enum('N','Y')　|　NO　　　|　　　　　|　N　　　　　　　|　　　　　　　|
|　Update_priv　　　　　　　　　　　|　enum('N','Y')　|　NO　　　|　　　　　|　N　　　　　　　|　　　　　　　|
| Delete_priv | enum('N','Y') | NO | | N | | |
| Create_priv | enum('N','Y') | NO | | N | | |
| Drop_priv | enum('N','Y') | NO | | N | | |
| Grant_priv | enum('N','Y') | NO | | N | | |
| References_priv | enum('N','Y') | NO | | N | | |
| Index_priv | enum('N','Y') | NO | | N | | |
| Alter_priv | enum('N','Y') | NO | | N | | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | | |
| Lock_tables_priv | enum('N','Y') | NO | | N | | |
| Create_view_priv | enum('N','Y') | NO | | N | | |
| Show_view_priv | enum('N','Y') | NO | | N | | |
| Create_routine_priv | enum('N','Y') | NO | | N | | |
| Alter_routine_priv | enum('N','Y') | NO | | N | | |
| Execute_priv | enum('N','Y') | NO | | N | | |
| Event_priv | enum('N','Y') | NO | | N | | |
| Trigger_priv | enum('N','Y') | NO | | N | | |
+-----------------------+---------------+------+-----+---------+-------+
22　filas en conjunto (0.06　sec)

Ahora veamos la consulta para otorgar privilegios.

mysql> UPDATE mysql.user SET Super_Priv='Y' WHERE user='Manish' AND host='%';
Rows matched:　1　　Changed: 0 Warnings: 0

Ahora utilizaremos la orden DESC para mostrar la tabla.

mysql> desc mysql.user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host | char(|60) | NO | PRI | | | | | |
| User | char(|32) | NO | PRI | | | | | |
| Select_priv | enum('N','Y') | NO | | N | | | |
| Insert_priv | enum('N','Y') | NO | | N | | | |
|　Update_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Delete_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Create_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Drop_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Reload_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Shutdown_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Process_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　File_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
|　Grant_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|
| References_priv | enum('N','Y') | NO | | N | | | |
| Index_priv | enum('N','Y') | NO | | N | | | |
| Alter_priv | enum('N','Y') | NO | | N | | | |
| Show_db_priv | enum('N','Y') | NO | | N | | | |
| Super_priv | enum('N','Y') | NO | | N | | | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | | | |
| Lock_tables_priv | enum('N','Y') | NO | | N | | | |
| Execute_priv | enum('N','Y') | NO | | N | | | |
| Repl_slave_priv | enum('N','Y') | NO | | N | | | |
|　Repl_client_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Create_view_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Show_view_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Create_routine_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Alter_routine_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Create_user_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Event_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Trigger_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　Create_tablespace_priv　|　enum('N','Y')　|　NO　|　　|　N　|　　|　N　|　　|　　|
|　ssl_type　|　enum('','ANY','X')509','SPECIFIED')　|　NO　|　　|　　|　　|　　|
|　ssl_cipher　|　blob　|　NO　|　　|　NULL　|　　|
|　x　|509_issuer　|　blob　|　NO　|　　|　NULL　|　　|
|　x　|509_subject　|　blob　|　NO　|　　|　NULL　|　　|
|　max_questions　|　int(　|11)　unsigned　|　NO　|　　|　0　|　　|
|　max_updates　|　int(　|11)　unsigned　|　NO　|　　|　0　|　　|
|　max_connections　|　int(　|11)　unsigned　|　NO　|　　|　0　|　　|
|　max_user_connections　|　int(　|11)　unsigned　|　NO　|　　|　0　|　　|
|　plugin　|　char(　|64)　|　NO　|　　|　caching_sha　|　　|2_password　|　　|
|　authentication_string　|　text　|　YES　|　　|　NULL　|　　|　　|　　|
|　password_expired　|　enum('N','Y')　|　NO　|　　|　N　|　　|　caching_sha　|　　|
| password_last_changed                                                            | timestamp                                                                           | SÍ                                                                               |                                                                                       |
| password_lifetime                                                                  | smallint(5) unsigned                                                                      | SÍ                                                                               |                                                                                       | NULL                                                                               |                                                                                       |
| account_locked                                                                   | enum('N','Y')                                                                       | NO                                                                               |                                                                                       |
| Create_role_priv                                                                   | enum('N','Y')                                                                       | NO                                                                               |                                                                                       |
| Drop_role_priv                                                                   | enum('N','Y')                                                                       | NO                                                                               |                                                                                       |
| Password_reuse_history                                                          | smallint(5) unsigned                                                                      | SÍ                                                                               |                                                                                       | NULL                                                                               |                                                                                       |
| Password_reuse_time                                                              | smallint(5) unsigned                                                                      | SÍ                                                                               |                                                                                       | NULL                                                                               |                                                                                       |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
49　filas en conjunto (0.01　sec)

Se puede ver fácilmente en la tabla superior los privilegios añadidos. Para agregar privilegios superiores a la base de datos MySQL, aquí está la sintaxis.

mysql> GRANT SUPER ON　*.*　TO user@'localhost' IDENTIFIED BY 'passwordName';

Después de ejecutar la consulta superior, no olvide finalizarla con el siguiente comando.

FLUSH PRIVILEGES;