Page 1 of 2 1 2 LastLast
Results 1 to 15 of 19

Thread: Help-error

  1. #1
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0

    Lightbulb Help-error

    Warning: Acces denied for user:'root@localhost' (Using Password:NO) in drive c: bla bla bla on line 19...

    Possible Solution : You need to supply a password for the mysql script fot it to able to work.


    Ok.. begini.. ada masalah sedikit berkenaan mysql nih.. sepatutnya dah ok tapi ada eror macam kat atas nih.. apache php sumer ok jer but then mysql problem. seingat saya laa, dah ada acount root dengan password sekali..

    Kalau uninstall mysql pastuh install balik rasanya account root tu masih sama macam yang telah di set sebelum ni.

    Boleh tak bagi petinjuk macam mana nak buat..
    Help.. Im a Newbie..

  2. #2
    Join Date
    Sep 2001
    Location
    epox
    Posts
    432
    Rep Power
    233
    root mane ade password unless you have set one up (i think)
    or you can just create a new username and password
    Munzir + "/^[Hh](a)(z)\1\2[iI]$/"

  3. #3
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    Dah create user baru tapi tak jalan jugak.. sebab tu laa phpmyadmin pun tak boleh berfungsi..

  4. #4
    Join Date
    Sep 2001
    Location
    epox
    Posts
    432
    Rep Power
    233
    awak guna apa? Easyphp or compile sendiri?
    Munzir + "/^[Hh](a)(z)\1\2[iI]$/"

  5. #5
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    compile sendiri.. sumer dari tutorial http://internetmaster.com/installtut...all_apache.htm ..
    ikut step sumer dari sini.

    Easyphp dengan phptriad pun tak reti guna..
    Izzit lebih mudah menggunakan easyphp/phptriad berbanding yang compile senirik? saya tengah cuba nak guna phpbb dalam localhost saya.

  6. #6
    Join Date
    Jan 2003
    Location
    dreamland
    Posts
    240
    Rep Power
    213
    compile sendiri cammana tuh?
    kalau cam tuh server aper yg cik adik pakai...

    erm.. pasal error tu.. kalau tak silap ler...
    awk kena declare user name ngan password setiap kali nak buat connection ngan database... sbb u dah set masa install mysql tuh...

    pasal phptriad tu lak.. yes it more easier n more faster... cause everything had done for u... u just click here n there to run the php script...
    ^_^ <== stay happy

  7. #7
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    server apache..php..mysql..msqlcc..phpmyadmin..
    install satu-satu..

    sekarang nih jamned kat mysql laa.. password dah letak tapi still error macam tu.

    boleh ker nak set balik user root tu?

  8. #8
    Join Date
    Oct 2001
    Location
    Melbourne, AU
    Posts
    456
    Rep Power
    233
    [This was from another post I posted previously for someone else]

    Well, the only 2 things I can think of is reinstalling MySQL or resetting the root password.

    I would suggest you try reseting the password first, then if it doesn't work, you will have to reinstall MySQL. But, lets just hope that we can reset the mysql password. I'll try to make the steps as easy as possible to follow, but if you don't understand or have a question, just ask.

    1) Ensure that the mysql deamon is loaded. From the MySQL bin directory, (eg. C:\mysql\bin) try typing
    mysqladmin version
    if it there is no error, mysql is loaded correctly. If theres an error, type
    mysqld
    from the came path and try to do the above again. If you cannoth find your bin directory, try using windows search to find the file: mysqladmin.exe

    2) In the same directory as the mysqladmin.exe, type
    mysql -u root
    Some stuff should come out with 'mysql>'. If you see this, move on to step 3.

    3) Type the following in mysql>, with an <ENTER> after each line. Ignore lines with # infront of them, these are just comments.
    use mysql;
    delete from user where user='root';
    show fields from user;
    insert into user values ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0);
    # the above is all on one line.
    flush privileges;
    exit
    mysqladmin -u root -p shutdown
    mysqld

    That's it, this 'should' reset your mysql root password. When resetted, root has NO password. Now, just open up the config file for PhpMyAdmin and ensure that the user is 'root' and password is left blank.

    If there are any errors, post them here. Also include your version of mySQL. To find out your version, type mysqladmin version.

    Hope this helps, good luck!

  9. #9
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    ill try it..
    sekarang kat ofice . nanti balik cuba lagi..

    mysql-4.0.13-win,mysqlcc-0.9.2-win32,apache_2.0.46-win32-x86-no_src,phpMyAdmin-2.5.1-php....
    Last edited by hyllda; 26-09-2003 at 02:33 PM.

  10. #10
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    masih tak boleh jugak...

    guna command prompt tu kan?
    dah cuba satu but error yang keluar tetap sama.
    mula2 mysqladmin then mysqld.. tu yang start keluar eror:
    Acces denied for user root bla bla macam biasa..

    kalau install balik mysql boleh ke?
    bukan ke setting root tu masih sama (password)

  11. #11
    Join Date
    Oct 2001
    Location
    Melbourne, AU
    Posts
    456
    Rep Power
    233
    Awak cuba uninstall, lepas tu reinstall balik...

  12. #12
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    ok .. cuba lagi.. kalau takleh gak format terus hardisk tu..

    apa2 hal nanti saya inform lagi k.

    thanx.

  13. #13
    Join Date
    Sep 2001
    Location
    Satu Tempat diMalaysia
    Posts
    39
    Rep Power
    0
    Kalu nak try yang dah siap semua.. try PHPDev..

    Boleh tengok tutorialnya kat http://pn.lamanweb.net
    "Yang Sempurna Hanyalah A||ah Jua.."

    =========================
    http://mynuke.info/images/my/bmyn.gif || http://sayamuslim.com/images/smnet.gif
    MalaysianNukez || Komuniti SayaMuslim.com

  14. #14
    Join Date
    Jan 2003
    Location
    dreamland
    Posts
    240
    Rep Power
    213
    bapak ler... terus format tuhhhhhhh...
    dashyat nyer... macam tu jer settle kan masalah...
    hebat2.. hihihk...
    kan senang kalau dah tau nak format... hihihiik
    dah format tu.. kalau nak senang install mysql, php, apache
    pakai jer phptriad... senang...
    takyah setting aper2..
    good luck..
    ^_^ <== stay happy

  15. #15
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    11
    Rep Power
    0
    ill try my best.. dah beli hard disk baru..
    senang cerita.. hardisk lama dah serabut sangat..
    nak cuba lagi laa..
    eror still sama..

Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error
    By Aileen_g in forum Graphic Design
    Replies: 3
    Last Post: 08-05-2007, 03:06 PM
  2. Internal Server Error - ASP error
    By ladyheart2612 in forum Website Programming
    Replies: 0
    Last Post: 21-07-2005, 09:22 AM
  3. lot of error
    By prozone in forum Website Programming
    Replies: 2
    Last Post: 19-07-2005, 02:39 PM
  4. Weird PHP Error Msg
    By MENJ in forum Website Programming
    Replies: 1
    Last Post: 03-01-2005, 07:21 PM
  5. fatal error
    By joyce in forum Website Programming
    Replies: 2
    Last Post: 24-06-2002, 02:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112