Ok if you look at USERS you should find you have a user with no password or
privileges.
If you remove a user using grant you will leave there logon but with no
privileges.
So you will have to remove these manually.
As for my.cnf is only needed if you would like to change thing from a
standard set-up, e.g. move the data directory to another drive.
Simon
-----Original Message-----
From: Nitesh Garg [mailto:[EMAIL PROTECTED]]
Sent: 23 July 2001 14:56
To: Simon Green; [EMAIL PROTECTED]
Subject: Re: Regarding MySQL Passwords
Simon Green wrote:
> When you set up the sever to start with it has no passwords or user's set.
> What you have to do now is use the Grant command. But of course set the
> super/root user password first.
> It is well worth reading all the doc's on security.
> If you use -p and there is no password set it will look for a password and
> so fail (at the moment).
>
> Simon
>
> -----Original Message-----
> From: Nitesh Garg [mailto:[EMAIL PROTECTED]]
> Sent: 23 July 2001 14:21
> To: [EMAIL PROTECTED]
> Subject: Regarding MySQL Passwords
> Importance: High
>
> Hello,
> I have just installed the MySQL RPMs , downloaded from
> ur web site. I have installed it on my machine. But I am facing few
> problems.
>
> 1. As u have specified in documentation that, if I am able to connect
> to server without giving password that can be troublesome. While i am
> login as root, I give command mysql -u root. I get straight away
> connected to server. How should i overcome this. I don't have the file
> "my.cnf" on my m/c. its not installed.
>
> 2. Secondly, when I try to login to the server from some other m/c ,
> still it doesn't prompt for password. But if I give "-p" option any
> specify password, as in user table, it says access denied. Without
> giving -p it gets connected.
>
> Kindly help as soon as possible. I will be
> thankful for this act of kindness.
>
> Your's Sincerely,
>
> Nitesh Garg
>
> [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hello,
first of all thanx for a quick reply.
I have specified the password in the user table using
1. update user set Password=PASSWORD('password') where user='User_name';
Earlier i executed
2. grant all priviliges on Nitesh to user_name@'IPAddress'
Similarly i have specified
password for root on server in the user table. In case of user, when i login
without password , it actually has no privileges. And secondly what about
"my.conf"
Thanx
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
