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
Also in Shell:
- how to move a directory in linux
- git bash set global username and password
- linux command to list directory size
- .htaccess
- delete a deployment in kubernetes
- Powershell Core server manager module
- how to push force git
- git global ignore
- remove mysql
- git remove Untracked files
- git create new branch
- how ot get android notifications i ubuntu
- image converter linux
- upgrade node version
- git show diff in modified file
- bash head command
- cp multiple files
- what is my ip
- uninstall node from linux debian
- git remove file from history
- moodle update cli
- direnv
- service dead but pid file exists
- list all the files in a directory without the directory in linux