SQL adaptation guide For Oracle MySQL 5.x / Installation (Runtime Configuration) |
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.
mysql -u root ... mysql> grant all privileges on *.* to 'myuser'@'localhost' identified by 'password' ...
mysql -u mysuser ... mysql> create database mydatabase default character set utf8;