loading the timezone tables for mysql?

[jdandrus]

signing in as root via ssh, I am trying to run mysql_tzinfo_to sql /usr/share/zoneinfo | mysql -u root mysql

It fails on an Access Denied (password NO)

How do I get this to run?

[jeremya]

mysql requires password be provided for root user. I believe you just need to add -p into your mysql login command.

[jdandrus]

Actually, I called support today on it. Under plesk panel the admin user for mysql is not "root" but "admin" and the password is the password you use to access your plesk panel. The -p switch will prompt you for the password.

[jeremya]

ah, yes i believe this would be the case when Plesk is installed. Thanks for keep this post updated on the status :)