I had to reset the plugin field of each entry to a blank string. Look at the plugin field into the er table: MariaDB > SELECT user, plugin FROM user (not necessary at all, read my edits at the end of the post) Reboot MySQL/MariaDB using -skip-grant-tables (search for tutorials on the web). MariaDB > sudo service mysql mysql -uroot -pnewPassĮRROR 1698 (28000): Access denied for user have found a solution that is as strange as the problem itself. MariaDB > update user set password=PASSWORD("newPass") where user='root' Type '\c' to clear the current input statement. Server version: 10.0.20-MariaDB-0ubuntu0.15.04.1 (Ubuntu)Ĭopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. + Terminé 1 sudo mysqld_safe mysql -u root Remove all -log-error configuration options for -syslog to take effect.ġ50802 19:07:25 mysqld_safe Logging to '/var/log/mysql/error.log'.ġ50802 19:07:25 mysqld_safe A mysqld process already exists 150802 19:07:25 mysqld_safe Can't log to error log and syslog at the same time. See that: sudo mysqld_safe -skip-grant-tables & I tried the usual method to reset the root password (skip grant tables mounting and reset the passord) but it seems it doesn't works. I tried via a terminal, same problem, and it is because my password is wrong. It said: "Cannot log in to the MySQL server". Today, I wanted to create a database in PMA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |