Dear Nitesh,
if you run the MySQL server under root, that's not quite safe. Better
start it with "mysqld -u mysql".
Secondly, use GRANT ... to set rights for specific users. Check the
manual for GRANT.
Then, delete the (default) root user from mysql.user. Delete any other
user who can log in without a password. Make sure *before* that you can
log in with a correct / safe user/pw combination. And make sure some
user has the rights for *everything* (that's all "Y" in a mysql.user
row). After deleting those unsecure users, input FLUSH PRIVILEGES.
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: <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 3:20 PM
Subject: Regarding MySQL Passwords
> 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
>
>
---------------------------------------------------------------------
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
