WordPress.org

Ready to get started?Download WordPress

Forums

php admin yahoo access denied using password yes (35 posts)

  1. Preposterous
    Member
    Posted 8 years ago #


  2. Preposterous
    Member
    Posted 8 years ago #

    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?

  3. febwa1976
    Member
    Posted 8 years ago #

    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)

    http://codex.wordpress.org/Installing_WordPress#Using_phpMyAdmin

  4. Preposterous
    Member
    Posted 8 years ago #

    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!

  5. Preposterous
    Member
    Posted 8 years ago #

    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?

  6. febwa1976
    Member
    Posted 8 years ago #

    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/

  7. Preposterous
    Member
    Posted 8 years ago #

    Thanks again! will try right away and let you know. :)

  8. Preposterous
    Member
    Posted 8 years ago #

    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.

  9. Preposterous
    Member
    Posted 8 years ago #

    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!

  10. febwa1976
    Member
    Posted 8 years ago #

  11. Preposterous
    Member
    Posted 8 years ago #

    Thanks I was just about to ask you what I should do if i did not know my yroot password!

  12. febwa1976
    Member
    Posted 8 years ago #

  13. Preposterous
    Member
    Posted 8 years ago #

    I owe you a drink after all of this! Will post on my progress in a sec!

  14. Preposterous
    Member
    Posted 8 years ago #

    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.

  15. Preposterous
    Member
    Posted 8 years ago #

    I think I need to start over. Do you by any chance know how I can delete mysql altogether?

  16. febwa1976
    Member
    Posted 8 years ago #

    Sorry, now you have me beat. Why don't you call Yahoo...they are open 24/24

  17. Preposterous
    Member
    Posted 8 years ago #

    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.

  18. Preposterous
    Member
    Posted 8 years ago #

    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!

  19. Preposterous
    Member
    Posted 8 years ago #

    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?

  20. moshu
    Member
    Posted 8 years ago #

    I found this doing a search for "yahoo mysql"
    http://wordpress.org/support/topic/32385
    You can try to search more.

  21. Preposterous
    Member
    Posted 8 years ago #

    Thanks Moshu!

    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.

  22. febwa1976
    Member
    Posted 8 years ago #

    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

  23. moshu
    Member
    Posted 8 years ago #

    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.

  24. Preposterous
    Member
    Posted 8 years ago #

    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.

  25. Preposterous
    Member
    Posted 8 years ago #

    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.

  26. febwa1976
    Member
    Posted 8 years ago #

    what happens when you type the following in your webrowser? 'www.mysite.com/directory'? (directory being where your phpmyadmin is?

  27. Preposterous
    Member
    Posted 8 years ago #

    I get the cookies must be enabled after this point phpmyadmin login window.

  28. febwa1976
    Member
    Posted 8 years ago #

    Good.

    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.

  29. febwa1976
    Member
    Posted 8 years ago #

  30. Preposterous
    Member
    Posted 8 years ago #

    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 :-)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.