Can't edit MySQL Permissions or Update Priviledge Table

[ssolis5788]

Hi everyone,
I've never tried setting up MySQL before. I have Yahoo Web Hosting (they do not support MySQL questions...). I've set up a user name and password, but when I go to the "Priviledges" area there is a message that appears at the top:

Warning: Your privilege table structure seem 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!

I have no idea how to fix this, or how to run a script. And if I ignore this message and try to edit my permissions, I get this message:

Error

SQL query:
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , FILE , INDEX , ALTER ON * . * TO 'srsprinting'@'localhost';


MySQL said:
#1045 - Access denied for user 'srsprinting'@'localhost' (using password: YES)

Any help will be very much appreciated!

[Ajeh]

If they don't support MySQL questions ... what are you going to do when you have a MySQL problem?

Perhaps now is a good time to look into one of our Certified Hosting sites from the Hosting link at the top of your screen so you are not running into issues now or in the future ...

[ssolis5788]

Thanks. Was looking at the Hosting list, specifically "Host 99" - mainly because it says "Zen Cart Certified Hosting". Is there one hosting service you recommend over the others? Or is Host 99 a good one to go with?

[Ajeh]

We recommend all of our Certified Hosting sites ... those are the only ones that we list ...

Just look for one that is fast, affordable and reliable ... call them and chat with them about their performance or see if they have sites on their support sites that demonstrate their live sites so that you can see the speed of their servers ...

[ssolis5788]

Thanks again! I decided to go with Sashbox instead. They are a little more costly, but I think they will prove more reliable. They are setting up MySQL for me (yippee :-) ), and I can't wait to move everything over to Zen Cart!