Forum Sementara Putera.com

Bersama kita perkemaskan forum ini sementara forum asal dalam pemulihan.

Forum putera dah kembali. Masalah sudah berjaya diselesaikan. Sila lawati http://forum.putera.com/tanya


    access denied to phpMyadmin

    Share

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    access denied to phpMyadmin

    Post by anysha on Mon Jun 15, 2009 5:03 pm

    aiyer..knape eh??tulung2..nk gune myadmin kua error cani..n for ur info saya ade set password tuk database saya nih

    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
    Error

    MySQL said: Documentation
    #1045 - Access denied for user 'root'@'localhost' (using password: NO)
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    p/s:ngengs~ xgeti nk load gmbar error dlm nih(harap membantu, maaf ats kesengalan ini rabbit )

    ayoi
    Moderators
    Moderators

    Gender : Male Number of posts : 1090
    Age : 86
    Registration date : 04/03/2009

    Re: access denied to phpMyadmin

    Post by ayoi on Mon Jun 15, 2009 8:55 pm

    bukak http://localhost/phpmyadmin/setup kat browser then setup lah username dan password

    kalau tak ingat .. root password kena change root password by command line. yang ni google sebab lupa password hehe...

    punca masalah
    #1045 - Access denied for user 'root'@'localhost' (using password: NO)
    dia nak access tanpa password tapi masa install mysql root tu letak password kan.....

    jadi letak lah password root masa install mysql tadi.


    --------------------------------------------
    ku mencuba survey
    Don't break my heart

    meteora11
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 53
    Location : atas bumi bawah langit
    Registration date : 04/05/2009

    Re: access denied to phpMyadmin

    Post by meteora11 on Mon Jun 15, 2009 9:03 pm

    pg kt file config ko...
    jngn set password..

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 10:50 am

    **ayoi

    http://localhost/phpmyadmin/setup
    link broken la bro Evil or Very Mad


    **meteora11
    lanjut sikit lagi boleh?cane tuh??
    Rolling Eyes

    OngBok
    Moderators
    Moderators

    Gender : Male Number of posts : 729
    Location : Dungun Terengganu
    Job/hobbies : Pesara JKR
    Registration date : 18/02/2009

    Re: access denied to phpMyadmin

    Post by OngBok on Tue Jun 16, 2009 11:53 am

    awak install cara mana phpmyadmin?
    install dari pakej Xampp, wamp atau install berasingan.?

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 12:21 pm

    install dari wammp5

    Hansz
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 184
    Age : 29
    Location : Kuala Kangsar, Perak
    Job/hobbies : PHP, Design, Developing, Composing, Computer
    Registration date : 01/06/2009

    Re: access denied to phpMyadmin

    Post by Hansz on Tue Jun 16, 2009 12:59 pm

    anysha wrote:
    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
    Error

    MySQL said: Documentation
    #1045 - Access denied for user 'root'@'localhost' (using password: NO)
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    Lor... kalau dah NO, mana ada password pada database tu :p

    Kosongkan ruang password tu, atau cuba guna koding yang selalu saya guna dalam localhost ni :

    Code:
    $open = "localhost";
    $dbuser = "root";
    $dbpass = "";
    $dbname = "Nama_Database";
    mysql_connect($open, $dbuser, $dbpass) or die(mysql_error());
    mysql_select_db($dbname) or die(mysql_error());

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 1:28 pm

    Lor... kalau dah NO, mana ada password pada database tu :p

    Kosongkan ruang password tu, atau cuba guna koding yang selalu saya guna dalam localhost ni :

    Code:
    $open = "localhost";
    $dbuser = "root";
    $dbpass = "";
    $dbname = "Nama_Database";
    mysql_connect($open, $dbuser, $dbpass) or die(mysql_error());
    mysql_select_db($dbname) or die(mysql_error());
    [/quote]



    aish..tapi ble gune console nak access dB gune password saya.
    actually system saya dh bole run pon dgn dB yg dibuat dlm console tuh juga connect
    ke dB dgn password saya ($dbpass="passwordku");

    Hansz
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 184
    Age : 29
    Location : Kuala Kangsar, Perak
    Job/hobbies : PHP, Design, Developing, Composing, Computer
    Registration date : 01/06/2009

    Re: access denied to phpMyadmin

    Post by Hansz on Tue Jun 16, 2009 1:36 pm

    Okay lah tu, try and error... Smile

    note : ni bakal php programmer ni... Lepas ni belajar nak hack script plak tau... Twisted Evil

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 1:47 pm

    haha!programmer la sgt..lps nih xmaen sgt kot!masuk kolej maen dgn network plak.
    tapi atleast taw la jgk skit2..
    hack script??waahh!!mmg ditunggu2 ney..sape nk offer ajar ney??

    ek!!prob kt ats nih cane??

    OngBok
    Moderators
    Moderators

    Gender : Male Number of posts : 729
    Location : Dungun Terengganu
    Job/hobbies : Pesara JKR
    Registration date : 18/02/2009

    Re: access denied to phpMyadmin

    Post by OngBok on Tue Jun 16, 2009 1:54 pm

    cuba masuk url;
    http://localhost/phpmyadmin/

    boleh masuk ker tidak.

    Hansz
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 184
    Age : 29
    Location : Kuala Kangsar, Perak
    Job/hobbies : PHP, Design, Developing, Composing, Computer
    Registration date : 01/06/2009

    Re: access denied to phpMyadmin

    Post by Hansz on Tue Jun 16, 2009 1:56 pm

    Lor... ingat dah solved dah...

    Dah test $dbpass=""; ?? Boleh run ker tak...?

    Hansz
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 184
    Age : 29
    Location : Kuala Kangsar, Perak
    Job/hobbies : PHP, Design, Developing, Composing, Computer
    Registration date : 01/06/2009

    Re: access denied to phpMyadmin

    Post by Hansz on Tue Jun 16, 2009 1:59 pm

    meteora11 wrote:pg kt file config ko...
    jngn set password..

    Guna solution ni... Lagipun, tu cuma localhost jer kan... bukan web server :p

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 2:00 pm

    OngBok wrote:cuba masuk url;
    http://localhost/phpmyadmin/

    boleh masuk ker tidak.

    xbuley laa...nk upload gambar x geti plak nk tunjuk errornye

    Hansz
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 184
    Age : 29
    Location : Kuala Kangsar, Perak
    Job/hobbies : PHP, Design, Developing, Composing, Computer
    Registration date : 01/06/2009

    Re: access denied to phpMyadmin

    Post by Hansz on Tue Jun 16, 2009 2:03 pm

    anysha wrote:
    OngBok wrote:cuba masuk url;
    http://localhost/phpmyadmin/

    boleh masuk ker tidak.

    xbuley laa...nk upload gambar x geti plak nk tunjuk errornye

    Dia ni pun 1 kedekut betul Evil or Very Mad

    Bak lah coding nya... Cuma tunjuk Error jer, macam mana nak solved...

    Meh paste kat sini codingnya... Kedekut betul lah... Evil or Very Mad

    Ni nak marah ni Mad

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 2:08 pm

    Rolling Eyes Rolling Eyes
    nk tunjuk kod ape abg hanz yer??
    dh nk bkk myadmin dlm wamp jer xle..
    nk tunjuk ape ek?ek? Cool

    Hansz
    Ahli Baharu
    Ahli Baharu

    Gender : Male Number of posts : 184
    Age : 29
    Location : Kuala Kangsar, Perak
    Job/hobbies : PHP, Design, Developing, Composing, Computer
    Registration date : 01/06/2009

    Re: access denied to phpMyadmin

    Post by Hansz on Tue Jun 16, 2009 2:09 pm

    Lor... sat...

    Search "config.inc.php" dalam folder phpmyadmin...

    Dah jumpa, buka file tu, paste kat sini coding lebih kurang macam ni...

    /* Server: localhost [1] */
    $i++;
    $cfg['Servers'][$i]['verbose'] = 'localhost';
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['port'] = '';
    $cfg['Servers'][$i]['socket'] = '';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '';
    $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

    /* End of servers configuration *//

    OngBok
    Moderators
    Moderators

    Gender : Male Number of posts : 729
    Location : Dungun Terengganu
    Job/hobbies : Pesara JKR
    Registration date : 18/02/2009

    Re: access denied to phpMyadmin

    Post by OngBok on Tue Jun 16, 2009 2:22 pm

    kalau tak dapat jugak bukak fail config.inc.php. Fail nie ada dalam C:\wamp\apps\phpmyadmin x.x.x

    Pinda kod berikut;

    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '123456x'; //masukkan password yang awak dah set
    $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

    //bukan password database tapi password untuk user root.
    // ok . cuba dulu.

    anysha
    Ahli Baharu
    Ahli Baharu

    Number of posts : 19
    Registration date : 08/06/2009

    Re: access denied to phpMyadmin

    Post by anysha on Tue Jun 16, 2009 5:27 pm

    cheers Basketball lol!
    hollaa!!!
    berjaya!!!
    mmg best la korang2 ney! cayunk la kt korg sume!!
    thanks a lot guys!!

    Sponsored content

    Re: access denied to phpMyadmin

    Post by Sponsored content Today at 8:27 am


      Current date/time is Mon Dec 05, 2016 8:27 am