База на знаења

1. Conectamos como administrador al servidor mysql:

[root@www psa]# mysql -u admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5014937 to server version: 4.1.16-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


2. Seleccionamos la base de datos psa.
mysql> use psa;
Database changed
3. Vemos el contenido de la tabla lockout:
mysql> select * from lockout;
+-------+---------------------+----------+
| login | last_wrong | attempts |
+-------+---------------------+----------+
| admin | 2007-05-28 12:33:45 | 3 |
+-------+---------------------+----------+
1 row in set (0.00 sec)

4. Borramos de esta tabla el usuario que nos interese en este caso admin.
mysql> delete from lockout where login ='admin';
Query OK, 1 row affected (0.00 sec)