Atomicorp

I updated PHP and MYSQL to the bleeding channel.

No issues with the upgrade and all forums are working (PHP and MYSQL)

However I found my horde webmail and pop email thye passwords are all seemingly defaulted.

So I reset and it still does not work.

I thought something in SQL, so I clicked privledges and I get this...

User overview
Warning: Your privilege table structure seems to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

So I try that:
mysql_fix_privilege_tables
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, stored procedures, or
more secure passwords in 4.1

Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option

I tried that specifying user id, pass, etc and still no good.

Seems everything else is working but I can't login to webmail or download mail by pop. Even the forums can look at and add posts..

Any idea how to fix it?

Well it seems everything is running perfectly except mail.

I can't login to any mail name.

If I use plesk and spam training, I can see mail is still coming in.

How can I reset the passwords?

I tried everything I can't login POP or webmail

Thanks!

David