At 6:43 PM +0100 1/27/02, Helmuth Lutz wrote: >I can not connect to mysql neither do some tests: > >[hlutz:/usr/local/mysql] hlutz% mysqladmin version >mysqladmin: connect to server at 'localhost' failed >error: 'Access denied for user: 'hlutz@localhost' (Using password: NO)'
Did you establish a password for the root user? [hlutz:/usr/local/mysql] hlutz% mysqladmin -u root -p version If you did not set a root password, just hit return. If you did, then enter that password. To connect to the mysql client program: mysql -u root -p If you did not set a root password, just hit return. If you did, then enter that password. Now use the grant command in mysql to set up a user to access mysql. You can set the root password using grant, or more easily using mysqladmin as follows: mysqladmin -u root password MyNewPassword NOTE: password in this is a command, MyNewPassword is what you want for your new password. (or you could use the SET Password SQL command, the old way) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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
