Mysql default user password

user:root
#The password is empty
password:
#If by accident you set the password and you don't remember it
service mysql stop #Stop mysql service
mysqld_safe --skip-grant-tables & #disable "login"
mysql #Log in into mysql, you should see mysql> in prompt
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';
FLUSH PRIVILEGES; #
exit; # exit from mysql
mysqladmin -u root -p shutdown # shutdown mysql service
service mysql start # Restart your service

Source: a2hosting.com

Default password of mysql

mysqladmin -u root password NEWPASSWORD

Source: techrepublic.com

Default password of mysql

mysql_secure_connection

Source: techrepublic.com

Similar codes

4 votes106 views2 answers
Install snap change in progress ubuntu
Shell/Bash
0 vote101 views1 answer
Rails add gem to gemfile
Shell/Bash
0 vote107 views1 answer
How to echo string .sh
Shell/Bash
0 vote95 views1 answer
Twig install
Shell/Bash
0 vote97 views1 answer
How to keep track of github profile views
Shell/Bash
0 vote91 views2 answers
Create linux user with non interactive shell
Shell/Bash
1 vote102 views2 answers
Batch file comment after command
Shell/Bash
1 vote92 views1 answer
Save awk to file
Shell/Bash
2 votes94 views1 answer
Powershell multiline comment
Shell/Bash
0 vote97 views1 answer
Odoo 11 Development In Ubuntu 18.04 Using Pycharm
Shell/Bash