MySql Script changes

[ajay214]

I figured out how to access MySQL through myphpmyadmin, but I can't figure out where to go from there. I need to change a line of script as noted below (can anyone advise):

The script is written for MySQL version 4 or below.

It can run on MySQL 5, however you will need to turn of SQL strict mode.


Open your MySQL my.ini file and locate the following line:

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION"

And change to:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Save the file and restart MySQL.

[felgall]

You can't make that change on your hosting as it is shared with hundreds of other accounts. Either the mySQL is already configured that way by BlueHost or you will need to find something that works with the way that it is configured.