Send POST Request

POST is one of the HTTP methods which is used to send data to a server to create a resource. Programming languages provides various methods to send POST requests. A…

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…

JSON Encode and Decode

JSON is a text-based data format that commonly used to store or transmit data objects between systems. JSON consist of collection of name/value pairs and an ordered list of values.…

Generate MD5 Hash

MD5 is a cryptographic hash function that accepts a string of any length and returns a 128-bit fixed-length digest value, commonly represented as a sequence of 32 hexadecimal digits. MD5…