Ibm Support Community – Fixing Mysql 1045 Error: Access Denied

it’s working. But after logout my mysql again it will be showing same ERROR ? So plzzzz Help ME !!!!

On MySql 5.7 version you must replace query to:

update web1_user set authentication_string=PASSWORD(“YOURPASSWORDHERE”) where web1_user=”root”; everything else it’s like CrypticDesigns described..

Use the right password.

I was tripped up on a brand new installation of mysql. There will be a temporary root password created and logged in /var/log/mysqld.log check there and once mysql is started (as a service) you can then start mysqlsecureinstallation and use the password from the log file to setup mysql.

Xem thêm:

Thanks CrypticDesigns. It worked well for me.

It worked for me. Thanks

I have the same problem as described above on my Ubuntu 16.04 LTS/MySQL 5.7.18/WordPress droplet, with 2 CPU, 40GB SSD and 16GB RAM. The droplet is only running one site and has hardly any traffic because it is still under development.

I cannot connect via ‘mysql -u root -p’.I cannot use the “sudo mysqlsecureinstallation’ script.Every time after entering the password I get the dreaded “Access denied for web1_user “root’
“localhost’ (using password: YES)” error message.

This seems to be a very common problem. I followed all the usual recommendation, such as reinstalling MySQL, with and without prior uninstall, crossgrading to MariaDB and back to MySQL, all to none avail. What am I doing wrong?

Btw, the WordPress site is working fine. The problem only became apparent when I added Moodle to the installation and got stuck at the point where you need to create the moodle tables. Since I cannot log into the MySQL server, I’m now stuck.

Installed mysql – 5.7. I Had the same issue.

Tried the below steps:

1. dpkg –get-selections | grep mysql (to get the version of mysql).

2. dpkg-reconfigure mysql-server-5.7

3. mysql -u root -p

Without -p that doesn’t prompt you to ask password. Once you are in, you can create a web1_user with a password by following steps :

CREATE USER ’-your_name-’
‘your-hostname’ IDENTIFIED BY “your-password’;

GRANT ALL PRIVILEGES ON . to ’-your_name-’
“your-hostname’ WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u -p

For some reason still just typing mysql does not work. AT ALL. Please let me know if this works, else I have other steps.

Xem thêm: Kon Tum: Trường Thpt Chuyên Nguyễn Tất Thành Kon Tum, Đoàn Trường Thpt Chuyên Nguyễn Tất Thành Kon Tum

after step 3 it gives Can’t connect to local MySQL server through socket ’/var/run/mysqld/mysqld.sock’ (2)

what to do??

I used mysql -u root -p and enter password and got working.

I am also new in nguyenminhchau.com and was following this article to setup a LEMP server: https://www.nguyenminhchau.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu-20-04

I was having trouble on the last step. I was unable to connect to the database using the php script. It was showing the following error:

“Error!: SQLSTATE <1045> Access denied for web1_user”

I was able to log-in from the terminal using the same credential and was able to see the records on the table, but the php script was showing the connection error for the same credential, which was weird!

After searching all the posts on stackoverflow, found no solution for this. Finally don’t know why, I ran the php file from the terminal like this instead of the browser:

‘php /var/www/yourdomain/todolist.php’

which was showing me an error on line 3, which was the line with the password. It was telling me something like an empty value and indicating the last 2 characters of the password. I then noticed that in my password, before these last two characters, I have a “$” sign, which is the reserved symbol in php to indicate a variable!