I have removed all localhost user entries and all users should now be able to connect from any host. But when a user attempts to connect with a password they get the usual
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -----Original Message----- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 18:56 To: Schrodinger Subject: RE: Login Problems You should delete most others since there is one user identified by something like this "[EMAIL PROTECTED]" that won't let you connect using password. If you delete those users, you'll be able to connect without problem On Thu, 2003-12-11 at 14:55, Schrodinger wrote: > 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 > ...................................................................... -- ...................................................................... * _ _ ______ _____ _ .. * \ \ \ | ____| __ \ /\ | | || 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]
