3.5 Installing MySQL

The directory context for MySQL SQL scripts is found in the install-dir\DirXMLUtilities\jdbc\sql\mysql\install directory on Windows or install-dir/lib/dirxml/rules/jdbc/sql/mysql/install directory on UNIX /Linux platforms.

  1. From a MySQL client, such as mysql, log in as root user or another user with administrative privileges.

    For example, from the command line, execute

    mysql -u root -p

    By default, the root user has no password.

  2. Execute the installation script 1_install_innodb.sql or 1_install_myisam.sql, depending upon which engine type you wish to use. For version 5.5 and later, use the scripts in subdirectory 5.

    For example: mysql> \. c:\1_install_innodb.sql

    Don’t use a semicolon to terminate this statement.