Category Archives: Security

MySQL 5.7 auto-generated root password

Posted on Wednesday, 13 January 2016 by marceloaltmann

Hi There. You may have noticed something different when you install a fresh copy of MySQL 5.7 either via yum or using binary source. The root password is auto-generated. Ok and where can I find it ? Centos cat /var/log/mysqld.log … Continue reading →




Liked? Help and Share!
Posted in install, MySQL, password, Security | 12 Comments

MySQL Backup Strategy – Slides

Posted on Thursday, 29 January 2015 by marceloaltmann

Hi there, it’s been a few months since Percona Live London has finished, but I managed just now to get sometime to post the slides from my presentation about backups. Please, take a look and feel free to comment. Pdf … Continue reading →




Liked? Help and Share!
Posted in backup, MySQL, Security | Leave a comment

Auditing MySQL With Mcafee Audit Plugin

Posted on Monday, 14 October 2013 by marceloaltmann

Audit MySQL isn’t an easy task by default, you can use some technics like tcpdump, write a parser for general log, use MySQL proxy, or you can use some of audit plugins available out there(Mcafee MySQL Audit Plugin or MySQL … Continue reading →




Liked? Help and Share!
Posted in install, mysqld, Security | 7 Comments

MySQL Replication with SSL

Posted on Thursday, 31 January 2013 by marceloaltmann

Hi folks, let’s continue talk about replication, you can see the basics in this other post First of all, lets create the ssl certificates, go to the master server: Create CA certificate: openssl genrsa 2048 > ca-key.pem openssl req -new … Continue reading →




Liked? Help and Share!
Posted in MySQL, password, replication, Security | 2 Comments