Re: RE: Setting root password in mysql for windows

2002-08-16 Thread Victoria Reznichenko
Art, Thursday, August 15, 2002, 4:53:26 PM, you wrote: AF> Still could not get it to work so I uninstealled and reinstalled. Will use AF> the anonymous login etc util I figure out this security system. Is there a AF> document that explains the password system in laymans terms? You can find info

RE: Setting root password in mysql for windows

2002-08-15 Thread Art Fore
]] Sent: Thursday, August 15, 2002 4:08 AM To: [EMAIL PROTECTED] Subject: Re: Setting root password in mysql for windows Art, Thursday, August 15, 2002, 7:12:40 AM, you wrote: AF> Having a hard time coming to grips with the password setup for mysql in AF> windows. I follow the instructions

Re: Setting root password in mysql for windows

2002-08-15 Thread Victoria Reznichenko
Art, Thursday, August 15, 2002, 7:12:40 AM, you wrote: AF> Having a hard time coming to grips with the password setup for mysql in AF> windows. I follow the instructions below from the documentation. AF> C:\> C:\mysql\bin\mysql mysql AF> mysql> DELETE FROM user WHERE Host='localhost' AND User=''

Re: setting root password in mysql

2001-07-27 Thread Michael Collins
What version have you installed? I would think on Mac OS X you have 3.23.36? I will give it one last shot. First kill -9 the mysql processes (mysqladmin shutdown does not work on Mac OS), killing safe_mysql first. Add a -p when assigning the password, and I think that the password needs to be

Re: setting root password in mysql

2001-07-27 Thread [EMAIL PROTECTED]
Why not try sql to update it: mysql -u root mysql > use mysql; mysql> update user set password = password('new password') where user = 'root'; mysql> flush privileges; mysql> exit - Original Message - From: "Michael Nezi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 2