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.

PhpMyAdmin and Mysql

Discussion in 'Database Discussions' started by adm.iuri, Sep 9, 2004.

  1. adm.iuri

    adm.iuri Member

    Joined:
    Dec 26, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    someplace
    Hello everybody,

    I have a problem:

    PhpMyAdmin doesn't work from the link in the WHM (http://xxxxx:2086/3rdparty/phpMyAdmin/index.php)

    It shows the message:

    -----
    Welcome to phpMyAdmin 2.5.6
    Wrong username/password. Access denied.
    -----

    I enable Mysql Logs in /etc/my.cnf and didn't see any message about this error.

    I think that the problem is in the configuration of PhpMyAdmin.

    Anyone had this problem?
     
  2. Sabaote

    Sabaote Well-Known Member

    Joined:
    Dec 19, 2003
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Ribeirao Preto, Brazil
    Try set a Root Password for MySQL!
     
  3. adm.iuri

    adm.iuri Member

    Joined:
    Dec 26, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    someplace
    Passwork is already setted.


    I try this script:

    #!/usr/bin/perl

    use DBI;
    use DBD::mysql;

    my $dbh = DBI->connect("dbi:mysql:mysql:localhost", "root", "**********") or die;


    and it works perfectly.

    The problem is in phpMyAdmin

    Thanks for your response.
     
  4. zentity

    zentity Well-Known Member

    Joined:
    Jun 16, 2004
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    Try resetting the MySQL root password in whm (even if you enter the same one) That was good advice.

    Failing that you could also try

    mv /usr/local/cpanel/3rdparty/phpMyAdmin /usr/local/cpanel/3rdparty/phpMyAdmin.bak

    /scripts/upcp --force

    That should fix the issue.
     
  5. adm.iuri

    adm.iuri Member

    Joined:
    Dec 26, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    someplace
    thanks for your response.

    I tried what you wrote, but it had fail.
     
  6. adm.iuri

    adm.iuri Member

    Joined:
    Dec 26, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    someplace
    Hum,

    after the upgrade, the following message appears:

    040910 17:45:16 11 Connect Access denied for user: 'root@localhost' (Using password: YES)
    040910 17:45:17 12 Connect Access denied for user: 'root@localhost' (Using password: YES)

    I try to reset the mysql password by whm, but without success
     
  7. Hoojx

    Hoojx Active Member

    Joined:
    Jun 5, 2003
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    6
    Which WHM/cPanel version are you using?
     
  8. Tas

    Tas Member

    Joined:
    Nov 18, 2003
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Eventually got it working by removing the " from /root/.my.cnf

    remove the " from your .my.cnf file so "root" --> root and "password" --> password

    Hope this helps
     
  9. screege

    screege Well-Known Member

    Joined:
    Aug 11, 2004
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    Thank you

    You really helped me out, nobody was able to do that untill I saw tour message, works smooth.

    =O)
     
  10. Jedia

    Jedia Well-Known Member

    Joined:
    Mar 18, 2004
    Messages:
    200
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    CN
    Nice, thanks :cool:
     
  11. cPanelBilly

    cPanelBilly Guest

    removing " from there can cause a security issue. Better idea is to update to current.
     
  12. pipo

    pipo Member

    Joined:
    Nov 4, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Quebec, Canada
    root directory

    I don't think that this is a security risk to remove the " in the /root/.my.cnf because the directory /root is protected in permission. Only root should can access /root.
     
Loading...

Share This Page