I have followed this tutorial to install MySQL but after successfully installed MySQL, I could not access database.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
lampMySQLpermissions
I have followed this tutorial to install MySQL but after successfully installed MySQL, I could not access database.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Best Answer
I found a solution at here link, by following this solution I have solved my problem.
Short steps are:
Note: here
test
is a new password for the root user. Also, remember to run the commandsudo service mysql restart
after altering the user.