Turns out you can’t use the root user in 5.7 anymore without becoming a sudoer. That means you can’t just run mysql -u root anymore and have to do sudo mysql -u root instead.
That also means that it will no longer work if you’re using the root user in a GUI (or supposedly any non-command line application). To make it work you’ll have to create a new user with the required privileges and use that instead.
Login to MySQL sudo mysql -p -u root

then enter the password entered during mysql installation. CREATE USER CREATE USER ‘admin’@’%’ IDENTIFIED BY ‘your_password’; GRANT ALL PRIVILEGES GRANT ALL PRIVILEGES ON *.* TO ‘admin’@’%’ WITH GRANT OPTION;

Leave a Reply

Your email address will not be published. Required fields are marked *

To Resolve this issue at just 5$ from ServerExpert


For Hosting please visit Hostingwebsite.io

You have Successfully Subscribed!

Open chat