title: I installed MySQL 8.x using yum, but I cannot find or reset the root password
body: <p>I had to install mysql 8.0 because previous version were crashing.<br>
  Now I'm struggling with setting root password. The default empty password doesn't work, I've tried <code>root</code>, <code>mysql</code> as passwords but they are not working.<br>
  I've created the init file to reset password. Unfortunately, my passwords are not accepted, here is my log:</p>
  
  <pre><code>2018-02-16T10:12:22.962733Z 0 [Warning] [MY-010139] Changed limits: max_open_files: 5000 (requested 8161)
  2018-02-16T10:12:22.962815Z 0 [Warning] [MY-010142] Changed limits: table_open_cache: 2419 (requested 4000)
  2018-02-16T10:12:23.160066Z 0 [System] [MY-010116] /usr/sbin/mysqld (mysqld 8.0.4-rc-log) starting as process 20059 ...
  2018-02-16T10:12:24.013727Z 0 [Warning] [MY-010068] CA certificate ca.pem is self signed.
  2018-02-16T10:12:24.026122Z 0 [Warning] [MY-010319] Found invalid password for user: 'root@localhost'; Ignoring user
  2018-02-16T10:12:24.043758Z 6 [Warning] [MY-010319] Found invalid password for user: 'root@localhost'; Ignoring user
  2018-02-16T10:12:24.050668Z 0 [System] [MY-010931] /usr/sbin/mysqld: ready for connections. Version: '8.0.4-rc-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL).
  </code></pre>
  
  <p>Here is my current init file content:</p>
  
  <pre><code>SET GLOBAL validate_password.policy = 'LOW';
  UPDATE mysql.user
      SET authentication_string = PASSWORD('new_password'), password_expired = 'N'
      WHERE User = 'root' AND Host = 'localhost';
  FLUSH PRIVILEGES;
  </code></pre>
  
  <p>I've tried so much different passwords, none worked. I've tried to create passwords longer than 16 characters with special characters and numbers, nothing. Any advices what I could do to reset the password and actually start using DB?</p>