Access denied for user 'root'@'localhost' (using password: YES) EVEN when the Password works on PhpMyAdmin

mysql access denied for user ''@'localhost'
error 1045 (28000): access denied for user
access denied for user mysql remote
access denied for user laravel
access denied for user 'root
access denied for user to database
access denied for user to database 'mysql
mysql2::error: access denied for user 'root'@'localhost' (using password: yes)

I have an issue with accessing MySQL using root and password. I am trying to connect the Server using PuTTY SSH using

> mysql u root -p

For an unknown reason I can NOT access the Database and I am getting rejected with the following ERROR:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

The weird thing is that I am using the same password with PhpMyAdmin using Web and I can access everything. I need to run a script that will allow the SQL server

root@localhost user

run the query over the LAN and not the web.

Therefore I need the user to connect using command line SSH or something like that.

How can I fix that issue? the user rott and password WORKS just fine through PhpMyAdmin and not through SSH PuTTY, Why?

Is there something I need to do in order to fix this? I have been working with the Database for 2 years now using the web interface. Now I need to have it working using SSH (22).

Please assist. thanks in advance. Arye

It sounds like you need to update the your password for root on MySQL. Check here: MySQL - ERROR 1045 - Access denied

Access denied for user 'test'@'localhost' (using password: YES , Follow the steps below. Start the MySQL server instance or daemon with the -- skip-grant-tables option (security setting). $ mysqld --skip-grant-tables. Execute� If the access denied issue is caused by a corrupt account, you can resolve it by creating a new local user profile / account. To do that, follow these steps: Step 1 Click Start menu and select Settings.

Thank you all for your help. I have managed to overcome the issue: (see below)

That was FIXED Only when I changed from old password to new. in my.cnf file I have removed the flag for old_password=1 and Restart the service of MySQL.

Then I have created a NEW password (using the old one I had) and it was created with 41 (NEW) Hash length and not 16 (OLD)..

Then I did flush privileges as you recommended - and IT WORKS. Thank You!

mysql how to fix Access denied for user 'root'@'localhost', The error message indicates that you're not connecting to the remote MySQL at all, but to localhost. Make sure you connect using option -h to the remote server. "Access Denied" or other errors when you access or work with files and folders in Windows. Content provided by Microsoft. Applies to:

> mysql -h your_host_name -P your_port_number -u your_user_name -p

try with hostname option it should work!

MySQL remote connection, To fix MySQL Error: : 'Access denied for user 'root'@'localhost', you should follow these steps: Step 1: Open and Edit /etc/my.cnf or� However when I did so it give me access with net user administrator command, but when I disabled the account again with the same command it locked my administrator account again. When I removed my computer from the domain, because I have Windows 7 professional I had no more problems.

Ubuntu 18.04 running MySQL 5.7.28 creates a file /etc/mysql/debian.cnf. It contains some credentials and other settings. So, this debian-sys-maint user is by default a root equivalent. It is used by certain maintenance scripts on Debian systems, and as a side-effect, allows users with root access on the box to view the plaintext password in /etc/mysql/debian.cnf. If your SSH using a client fails after a fresh install through root try using the credentials set in this file.

MySQL Error: : 'Access denied for user 'root'@'localhost', Fixing access denied for 'user'@'ip_address'. Sometimes you may want to add a remote user to MySQL, you try to connect remotely but your� Type net user and press Enter; Run “net user” in Command Prompt. The main difference between your administrator account and the built-in administrator account is that the built-in administrator account has full unrestricted access to your computer. So, enabling the built-in administrator account can be helpful when you are having privileges

How to Fix Access Denied Errors in MySQL, Most MySQL users encountered the ERROR 1698 (28000): Access denied for user 'root'@'localhost'. This error message usually appears for� When accessing access denied, it means your system cannot retrieve the file that the user is requesting. That is, the user doesn’t have access permission to the file or the file is already used. Facebook

How to Fix MySQL Error: Access denied for user root@localhost, So let's take a look at why the MySQL 1045 error Access Denied triggers. ERROR 1045 (28000): Access denied for user 'root'@'localhost'� To fix "Access Denied " folder or file errors, try out the following methods one by one until the problem is solved. Method 1: Get the ownership of the file or folder Sometimes, some of your account information might have changed when you've upgraded your Windows to the latest version.

Fixing MySQL 1045 Error: Access Denied, 1044/1045 - Access denied for user 'username'@'yourhost' updated at July 21, 2020 23:07. Apply OS: Windows, macOS, Linux, iOS. Apply Navicat Product:� I too just started having this problem trying to access Marlboro's website. I play the contests they have for years. Now access denied, sometimes will get as far as signing in then go to a page on their website but when trying to move to another page then will get access denied. The inprivate window did the same thing.

Comments
  • Does mysql u root -p user work ?
  • Also see dev.mysql.com/doc/refman/5.1/en/problems-connecting.html
  • What happens when you try mysql -h 127.0.0.1 -u root -p ? (when no host is specified or 'localhost' is used, then mysql will try to connect over a filesystem socket - and these usually have different authentication rules associated compared with network sockets)
  • I am not sure I am following what you want me to do? the password is working on PhpMyAdmin and been like that for two years now. I CAN access the DB from the web BUT NOT from the SSH command line.
  • Since you are getting denied. You should make sure that your root credentials through MySQL are set up correctly. The link has some good information on checking that.
  • Thanks. this is my work Server and I don't want to NOT be able to connect to SQL any longer. Whould that effect my access of root in the web? Since if I do that and I will lose the access to the server, then what would I do?
  • I am not sure if I understand what you mean. MySQL is just a program that runs on your server. Flushing/changing credentials for it will not affect your root credentials for other programs on your server or your access to your server as a whole. Just for security/data access reasons, MySQL maintains its own set of user credentials for people that access the DB. E.g. you may only want to give some non-root user readonly privileges.
  • When you run mysql u root -p, you are running a script that is trying to automatically log you into MySQL using whatever password it has saved. That password is not necessarily the correct one which appears to be the case here. You say PhpMyAdmin is able to connect, so check what password you have saved for root there and then set the root password for MySQL to match.