man pages for MySQL
Hello all, I'm just wondering, is there a man pages for MySQL? Like the one that we use in linux, executing *man ls*, for example, in the command line provides some detail on how to use the command. Is there a similar method for MySQL where we can execute *man grant*, for example? thanks... luie ___ What we do in life echoes in eternity. -- Maximus Desmus Meridius ___ __ www.edsamail.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: Access denied for user varlehti
LdS I'm experiencing the same problem. LdS But I sort of found a way around it (though I'm sure this is not really the right way). LdS When I remove the *password* for *root* and login again as root, I'm able to create new users using GRANT then flush priviliges. LdS Does this mean I have to indicate the password of root while using GRANT? LdS I can't find any info on this on the docs, please point us to where we can find the info for this. LdS thanks... Yes, using GRANT statment you can set password for user. Look at: http://www.mysql.com/doc/G/R/GRANT.html I still end up having a user with all privileges set to *N*, eventhough I created that user with mysql grant all privileges on dbase1.* to user1 identified by 'user1password'; What am I doing wrong? luie __ www.edsamail.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
can login only as root
hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using GRANT all to user1 identified by 'password';, but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm still unable to login as user1. hope somebody can shed some light on this. thanks in advance... luie __ www.edsamail.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