Thanks mas wili masalah login udah OK,
nah kalo yg satunya, saya udah nyoba dan hasilnya : mysql> select host, user, password from mysql.user; +-----------+------+------------------+ | host | user | password | +-----------+------+------------------+ | localhost | root | 18bb126c40addb84 | +-----------+------+------------------+ 1 row in set (0.00 sec) trus saya keluar, dan nyoba make anonim [EMAIL PROTECTED] tanon]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 to server version: 4.0.18-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> koq masih bisa ya ?! ada saran ?! trims, -- yanu On Wed, 2006-05-17 at 11:03, Willy Sudiarto Raharjo wrote: > > Adakah diantara teman2 yg tahu cara ngilangin user anonim di > > MySQL-server-4.0.18-0. Soalnya saya udah nyoba tutorial default saat > > instalasi > > use mysql; > delete from user where password = ''; // hapus semua account yg tidak punya > password (tapi buat 1 account dulu yg sudah ada passwordnya, biar bisa masuk > lagi hehehe) > > > > To do so, start the server, then issue the following commands: > > /usr/bin/mysqladmin -u root password 'new-password' > > /usr1/bin/mysqladmin -u root -h apache password 'new-password' > > -- > > > > saat login $su > > > > trus coba akses #mysql > > > > kok malah > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > > NO) > > > > sebelmnya diakses make SU bisa > > > coba pakai mysql -u root -p > nanti diminta password. Masukkan password yang tadi dibuat > -- > Willy Sudiarto Raharjo > Registered Linux User : 336579 > Web : http://www.informatix.or.id/willy/ > Blog : http://willysr.blogspot.com > -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis
