dev-resources.site
for different kinds of informations.
Fix MySQL Cant Logged As Normal User
Published at
6/16/2020
Categories
linux
mysql
troubleshoot
Author
bramaudi
Author
8 person written this
bramaudi
open
Problem: User "root" can't logged in normal terminal, but can login on super user terminal only a.k.a sudo
.
Solution:
1.) Login as sudo.
sudo mysql -u root
2.) Check if root
user is exists (actually this is optional).
SELECT User,Host FROM mysql.user;
3.) Delete root user in MySQL.
DROP USER 'root'@'localhost';
4.) Create the root user again.
CREATE USER 'root'@'%' IDENTIFIED BY '';
5.) Setup permission for the new user.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
Logout from MySQL (quit) then try login back with normal terminal user, it should be fixed.
troubleshoot Article's
21 articles in total
how to inspect a docker container
read article
🎧 Troubleshooting Sound Card Issues on Ubuntu Desktop
read article
Simple steps to debug docker build
read article
Natural hangs during ET Sync
read article
How to Troubleshoot Your Superbox S3 Pro TV!
read article
Fix fatal ambiguous argument 'HEAD^ in Zsh with HEAD^
read article
How do I Troubleshoot Error Code 6069 in QuickBooks
read article
Troubleshooting and Fixing WordPress Email Delivery Problems
read article
Simple Guide for analyzing web traffic for troubleshooting purposes
read article
hint: Updates were rejected because the tip of your current branch is behind
read article
Linux Troubleshooting Scenarios - Part 2
read article
Linux Troubleshooting Scenarios - Part 3
read article
Adaptador de red wireless BCM4360 en Kali Linux
read article
Quickops 3: too many connections to my database and what can i do
read article
Compare table structures in two schemata
read article
Troubleshooting the right way
read article
Fix MySQL Cant Logged As Normal User
currently reading
Youtube iFrame API - YT.Player is not a constructor
read article
Gatsby Develop ERROR #98123 WEBPACK, Generating SSR bundle failed
read article
Resolutions to setup issues with Craft on AMPPS
read article
iOS Development "There's no information available for In-App Purchases.
read article
Featured ones: