This works for the most part, I can view table data, create new databases, etc. In an attempt to get around the tunnelling issue, I granted access to so that I can connect directly.
A friend suggested that's probably just bad error handling, but it seems strange given the significant difference between localhost and 127.0.0.1 in MySQL. When I started looking into it more I noticed that the error was reporting the server as "localhost", instead of "127.0.0.1" which I entered in Sequel Pro. I've reset the password with mysqladmin just for sanity's sake, that's definitely not the issue. The problem isn't specific to Sequel Pro or just myself either, I get the same error when connecting through MySQL Workbench as do others in the office. I'm able to log in from the terminal when connected directly to the server through SSH, just not through an SSH tunnel. MySQL said: Access denied for user (using password: YES) Unable to connect to host 127.0.0.1 because access was denied.ĭouble-check your username and password and ensure that access from your current location is permitted. All of sudden though, with no changes I can think of, the server has started rejecting the log in attempt from Sequel Pro with the error: You can solve the problem by following the above steps.For months I've been connecting to the MySQL instance running on our local test server through an SSH tunnel without any issues. It is easier to solve the Navicat for MySQL 1045 error in Linux. Refresh the MySQL permission-related table: mysql> flushprivileges Log on to mysql:/usr/local/mysql/bin/mysql-u root mysqlĬhange PASSWORD: mysql> UPDATEuserSETpassword = PASSWORD ('newpswd ') WHEREuser = 'root' If the location of mysqld_safe is different, you can use the find command to find it. Run:/usr/local/mysql/bin/mysqld_safe - skip-grant-tables>/dev/null 2> & 1 & If you want to find a solution suitable for Windows, you can view the article: how to solve the Navicat for MySQL 1045 error. The following method applies to Linux systems.
If you do not want to reinstall it, you need to retrieve the password or reset the password. The simplest solution is to uninstall and reinstall the MySQL database, however, the disadvantage is that the information in the database will be lost. When you log on to the MySQL database and see Error 1045, the user name or password you entered is denied access. If you do not want to reinstall it, you need to retrieve the password or reset the password.ġ045-Access denied for user 'root' 'localhost' (using password: YES) When connecting to the MySQL database, Navicat will inevitably encounter a 1045 error, mainly because the user's user name or password is incorrect and access is denied. How to solve the Navicat for MySQL 1045 error in Linux
0 kommentar(er)
