InfoHeap
Tech
Navigation
  • Home
  • Tutorials
    • CSS tutorials & examples
    • CSS properties
    • Javascript cookbook
    • Linux/Unix Command Line
    • Mac
    • PHP
      • PHP functions online
      • PHP regex
    • WordPress
  • Online Tools
    • Text utilities
    • Online Lint Tools
search

Mysql tutorials

  • Enable query log without restarting mysql on Linux
  • How to find mysql query rate on Linux
  • Mysql - display row count and size of tables
  • Mysql - get size of all databases
  • Mysql - get total queries since beginning
  • Mysql - how to copy a table
  • Mysql - how to enable query log
  • Mysql 5.7 root password after installation
  • Mysql difference between CURDATE() and NOW()
  • Mysql find current timezone offset
  • Mysql find slave lag
  • Mysql how to dump schema of all databases
  • Mysql multi column Index
  • Wordpress Mysql Queries
  • mysql - how to enable query logs
  • mysql find recently created-tables
 
  • Home
  • > Tutorials
  • > Mysql

Mysql 5.7 root password after installation

on Jun 2, 2020

A random root password is generated and logged in log /var/log/mysqld.log

sudo cat /var/log/mysqld.log | grep -i password
2020-06-02T17:39:23.434297Z 1 [Note] A temporary password is generated for root@localhost: Cu=aizr-k2ix

Change root password

  • SET GLOBAL validate_password_policy = 0;
    (in case you want to keep less strict password. It should be avoided in production environment)
  • ALTER USER 'root'@'localhost' IDENTIFIED BY 'somepassword';

Suggested posts:

  1. SVG – beginner tutorial
  2. How to migrate wordpress from root to sub directory
  3. How to print javascript object to log
  4. CSS :checked – style for selected checkbox and radio
  5. Linux how to modify a user using usermod
  6. AngularJS format date using date filter
  7. How to find mysql query rate on Linux
  8. How to fix a broken sudoers file on AWS/EC2 Linux
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in Tutorials | Tagged Mysql
  • Browse content
  • Article Topics
  • Article archives
  • Contact Us
Popular Topics: Android Development | AngularJS | Apache | AWS and EC2 | Bash shell scripting | Chrome developer tools | Company results | CSS | CSS cookbook | CSS properties | CSS Pseudo Classes | CSS selectors | CSS3 | CSS3 flexbox | Devops | Git | HTML | HTML5 | Java | Javascript | Javascript cookbook | Javascript DOM | jQuery | Kubernetes | Linux | Linux/Unix Command Line | Mac | Mac Command Line | Mysql | Networking | Node.js | Online Tools | PHP | PHP cookbook | PHP Regex | Python | Python array | Python cookbook | SEO | Site Performance | SSH | Ubuntu Linux | Web Development | Webmaster | Wordpress | Wordpress customization | Wordpress How To | Wordpress Mysql Queries | InfoHeap Money

Copyright © 2025 InfoHeap.

Powered by WordPress