Sometimes when trying to log in MySQL as root user using mysql -uroot -p, the user account after login(select current_user()) is actually “@localhost”, without permission to do anything in the database. The user may only see very few databases. Why is that and how to solve the problem?
Continue reading