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..

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]$/"

Dah create user baru tapi tak jalan jugak.. sebab tu laa phpmyadmin pun tak boleh berfungsi..

awak guna apa? Easyphp or compile sendiri?

__________________
Munzir + "/^[Hh](a)(z)\1\2[iI]$/"

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.

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

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?

[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!

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....

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)

Awak cuba uninstall, lepas tu reinstall balik...

ok .. cuba lagi.. kalau takleh gak format terus hardisk tu..

apa2 hal nanti saya inform lagi k.

thanx.

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

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

ill try my best.. dah beli hard disk baru..
senang cerita.. hardisk lama dah serabut sangat..
nak cuba lagi laa..
eror still sama..