Thanks gerald, I totally forgot about the 'identified by' part. Doh! I had to tell mysql to bind to 127.0.0.1 also, which I had tried before but without assigning the password so combining the two steps certainly worked better than one at a time. :)
I got in and am now seeing a different error but I'll hammer on that awhile before I post; hopefully I'll figure it out. grant all on *.* to 'root'@'127.0.0.1' identified by 'somepassword' twig les wrote: In this episode I figured out that the problem is not stunnel or the remote connection. I simply cant log in with the command: mysql -u root -h 127.0.0.1 -p I just get a connection refused message. There should be a trick here that I'm missing if history is a lesson, but I'm a noob to mysql. Anyone know it? I can't use my other mere mortal account to log in either although both work fine if I say: mysql -u root -h localhost -p ===== ----------------------------------------------------------- If you give a man a fish, he can eat for a day If you bludgeon him to death, you can eat the fish yourself ----------------------------------------------------------- __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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
