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