The value can be any datatype supported by the MySQL database. Log in to the MySQL database. Assign values to the variables using a "SET" statementSET @fruit1='apple', @fruit2='orange', @fruit3 ...

The lesson here is that a MySQL user doesn’t need file permissions, or administrative command functions. When you over-assign roles to a system user, it’s just asking for disaster. Prior to ...