Change User Password in MySQL

The SET PASSWORD statement allows to change the password for user in the MySQL server. Provided password is interpreteted as a cleartext string. Password is passed to the authentication plugin…

AES Encryption and Decryption in MySQL

MySQL allows to encrypt and decrypt data using the official AES (Advanced Encryption Standard) algorithm. The AES_ENCRYPT() function encrypts the string with the specified key and returns the encrypted data…

Create User in MySQL

The CREATE USER statement allows to create a new user in the MySQL server. Users are stored in the mysql.user system table. A newly created user has no privileges. The…

Show Users in MySQL

When managing a database is often need to get a list of users which are used to connect to the MySQL server. MySQL provides statements which allows to show databases…
Change Default Authentication Plugin in MySQL

Change Default Authentication Plugin in MySQL

In MySQL 8.0, the default authentication plugin is caching_sha2_password rather than mysql_native_password. If application get errors related with caching_sha2_password plugin, it is possible that connector does not support this plugin…