Step to add password in root Login
- Login with root credentials in Ubuntu
- Open Command Prompt (Ctrl+Alt+t ) in ubuntu
- Give following command to open mysql
- sudo musql -u root
- This will open mysql prompt without password
- Give following command in mysql
- ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password by ‘admin’;
- This command will update password as admin
- Come out of mysql (Ctrl+z)
- Type following command to restart mysql service
- sudo service mysql restart
- Now open phpmyadmin in browser with credential root as username and password as ‘admin’
- Hurre!!!
- Login is sucessfully done
