Category Archives: password

MySQL 5.7 auto-generated root password

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 Replication with SSL

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

How to change user password on MySQL

Today let’s talk about how to change MySQL user password We can use 2 ways, 1 – mysqladmin, 2 – linguagem SQL This is a step by step video of this post: 1. mysqladmin: The syntax is easy: mysqladmin -u … Continue reading




Liked? Help and Share!
Posted in MySQL, password | 8 Comments

Recover MySQL root password

If you have lost the MySQL root password, or just don’t remember it, don’t worry, follow the step by step for you to retrieve it Stop the MySQL service if it is running “/etc/init.d/mysql stop” Up the Server “skiping” the … Continue reading




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