3.5 Installing MySQL

The directory context for MySQL* SQL scripts is install-dir\DirXMLUtilities\jdbc\sql\mysql\install.

  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 table type you wish to use. For MySQL 3 or 4, use the scripts in subdirectory 3or4. For version 5.0.27 use the scripts in subdirectory 5.

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

    Don’t use a semicolon to terminate this statement.