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.
These two addresses are changed to the mysql directory and database directory in their corresponding phpstudy.ĥ: Then run cmd as an administrator, enter the MySQL directory, as shown in the figure to indicate success, execute as follows:Įrror 2 Reason: Exceeds the maximum packet allowed by mysqlĪdd to my.When I try to login to MySQL database, I get some error message like “error 1698 (28000)”. Reason for error 1: The MySQL version of phpstyudy is too low, the default is 5.5ġ: Back up the current database data, you can export the database file as a backup.Ģ: Backup the MySQL folder under PhpStudy in case the upgrade fails, and you can also use the old version of the databaseģ: Download MySQL5.6, unzip it, and put it in the MySQL folder under PhpStudyĤ: Copy a copy of my-default.ini, rename it to my.ini, open my.ini and add: Scenario: More than 100 M sql files are imported into the local database and an error is reported, the local environment, phpstudy, error 1294 - Invalid ON UPDATE clause for 'create_time' column, erMySQL server has gone away
0 kommentar(er)
