Sorry about the headline! I thought I was doing a search!
However since I have started this I might as well explain. We just closed our Yahoo web hosting acount and moved over to their Small Business hosting. In trying to install wordpress I find I am unable to grant my created mysql user privileges with the result that wordpress cannot be installed. The error I get when I try to grant privileges through phpmyadmin os access denied using password yes. Has anyone else had this problem and is there a fix?
did you login as user name yroot with whatever password you created when you installed phpmyadmin and then create a new user with a new password, new priveledges etc?
Thats what I did and it worked (like in the codex)
Thanks febwa1976. I am new at this! I'll try it and let you know if it worked. Can't see why I would get an error granting permissions to the main user though? Back in a jiffy!
okay, it won't let me create the user same error (access denied using password yes)
I also found the folloing error on my privilages page:
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!
Do you know how I do this?
I am also kind of new to this. I get the same warning message but it does not stop me adding new databases and WP installations etc. In fact today I installed 2.0 beta and it works perfectly.
Does this help http://www.tamba2.org.uk/wordpress/
Thanks again! will try right away and let you know. :)
Do you know how I could drop mysql altogether and start fresh? I think the sencond warning showed up after I repaired mysql from the manage mysql control panel. Maybe if I started over I could skip the problem? I have tried reload ing phpmyadmin, but to no effect.
Wait you are right! I am an idiot - I did not sign in as yroot, but as the user I created. Will let you know if I you have fixed this for me in a sec!
have you read this http://help.yahoo.com/help/us/webhosting/mysql/mysql-15.html
Thanks I was just about to ask you what I should do if i did not know my yroot password!
I owe you a drink after all of this! Will post on my progress in a sec!
The pull down menu only has my created user password, but not my yroot password. I cannot grant access privilages to my user through php my admin and I don't know my yroot password.
I think I need to start over. Do you by any chance know how I can delete mysql altogether?
Sorry, now you have me beat. Why don't you call Yahoo...they are open 24/24
You've actually helped quite a bit. As soo as I figure out how I can login as yroot I will post the answer here. Thanks for your help! I'm going to search around a bit then go to bed and try again tomrrow.
Yahoo does not offer mysql support by phone!
I don't like their service any more. They started out great 5 years ago, but I'm not so sure now. This plan was so attractive - I thought I'd try it despite my resevations. I'm sure that once I figure this out it will be fine. At least they won't be out of business tomorrow!
Right - I am haveing no luck. Can't sign into phpadmin as yroot (is this essential) can't grant permissions. Havn't heard back from mysql. Does any one know how to save me from the tyranny of typepad?
I found this doing a search for "yahoo mysql"
You can try to search more.
I actually saw that a couple of days ago. Beleive me I've searched google up and down. It is a common error message that appears for any number of things (even I have recieved it in a couple of different circumstances) But none apply to this granting of privileges problem. It is a phpmyadmin mysql and yahoo problem, but I was hoping someone here had had this problem and understood coding better and could tell me what I should be doing. Especially since no one at yahoo phpadmin or mysql have respoded (yet) It is the weekend and it is open source, but I'd rather learn how to use wordpress and donate than incur a monthly fee from typepad or use iblog and outsource the comment hosting.
good to see you have not given up
Have you tried creating phpmyadmin in a new directory.
If you do then go to 'www.yoursite.com/newdirectoryname'
(alternatively in file manager go to that sub directory and click on "index")
phpmyadmin will come up. often if you enter yroot in the user id then the password automatically comes up
I thought this was addressing exactly your user permission problems (quote from the link I've posted above)
In your config.php - the "host" needs to be "mysql"
but in your permissions for the wordpress user, the host needs to be "localhost" (if using phpMyAdmin, drop down on the "host" field and choose "Local").
This got things up and running smoothly.
You're right and that is how it is set. I followed all of the basic rules. I have the config.php file configured exactly right and I could load wordpress except for the fact that I am unable to grant privilages to the wordpress user. I cannot login as yroot and my user lacks the privileges to grant itself privileges. I am even unable to reload mysql in the phpmyadmin control panel. I am trearing my hair out. I don't think I ever had the yroot password, because the only passwrod I was asked to configure was for the adminitrator. I'm begining to think that the automatic set up Yahoo does when you activate your mysql database is the problem. The administrator (user) they asked me to name should have had full privleges. Someone recently said they had just set up a new yahoo sbs and while the had loaded and used wordpress successfully for their other sites on yahoo now could not get it to work. They think the problem is on Yahoo's side and I am begining to agree.
febwa1976 sorry I did not see your post. My password does not come up when I try to sign in using yroot. I really appreciate everyone's help here. The trouble is that I am out of time and have to solve this soon. I am hoping yahoo comes back soon or I'll be stuck with another solution.
what happens when you type the following in your webrowser? 'www.mysite.com/directory'? (directory being where your phpmyadmin is?
I get the cookies must be enabled after this point phpmyadmin login window.
When I do this I get the same thing. This is where you cannot login as yroot because you dont have the password?
Have you tried logging in as yroot with no password.... or "yes".
If this does not work you need and expert like here http://www.tamba2.org.uk/wordpress/phpmyadmin created by Podz.
I can just confirm that I now have several WP installations (including 2 beta) and (touch wood) they all still work... I did have to get used to mysql and phpmyadmin first though.
Thanks yet again febwa1976. You really have been great - I was about to completely give up on the whole thing and go with a lower tech solution, but if you can keep digging on my behalf like this I have no excuse for giving up! I had seen the phpmyadmin help, but have not gotten even as far as installing wordpress so I have nothing to access on that page. I have taken your second suggestion and emailed Yahoo (again) as soon as I hear something I will let you know (and anyone else who has or will experience this frustration). Hopefully yahoo can help solve this and I can move on to make mistakes in part two of this experiment - using worpress with next to no programming experience :-)
This topic has been closed to new replies.