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 using wrong config?

Discussion in 'General Discussion' started by annamarie, Nov 3, 2008.

  1. annamarie

    annamarie Member

    Joined:
    Jul 31, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Last night I did a cpanel and apache upgrade on one of my cPanel servers

    PHP went from ver 4.4.7 to 4.4.9
    Apache went from 1.3.37 to 1.3.41
    MYSQL stayed at 4.1.22

    Since the update last night, only some sites PHP/MySQL functionality works.

    On some sites I get an access denied error:

    Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'wwsn'@'localhost' (using password: NO) in /home/wwsn/public_html/include/func/func.db.php on line 47
    Sorry, the shop is inaccessible temporarily. Please try again later.

    The thing is that the user above 'wwsn'@'localhost' is not correct. When I change it in the config file it ignores the entry and continues to use wwsn.

    Obviously it should be using an entry for username such as: wwsn_wwsn

    I have tried recreating the db user/password but it made no difference.

    When I make a change to the db user in the config file it ignores it.

    The strange thing is, another php/mysql cart on that server works fine:

    I have since brought php back to 4.4.7 to see if that was the problem, but it made no difference.

    At this point I'm unsure whether the problem is with apache, mysql or php

    I need some ideas of things to try, I'm starting to get desperate here.

    Thanks
     
  2. annamarie

    annamarie Member

    Joined:
    Jul 31, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    OK worked it out,

    It was the old style password in MySQL causing the issues. The sites that still worked had their original password, the ones that stopped had been updated at some stage.

    UPDATE mysql.user SET Password = OLD_PASSWORD('oldpass') WHERE Host =
    'localhost' AND User = 'user_user'

    FLUSH PRIVILEGES;

    Had to do the above code into phpMyAdmin for the non working users.

    Cheers!
     
Loading...

Share This Page