Re: Mysql Root User - Gabriel-Dumitrel MOSCALU - com.mysql.lists.win32

5 messages in com.mysql.lists.win32Re: Mysql Root User

From	Sent On	Attachments
Michael G. Tracey	20 May 2003 16:57
Gabriel-Dumitrel MOSCALU	20 May 2003 18:25
Michael G. Tracey	20 May 2003 19:23
Gabriel-Dumitrel MOSCALU	20 May 2003 22:05
leshaussebons	21 May 2003 09:55

Subject:	Re: Mysql Root User
From:	Gabriel-Dumitrel MOSCALU (gabr...@ferma.fr)
Date:	05/20/2003 10:05:46 PM
List:	com.mysql.lists.win32

Hi Michael,

By default, the root password is not set, and as you could see in the MySQL documentation, it is storongly recommended to set a root password after you install MySQL.....

In the meanwhile, if you do not set any password for root, it will not allow connections using "-p" as parameters.

And also, it is recommended to restrain the domain where from the root user can login to specific machines, which you trust, by changing the "host" field (which by default is blank, to the IP adress of the trusted machine) in the "mysql.user" table.

Good Luck Gabriel

----- Original Message ----- From: "Michael G. Tracey" <drkn...@excite.com> To: <gabr...@ferma.fr>; <drkn...@excite.com>; <win...@lists.mysql.com> Sent: Wednesday, May 21, 2003 4:24 AM Subject: Re: Mysql Root User

Changed to Directory C:\mysql\bin\

Tried it, this was the result.

ERROR 1045: Access denied for user: 'root@127.0.0.1' (Using password: YES

However, I kept trying thinking I had mispelled the password.

I quite by accident hit enter at the password prompt and it let me in.

SELECT USER(); Resulted in:

Root@localhost

1 row in set (0.00 sec)

Does this mean the password was never added for root?

Michael G. Tracey

--- On Tue 05/20, Gabriel-Dumitrel MOSCALU < gabr...@ferma.fr > wrote:

From: Gabriel-Dumitrel MOSCALU [mailto: gabr...@ferma.fr]

To: drkn...@excite.com, win...@lists.mysql.com

Date: Wed, 21 May 2003 03:25:30 +0200

Subject: Re: Mysql Root User

Hi Michael, Would you try: C:\mysql\bin\mysql -u

root -h localhost -p See if it works and get back to me. Crdlt Gabriel ----- Original Message ----- From: "Michael G. Tracey" <drkn...@excite.com> To: <win...@lists.mysql.com> Sent: Wednesday, May 21, 2003 1:57 AM Subject: Mysql Root User > > I have Mysql 4.1 running as service on Win2k. > > I cannot access the user database. > > I have changed my root password. > > I followed the instructions from the manual below. > > > > ;C:\> C:\mysql\bin\mysql mysql > > ;mysql> DELETE FROM user WHERE Host='localhost' AND User=''; > > ;mysql> QUIT > > ;C:\> C:\mysql\bin\mysqladmin reload > > ;C:\> C:\mysql\bin\mysqladmin -u root password your_password > > > > I tried to invoke first line "mysql mysql". Access denied. > > I was able to delete from user. > > I specified the Password. > > I

even called Mysqladmin and my password worked for

it. > > > > After that, i'm stumped. > > > > I can't access the user database. I thought "user root" was the superuser here. > > > > What am I doing wrong? Since I deleted the localhost and anonymous user should I not be actually logged in as User Root? > > > > > > > > Michael G. Tracey > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > -- > MySQL Windows Mailing List > For list archives: http://lists.mysql.com/win32 > To unsubscribe: http://lists.mysql.com/win32?unsub=gabr...@ferma.fr > >