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…
MySQL
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
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…
Restore MySQL Database using mysql Client
The mysql client is a command-line tool which can be used to restore MySQL database or a collection of databases from the backup file that contains SQL statements. For example,…
Backup MySQL Database using mysqldump
If you don't want to lose data you need to make regular database backups. The mysqldump client is a command-line tool which allows to backup MySQL database or a collection…