Hint:
The user and host combinations for allowed MySQL connections are stored in a table called mysql. You can access this table by issuing: $ mysql -u root mysql> use mysql; mysql> SELECT user, host, password FROM user; If you have set up a root password then issue: $ mysql -u root -ppassword where password is the required password, or better issue: $ mysql -u root -p and enter the password. That way other users cannot sniff it with a command like ps aux. One thing you might find useful is that the mysql user table can accept wildcard character such as %. So entering a '%' in the user and host fields allows connections from any user from host. This behavior is disabled by default for security reasons. Neil from which MySQL is allowed On Mon, 13 May 2002, Kevin Queen wrote: > OK, I just finally got MySQL installed and I can't make ANYTHING work. when > I try to run "mysqladmin -u root -h Death -p password 'somepassword'" I get > an Enter Password prompt, I have never told it a root password and it won't > accept the system root password. Then if I try to connect to the server > from another machine I get "host <ip_address> is not allowed to connect to > this MySQL server". Any help on these issues and pointers to > administration/configuration help would be appreciated. I do have the > manual pdf, but 700+ pages is a lot to read and I can't find these issues in > the manual by searching. > > Thanks, > Kevin Q. > > > --------------------------------------------------------------------- > 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
