mysql

MySQL 8.0 Keywords and Reserved Words

2018-07-04 KENNETH 0

URL : https://dev.mysql.com/doc/refman/8.0/en/keywords.html   MySQL 8.0 Keywords and Reserved Words The following list shows the keywords and reserved words in MySQL 8.0, along with changes to individual words from version to version. Reserved keywords are marked with (R). In addition, _FILENAME is reserved. At some point, you might upgrade to a higher version, so it is a good idea to have a look at future reserved words, too. You can find these in the manuals that cover higher versions of MySQL. Most of the reserved words in the list are forbidden by standard SQL as column or table names (for example, GROUP). A few are reserved because MySQL needs them and uses a yacc parser.   A ACCESSIBLE (R) ACCOUNT ACTION ADD (R) ADMIN became nonreserved in 8.0.12 AFTER AGAINST AGGREGATE ALGORITHM ALL (R) ALTER (R) ALWAYS ANALYSE removed in 8.0.1 [ more… ]

Upgrading to MySQL 8.0 with Spatial Data

2018-07-02 KENNETH 0

Upgrading to MySQL 8.0 with Spatial Data The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all computations are Cartesian.… Source: Upgrading to MySQL 8.0 with Spatial Data

Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0

2018-06-29 KENNETH 0

Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0 There are many changes to spatial functions in MySQL 8.0: Old aliases for functions have been removed (after being deprecated in 5.7) Functions that don’t support geographic computations raise errors if called with geographic data in their arguments Many functions support geographic computations The first two are failing cases.… Source: Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0

No Image

Upgrading to MySQL 8.0? Here is what you need to know…

2018-06-25 KENNETH 0

Upgrading to MySQL 8.0? Here is what you need to know… In my previous blog post, I had described the steps to perform an in-place upgrade for upgrading from MySQL 5.7 to MySQL 8.0. In this blog post, I will discuss about the considerations that needs to be taken into account while upgrading to MySQL 8.0 The general in-place upgrade requirement is that MySQL 8.0 will understand the disk image produced by MySQL 5.7. … Source: Upgrading to MySQL 8.0? Here is what you need to know…

No Image

The connection_control plugin : Keeping brute force attack in check

2018-06-20 KENNETH 0

The connection_control plugin : Keeping brute force attack in check To quote book of all knowledge: In cryptography, a brute-force attack consists of an attacker trying many passwords or passphrases with the hope of eventually guessing correctly. The attacker systematically checks all possible passwords and passphrases until the correct one is found. … Source: The connection_control plugin : Keeping brute force attack in check