- Install the MySQL Server (or MariaDB) on your computer.
- Configure the server with the appropriate storage engine.
In order to have transaction support by default, you must use a storage engine that supports
transactional tables, such as INNODB. In recent
versions of MySQL, this is the default storage
engine.
- Consider setting the sql-mode configuration parameter to get the appropriate
behavior of the MySQL server:
- When the STRICT_TRANS_TABLES mode is used, you will
get a -1406 error (data too long) when inserting a character
string that is too large for the target column. If you
don't use the STRICT_TRANS_TABLES mode, you get a -1265 warning (data
truncated) when the value is too large.
- Blank padding of fetched CHAR data can be controlled
with the PAD_CHAR_TO_FULL_LENGTH. You can use this parameter
to get CHAR values padded with blanks to their full length, but the
result of the SQL LENGTH() function will be different since trailing
blanks are significant for that function in MySQL.
- The mysqld process must be started to listen to
database client connections. See MySQL documentation for more details
about starting the database server process.
- Create a database user dedicated to your application, the application administrator. Connect as the MySQL root user and GRANT all privileges to this
user:
$ mysql -u root
...
mysql> grant all privileges on *.*
to 'myuser'@'localhost'
identified by 'password'
...
- Connect as the application administrator and create a MySQL database with the CREATE DATABASE
statement, and specify the character set to be
used for this database:
$ mysql -u mysuser
...
mysql> create database mydatabase
default character set utf8;
- Create the application tables.
Do not forget to convert Informix® data types to
MySQL data types. See Data type conversion table: Informix to MySQL for more details.