Loaded MySQL 4.1.10a Essential on a Windows 2003 Server due to a request to host a website integrated w/MySQL.
Created the database & loaded the sql dump but ran into an error attempting to create user. I was told by the developer that I would have to use OLD_PASSWORD since the database was created on 4.0. I attempted to RTFM but with only an hour of exposure to MySQL I thought that someone might be able to save a newbie some time.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.10a-nt
mysql> USE mysql;
mysql> GRANT USAGE ON * . * TO 'vinyl_table'@'localhost' IDENTIFIED BY OLD_PASSWORD('WonerPoodle') WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
ERROR 1064 (42000): 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 'OLD_PASSWORD('WonderPoodle') WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0' at line 1