I've just finished installing a test server running Debian Sarge, and till now it looks like all is working. (I did the The Perfect Setup - Debian Sarge (3.1) from http://www.howtoforge.com/perfect_setup_debian_sarge
I'm now trying some sites that have 'special' settings.
One of the sites is using MySQL, but for some reason I can not create the database on the new Debian server.
This is how the query looks:
CREATE TABLE `google` (
`ID` int(10) NOT NULL auto_increment,
`ip_address` varchar(255) default NULL,
UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=171 ;
The error I get is:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=171' at line 5
The strange thing is that this query is working fine on the Fedora RC4 server.
The MySQL on the Fedora server is: MySQL 4.1.16 running on localhost as root@localhost
The MySQL on the Debian server is: MySQL 4.0.24_Debian-10sarge2-log running on localhost as root@localhost
I guess they must have changed some things in the 4.1.16 version.
Is there anyone here who can see what is wrong with the SQL query, and how to fix it to make it work with MySQL 4.0.24_Debian-10sarge2?
Or.. is there an easy way to update the MySQL 4.0.24 to a newer version?