1) Set root user to use ‘mysql_native_password ‘ plugin Now, let’s see how our Support Engineers fix this error. It checks if the user is connecting via UNIX socket and then compares the username.įor example, a user authenticate to the Ubuntu system as test, so MySQL won’t trust the user when he login as root user, because this user is different from the system user test. In other words, this plugin doesn’t care for password. This plugin allows the user to use Operating System credentials when connecting to the database. Mysql> SELECT User, Host, plugin FROM er Some systems like Ubuntu don’t use root password, instead Mysql root account is configured to use the auth_socket or unix_socket plugin for authentication. ‘error 1698’ Mysql error – Causes and solutionsįirst, let’s see the main cause of this error identified by our Support Engineers during our debugging process. In our experience managing websites, majority of such complaints are raised by customers on a Ubuntu machine. Website owners face this error when MySQL disallows the root user to access the database.įor instance, users see the complete error message like this: ERROR 1698 (28000): Access denied for user addition to that, website owners will not be able to connect to the database via a terminal, PHPmyadmin or MySQL client. ‘error 1698’ MySQL error – What this means?īefore we move on to the reasons, let’s first get an idea of MySQL error ‘ error 1698′. Today, we’ll discuss the reason for this error and how our Server Supported Engineers fix it. So, what’s the reason behind this? And, how to resolve this? Website owners often face this error when they access the MySQL database as root user. That was a recent support ticket received at our Server Support department where we resolve support queries for web hosts. When I try to login to MySQL database, I get some error message like “error 1698 (28000)”.
0 kommentar(er)
