neiljstandley
asked on
MySQL Newbie question about OLD_PASSWORD
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;
Database changed
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('WonderPoodl e') WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0' at line 1
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;
Database changed
mysql> GRANT USAGE ON * . * TO 'vinyl_table'@'localhost' IDENTIFIED BY OLD_PASSWORD('WonerPoodle'
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('WonderPoodl
mysql>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I know it was an easy 500 but it was urgent for me. Unhappy customers are no fun.