Posts

Showing posts from April, 2019

Mysql logging in even without providing password [Solved]

Mysql logging in even without providing password Setp 1 Command  SELECT User,Host FROM mysql.user; mysql> SELECT User,Host FROM mysql.user; +------------------+-----------+ | User             | Host      | +------------------+-----------+ | root                        | %         | | debian-sys-maint   | localhost | | mysql.session        | localhost | | mysql.sys              | localhost | | phpmyadmin         | localhost | | ubuntu                  | localhost | +------------------+-----------+ Then DROP USER 'root'@'localhost';  FLUSH PRIVILEGES;