Building LAMP with Linux MINT Cannot log in with mysql root password

I was working on creating a wordpress development ring on Cloud9 on aws. However, there seems to be a problem with the line speed of the mobile Wi-Fi I'm using, so I can't help because the work stops, so let's build LAMP in the Linux MINT environment in my old laptop for the first time in a while. It was made.

I built it with reference to this article.

[Programming] I installed the PHP development environment on Linux Mint.

Apache2 DocumentRoot change in Linux Mint

How to store WordPress in a public folder and publish it

Install LAMP (Linux, Apache, MySQL, PHP) development environment on Linux Mint

ROOT password is not accepted

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I thought the password was different and was just looking for ways to reset and reset the root password.

However, after searching various things, I found out that there was a problem with the password authentication method.

What to do if the mysql8 error "ERROR 1698 (28000): Access denied for user'root'@'localhost'" occurs

I will reprint the quote from the article linked above.

Because the authentication method of the root user is "auth_socket". If it is "auth_socket", the user name specified when running mysql -u must be the same as the user name logged in to Ubuntu.

Therefore, after entering the following command, I was able to enter the root password.

sudo mysql -u root -pi

MySQL pays attention to the difference in version

In MySQL, the Password function may not be available depending on the version, so the method for resetting the root password is different. Check the version of MySQL you are using, read the error message carefully, and if you don't understand it, search the net for the error message and find out. However, the articles you can find are old, so you have to be careful.

Recommended Posts

Building LAMP with Linux MINT Cannot log in with mysql root password
Create Amazon Linux with AWS EC2 and log in
[linux] Erase root password
Build a LAMP environment with Vagrant (Linux + Apache + MySQL + PHP)
Password generation in texto with python