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 votes152 views2 answers
Install aws cli on windows
Shell/Bash
0 vote170 views1 answer
PostgreSQL foreign key constraint syntax
Shell/Bash
0 vote148 views1 answer
How add access user to docker linux
Shell/Bash
0 vote155 views1 answer
How to run pkg file on mac terminal
Shell/Bash
24 votes150 views3 answers
No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'
Shell/Bash
0 vote167 views1 answer
Check if server has alreday AD
Shell/Bash
0 vote160 views1 answer
Dotnet CLI db scaffolding
Shell/Bash
0 vote145 views1 answer
Powershell array pipe foreach
Shell/Bash
0 vote196 views1 answer
Osx remvoe env
Shell/Bash
0 vote170 views2 answers
ERROR: Could not build wheels for numpy which use PEP 517 and cannot be installed directly
Shell/Bash