Re: mysql newbie

>how to set mysql to ask password to any user who try to enter ? If you are using a GUI like phpMyAdmin to administer the MySQL database, you can use it to prompt for a username and password such as would occur with a .htaccess/.htpasswd file combination. If you're on the command line - in Linux you can type mysql -p anywhere at the shell prompt (if you installed it to run in the background as a 'deamon') and it'll prompt you to type a username and a password. Take care to remember these as it's v.hard to recover when you loose these (I know 'cos I did it!) Good luck! Russ On Thu, 10 May 2001 11:45:32 +0700 andrie <andrie@ajk.its-sby.edu> wrote: > Hello php-db, > > a allready install mysql on apache and idont create any user yet > one question from me, when i enter mysql, i can enter it without > being asking any password(i'm not root). how to set mysql to ask > password to any user who try to enter ? > > -- > Best regards, > andrie mailto:andrie@ajk.its-sby.edu > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #-------------------------------------------------------#