I am using Windows XP, connecting using Navicat to my database (MySQL) which is hosted on cpanel. My website was written using Perl. I have inserted the usernames and passwords into the table, though the "encryption " that is being used is 'unix crypt()' When I go to update it through the Navicat interface this is the error.
[SQL] update users set password = crypt('password ')

[Err] 1305 - FUNCTION databasename.cr ypt...

Update a MYSQL db password using crypt() technology on MYSQL connection.

I am looking to update a user table of passwords that were inserted without using crypt() on a Perl development project. I am using MYSQL to connect to the database and I need to update the passwords to be encrypted using the same method as the website process. How do I update?

I got this far: