Site Tools


chuleta_mysql
innodb_file_per_table=ON
mysql> create database gdpr;
Query OK, 1 row affected (0.08 sec)

mysql> CREATE USER 'user_gdpr'@'localhost' IDENTIFIED BY 'gdpr_user_password';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON gdpr . * TO 'user_gdpr'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> create table hash  (id MEDIUMINT NOT NULL AUTO_INCREMENT, hash CHAR(150) NOT NULL, fecha DATE, PRIMARY KEY (id));
Query OK, 0 rows affected (0.09 sec)

mysql> insert into hash (hash,fecha) VALUES ('123123',sysdate());
Query OK, 1 row affected, 1 warning (0.00 sec)
chuleta_mysql.txt · Last modified: by etfiat