- Connecting to MySQL

Connecting to MySQL

The connection properties that are unique to MySQL are the URL, Driver, User ID, and Password. They must be exactly as follows:

• • URL - jdbc:mysql://localhost/wowsys73 (where localhost is your IP address and wowsys73 is your database)

NOTE: wowsys73 can be replaced by any existing MYSQL schema, it becomes the default schema if not specified. Previous versions of WOW specified libraries such as PJUSER64, PJUSER70.

• • JDBC Driver - MySQL (com.mysql.jdbc.Driver)

  • User ID - xxx (This must be a valid MYSQL user profile)

  • Password - yyy (This must be a valid password for the user profile)

NOTE: User ID and Password are case sensitive in MySQL.

Here is a sample MySQL connection:

If you want different properties for User ID and Password, you can create users using the MYSQL administrator tools.

Please consult the MySQL Reference Manual for details on how to create new user accounts.

MySQL Manuals: http://dev.mysql.com/doc/

MYSQL case sensitive table/database schema names:

On Linux and Unix systems with MYSQL installed, databases and tables may be case sensitive by default. For example MYSCHEMA.TABLE1 may be stored different from myschema.table1 in the underlying operating system. WOW converts all SQL to uppercase before sending to the database so your MYSQL server must be set to IGNORE case sensitivity.

Details: There is a configuration in MySQL that can be set to ignore casing. http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html

You need to change the my.ini or my.cnf configuration file and set the config value of: lower_case_table_names=1

Update as of 6.28/2019:

WOW development on MYSQL 8 and above has discovered that Oracle changed the DEFAULT character. If you are using MYSQL 8+ and are having problems connecting, add the following to your connection string EITHER in your web.xml or WOW connection:

Here is an example connection string: jdbc:mysql://localhost/

WOWSYS76?characterEncoding=latin1

It is the "characterEncoding=latin1" that may need to be added.