Error 1045 and connection to MySQL database

Discussion in 'PHP' started by 30na, Jul 7, 2007.

0
  1. #1
    I get this error while try to access MySQL database using phpMyAdmin.

    Unable to establish connection to MySQL
    1045 : Access denied for user 'apache'@'localhost' (using password: NO)

    I don't know what is apache@localhost.

    The error is from server and hosting settings? or there is a php / SQL programming fault?

    Any idea is appreciated.
     
    30na, Jul 7, 2007 IP
  2. ansi

    ansi Well-Known Member

    Messages:
    1,483
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    100
    #2
    are you passing a username and password to it? doesnt seem so.

    
$conn = mysql_connect("localhost","username","password");
    PHP:
     
    ansi, Jul 7, 2007 IP
  3. dankenpo

    dankenpo Guest

    Messages:
    30
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Try Ansi's suggestion or login with a password, not guest, lol.
     
    dankenpo, Jul 8, 2007 IP
  4. SUSH

    SUSH Peon

    Messages:
    28
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Ask your host to change the value of $cfg['Servers'][$i]['user'] , and $cfg['Servers'][$i]['password'] in "config.inc.php" file.
    That's your base user when you use phpmyadmin.
    regards :)
     
    SUSH, Jul 8, 2007 IP
  5. 30na

    30na Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Please let me explain more.

    I'm trying to install a special modified version of CuteNews which uses PHP-MySQL.(The original version of CuteNews does not use MySQL.)

    The installation program needs the following parameters during setup process :

    Database Server...

    Database User Name ...

    Database Password...

    Database Name ...

    -----------------
    The problem is that on my hosting server there is a different setting than usual setting.

    There is not localhost , instead I see these settings via my control panel and phpMyadmin :

    Database Server = an IP address has been given via TCP/IP. (I name it IP1)

    (Instead of localhost via Unix.)

    User Name = username@anohter IP address. (I name it IP2)

    -----------------

    The server management system is Apache 2.

    Can any one help about what I should fill in ... places?
     
    30na, Jul 15, 2007 IP