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
---------------------------------------------------------------------
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
