I have already created extra user accounts and none of them can connect once a password has been set.
-----Original Message----- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 18:45 To: Schrodinger Cc: 'MySQL General Lists' Subject: Re: Login Problems By default mySQL comes with a set of users that are allowed to login locally without password. You should create a normal-superuser account, and delete all others, and use this user to administer the rest of the data base and use it to create all others accounts that you might need. To create a new "full-blown" account: grant all privileges on *.* to your_user@"%" identified by 'password' with grant option; Best Regards! -- ...................................................................... * _ _ ______ _____ _ .. * \ \ \ | ____| __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * > > > | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | |____| | / ____ \|_| || www.superferreteria.com.ve * /_/_/ |______|_| /_/ \_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice ...................................................................... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
