The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql 5 and phpmyadmin

Discussion in 'Database Discussions' started by Secret Agent, Apr 9, 2006.

  1. Secret Agent

    Secret Agent Guest

    unfortunately that did not correct the problems
     
  2. Secret Agent

    Secret Agent Guest

    Unfortunately that did not correct the problems
     
  3. Secret Agent

    Secret Agent Guest

    I have accidently corrupted my phpmyadmin when trying to upgrade it after installing mysql5.

    How do I install phpmyadmin latest version?

    Also, mysql is not creating usernames in cpanel.
     
  4. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
  5. Secret Agent

    Secret Agent Guest

    I haven't done that, but how would I do this? Please provide what commands needed to run. I normally don't do this. Will this affect mysql 5?
     
  6. gorilla

    gorilla Well-Known Member

    Joined:
    Feb 3, 2004
    Messages:
    699
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney / Australia
  7. Secret Agent

    Secret Agent Guest

    unfortunately that did not correct the problems
     
  8. Secret Agent

    Secret Agent Guest

    I really would like this fixed, please help
     
  9. gorilla

    gorilla Well-Known Member

    Joined:
    Feb 3, 2004
    Messages:
    699
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney / Australia
    What version of phpmyadmin are you trying to run ?
    Just installed edge on a test box with dual core opteron and 64 bit OS CentOS4.3

    upgraded this to mysql 4.1.18 (not your mysql5) reinstalled perl5.8.7 and had to run
    /scripts/mysqlup --force
    and after that
    /scripts/upcp -- force
    for it to take effect , and phpmyadmin2.802 is running fine now (it didnt before the upcp --force)

    BTW : the new features of edge look realy promising :)
     
  10. Secret Agent

    Secret Agent Guest

    Latest stable of v5 and phpmyadmin. I accidently messed up phpmyadmin but I also need to correct v5 not creating mysql user accounts, then reinstall phpmyadmin
     
  11. Secret Agent

    Secret Agent Guest

    For sake of doing it, I tried /scripts/mysqlup --force and it did nothing, just return (carriage return). Not sure why.

    I would rather fix the mysql v5 issue and reinstall phpmyadmin.

    Any help here would be great
     
  12. gorilla

    gorilla Well-Known Member

    Joined:
    Feb 3, 2004
    Messages:
    699
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney / Australia
    cant help you there as am not brave enough to run mysql5 yet :D
    hopefully somebody else will come up with some more suggestions for you ;)
     
  13. Secret Agent

    Secret Agent Guest

    Ok, /scripts/upcp --force fixed phpmyadmin

    One more to go :D

    Still cannot create mysql users.

    On a side note, when attempting to reset mysql root password I get this:

    Results of your request
    Mysql password change failed!!
    A forced reset will now be attempted.
    Reset MySQL Password

    Waiting for mysql to restart.....Done
    Changing Password....Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....

    Restarting MySQL ....Starting MySQL[ OK ] Done

    The MySQL root password has been changed.
    Password changed for root to [thepasswordhere]
     
  14. Secret Agent

    Secret Agent Guest

    I'm really lost on this. Any help would be appreciated.
     
  15. Secret Agent

    Secret Agent Guest

    phpmyadmin permission is correct also

    drwx------ 7 cpanel cpanel 4.0K Apr 10 09:04 phpMyAdmin/
     
  16. Secret Agent

    Secret Agent Guest

    To clarify the phpmyadmin works in cpanel direct login but not via root , shows access denied
     
Loading...

Share This Page