This is the first time I've tried to use mysql/phpmyadmin and I'm having trouble. I'm using a geocites pro account and I got both installed and it set up a database call mysql and the user yroot. It asked me to make my own user name, which I did, and had me create a password as well. When I went into phpMyadmin I was able to create a new database but I cant really do anything with it. When I go into privileges I get this warning:
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!
Also the user that I set up for myself I think has limited access because it says: Global privileges: Usage Grant: No
Whenever I try and change anything in the privileges it gives me this message: #1044 - Access denied for user 'majestic15'@'localhost' to database 'mysql'
I've tried creating a new user and I can't. I also can't delete my current one because access is denied. I tried running mysql_fix_privilege_tables through a query window along with several variations of the code I found on some forums pertaining to this problem but when I hit go nothing happens. The page just sits there and nothing loads.
I'm not trying to do anything to crazy here, I just wanted to set up a tool called WordPress. This is their install page linked to the step I was at: http://codex.wordpress.org/Installing_WordPress#Step_2:_Create_the_Database_a nd_a_User
So I am completely at a loss. If any one can help please do!
I am running MySQL 4.1.14 with phpMyAdmin 2.6.3-pl1 through my yahoo.geocities account.
Also one more thing, I don't know if this means anything but when I go into the phpmyadmin dir on geocities and click index.php 2 frames. The top is blue and says my domain name and has a link to the Control Panel. The frame underneath of it is completely blank. I need to go back to the directory and open main.php(im assuming this is the page that is supposed to load in that blank frame), I need to open main.php to do anything. I've tried deleting and re-installing phpMyadmin a couple times, nothing seems to work.