Re: Regarding MySQL Passwords

2001-07-23 Thread Stefan Hinz
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 wi

Re: Regarding MySQL Passwords

2001-07-23 Thread Stefan Hinz
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 Passwor

RE: Regarding MySQL Passwords

2001-07-23 Thread Simon Green
-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

Re: Regarding MySQL Passwords

2001-07-23 Thread Nitesh Garg
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 passwor

RE: Regarding MySQL Passwords

2001-07-23 Thread Simon Green
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 passw