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 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…
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…
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…
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…
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,…
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…