Pak Jiddat - Innovative Software Services

Read: In the name of thy Lord Who createth, Createth man from a clot. Read: And thy Lord is the Most Bounteous, Who teacheth by the pen, Teacheth man that which he knew not. Nay, but verily man is rebellious That he thinketh himself independent!. Lo! unto thy Lord is the return. (Sura Alalaq 96:8)

MariaDB/MySQL user password not being set

Created On: 24 Nov, 2017: 10:33:25 - Tags : database management


If you have problems with setting the user password on MariaDB or MySql, for example you set the user password and are not able to login with the new password, then the problem may be caused because the database user is configured to use the wrong authentication plugin. For example unix_socket plugin instead of the default authentication scheme.

The solution is to set the plugin field in the user table of the mysql database to empty value. This will cause the MySQL/MariaDB server to authenticate the database user with the default authentication scheme.

Related Articles

  1. Sorting a MySQL string column as a number
  2. MySQL server out of resources
  3. MySQL Tuner
  4. Create backup of Mongo Db database
  5. Deleting a Mongo Db database
  6. Restoring a database backup in Plesk
  7. How to login to MySQL server as root user on Plesk
  8. List all databases for Postgresql
  9. Solution for mysql header mismatch error
  10. Backing up and Restoring MongoDB data
  11. Removing Replication in MongoDb
  12. Exporting Mysql database data in CSV format using Mysql Work Bench