Dear Nitesh,
forget about "my.conf" regarding the privilege system.
The correct syntax for granting access to all tables in "my_database"
(all rights, i. e. create, alter, drop, etc.) is
GRANT ALL ON my_database.* to some_user@localhost IDENTIFIED BY "secret"
[WITH GRANT OPTION]
For a superuser, you will need
GRANT ALL ON *.* to superuser@localhost IDENTIFIED BY "very_secret" WITH
GRANT OPTION
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Nitesh Garg" <[EMAIL PROTECTED]>
To: "Simon Green" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 3:56 PM
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
>
---------------------------------------------------------------------
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
