Let’s say you have your WordPress server set up (running on IP address 192.168.1.100) to access a MySQL database named wordpressdb on the MySQL server with user wpadmin.

If you manage multiple MySQL servers and want a simplified means of logging in, see how to use the new passwordless authentication feature.

MariaDB® Corporation, the company behind the fastest growing open source database, today announced that MariaDB Server replaces MySQL as the default in Debian 9, a popular Linux distribution.

The following discussion first discusses how MySQL handles improper data by default, and then covers the changes that occur when you enable the various SQL modes that affect data handling.