Crear cuenta
(1)(1)$ mysqladmin -u root -p version
Enter password:mysqladmin Ver 9.1 Distrib 10.3.24-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 10.3.24-MariaDB-2
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sockUptime: 5 days 7 hours 39 min 54 secThreads: 10 Questions: 6722942 Slow queries: 1326 Opens: 569 Flush tables: 1 Open tables: 323 Queries per second avg: 14.628
$ mysqladmin -u root -p processlist
Enter password:+--------+-------------+-----------+----+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+--------+-------------+-----------+----+---------+------+--------------------------+------------------+----------+
| 1 | system user | | | Daemon | | InnoDB purge worker | | 0.000 |
| 2 | system user | | | Daemon | | InnoDB purge worker | | 0.000 |
| 3 | system user | | | Daemon | | InnoDB purge coordinator | | 0.000 |
| 4 | system user | | | Daemon | | InnoDB purge worker | | 0.000 |
| 5 | system user | | | Daemon | | InnoDB shutdown handler | | 0.000 |
| 688324 | all | localhost | | Query | 0 | Init | show processlist | 0.000 |
+--------+-------------+-----------+----+---------+------+--------------------------+------------------+----------+
(1)REVOKE [permiso] ON [nombre de base de datos].[nombre de tabla] FROM ‘[nombre de usuario]’@‘localhost’;
$ mysqladmin -u root -p status
Enter password:Uptime: 459803 Threads: 10 Questions: 6722943 Slow queries: 1326 Opens: 569 Flush tables: 1 Open tables: 323 Queries per second avg: 14.621
DROP TRIGGER trigger1;
DROP TRIGGER trigger2;
DROP TRIGGER trigger3;
...
GRANT [permiso] ON [nombre de bases de datos].[nombre de tabla] TO ‘[nombre de usuario]’@'localhost’;