Nambahin dikit. Langkah ke 2 (skip grant tables) sebaiknya pake safe_mysqld (kadang2 di distro tertentu terbalik mysqld_safe).
On 5/27/05, Rist. Andy Nugroho <[EMAIL PROTECTED]> wrote: > > > > Hi Linuxers, > > Gue abis nginstall Mambo nehh ceritanya > > waktu konfigure Mambo perasaan gak ngganti2 password root mysql koq =3D > > perasaan > > tapi mengapa abis itu gue gak bisa masuk user root mysql ku > > saya udah coba remove paket mysql di linux gue, abis itu gue install =3D > > lagi mysql nya > > tapi koq tetep mysql nya minta password root yg lama yahh, jadi gue =3D > > tetep gak bisa masuk mysql nya > > berikut isi file /etc/passwd nya: > > > > root:3cJfk875k/uYI:0:0:root:/root:/bin/bash > > daemon:*:1:1:daemon:/usr/sbin:/bin/sh > > bin:*:2:2:bin:/bin:/bin/sh > > sys:*:3:3:sys:/dev:/bin/sh > > sync:*:4:100:sync:/bin:/bin/sync > > man:*:6:100:man:/var/cache/man:/bin/sh > > lp:*:7:7:lp:/var/spool/lpd:/bin/sh > > nobody:*:65534:65534:nobody:/home:/bin/sh > > user:Yy7wYXMQYHKjw:1000:1000:Debian User,,,:/home/user:/bin/bash > > sshd:!:100:65534::/var/run/sshd:/bin/false > > telnetd:!:101:101::/usr/lib/telnetd:/bin/false > > ftp:!:102:102::/home/ftp:/bin/false > > mysql:!:103:103:MySQL Server:/var/lib/mysql:/bin/false > > > > Gimana yahh ? mohon bantuannya > > ++ cobain begini : > 1. matiin mysqld dulu. > 2. start mysqld dgn option --skip-grant-tables > 3. set password baru utk root dgn, # mysqladmin -u root password > 'mynewpassword' > 4. jangan lupa flush privilegesnya, # mysqladmin -h localhost.localdomain > flush-privileges > 5. stop mysqld, trus start mysqld secara normal. > > lebih lengkapnya : > http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Resetting_permission > s.html > moga bisa bantu. > > salam, > -rianu- > > > -- > Unsubscribe: kirim email kosong ke [EMAIL PROTECTED] > Arsip, FAQ, dan info milis di http://linux.or.id/milis > Tidak bisa posting? Baca: > http://linux.or.id/problemmilis > http://linux.or.id/tatatertibmilis > > -- http://auliansyah.is-a-geek.org -- Unsubscribe: kirim email kosong ke [EMAIL PROTECTED] Arsip, FAQ, dan info milis di http://linux.or.id/milis Tidak bisa posting? Baca: http://linux.or.id/problemmilis http://linux.or.id/tatatertibmilis
