Re: MySQL on RH7.0 Alpha permissions don't work? Second try
John, Saturday, January 19, 2002, 12:18:26 AM, you wrote: JD I tried putting passwords on the grant statements, but I can't log in as a JD different user using a password -- it never authenticates. And as any other JD user than root it won't let me access any tables. Are you sure you are running a client with the right options? Foe example, if you set a password for user zuka and do something like mysql -uzuka buka it will never allow you to access database buka, because you have to supply the password: mysql -uzuka -pkuka buka or mysql -uzuka -p buka In the second case, client will ask you for the password from the console. JD Am I doing something wrong, Provide us with the examples of GRANT statements you use so we could provide you with more help. JD John Dudeck -- Egor Egorov [EMAIL PROTECTED] MySQL AB / Ensita.net For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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: MySQL on RH7.0 Alpha permissions don't work? Second try
When I try to use MySQL 3.23.38 on my RH7.0 Alpha system, the only way I can create and access tables is as a root user. BUT --- I don't need to be logged in as root to become root user, it will let anyone be root with the command: mysql -u root I tried granting permissions for users, but it makes no difference. I tried putting passwords on the grant statements, but I can't log in as a different user using a password -- it never authenticates. And as any other user than root it won't let me access any tables. Am I doing something wrong, is it configured wrong, or is it a problem with the particular RH7.0/Alpha/MySQL distribution? I admit I'm a MySQL newbie. John Dudeck Home: [EMAIL PROTECTED]Tel: 704-588-9891 Work: [EMAIL PROTECTED] Tel: 704-588-4300 -- Some of the things you learn don't jump right out at you. You have to think about them awhile. -- Norm Ducharme - 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
MySQL on RH7.0 Alpha permissions don't work?
When I try to use MySQL 3.23.38 on my RH7.0 Alpha system, the only way I can create and access tables is as a root user. BUT --- I don't need to be logged in as root to become root user, it will let anyone be root with the command: mysql -u root I tried granting permissions for users, but it makes no difference. I tried putting passwords on the grant statements, but I can't log in as a different user using a password -- it never authenticates. And as any other user than root it won't let me access any tables. Am I doing something wrong, is it configured wrong, or is it a problem with the particular RH7.0/Alpha/MySQL distribution? I admit I'm a MySQL newbie. John Dudeck Home: [EMAIL PROTECTED]Tel: 704-588-9891 Work: [EMAIL PROTECTED] Tel: 704-588-4300 -- Some of the things you learn don't jump right out at you. You have to think about them awhile. -- Norm Ducharme - 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