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
RE: Regarding MySQL Passwords
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
RE: Regarding MySQL Passwords
Ok if you look at USERS you should find you have a user with no password or privileges. If you remove a user using grant you will leave there logon but with no privileges. So you will have to remove these manually. As for my.cnf is only needed if you would like to change thing from a standard set-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 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
Re: Regarding MySQL Passwords
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
Re: Regarding MySQL Passwords
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