Infrastructure at your Service

All Posts By

Elisa Usai

Elisa Usai

My first presentation at the DOAG – “MySQL 8.0 Community: Ready for GDPR?”

By | Database Administration & Monitoring | 4 Comments

This year I participated for the first time to the DOAG, the conference which takes place in November in Nuremberg. Here some key words about this event: Oracle and other technologies, 2000 visitors, more than 400 sessions, more than 800 abstracts sent, exhibitors… And for me everything started when in June I decided to send an abstract for a MySQL session.

Read More
Elisa Usai

MySQL 8.0 – Roles are finally there

By | Database Administration & Monitoring | No Comments

Roles have been existing on many RDBMS for a long time by now. Starting from version 8.0, this functionality is finally there for MySQL. The most important advantage is to define only once a role that includes a “set of permissions”, then assign it to each user, avoiding wasting time declaring them individually. In MySQL, a role can be created like a user, but without the “identified by” clause and without login: mysqld2-([email protected]) [(none)]> CREATE…

Read More
Elisa Usai

MySQL – Time mismatch between system and log files

By | Database Administration & Monitoring | No Comments

I was working on MySQL upgrades to version 5.7 at a customer, when I found out that for my instance, time in the error log file didn’t correspond to local system time: [email protected]:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] mysql -uroot -p Enter password: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES) [email protected]:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] ls -ltr mysqld1.err -rw-r—–. 1 mysql mysql 13323 Apr 12 10:54 mysqld1.err [email protected]:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] tail -1 mysqld1.err 2018-04-12T08:54:55.300633Z 67 [Note] Access denied for…

Read More