>> >> > Yes you're right! you can safely delete those - but first make some > changes... as it seems you've set up root password only for : > [EMAIL PROTECTED] - right? that's why you can't login using > localhost (mysql without -h host option assumes -h localhost and if you > only changed password for [EMAIL PROTECTED] then password for > [EMAIL PROTECTED] is probably still the same default *no password* :) > In that case to login with password you changed try (I assume mysql > runs without --skip-netowrking) following instead: > mysql -h my.machine.name.xxx -u root -p
thanks i already have that. fot both my.machine.xxx and localhost.. logging in as root wasn't the issue. those where the first passwords i did set up. i just freaked out for a minute there realizing that typing -u some-stuff will get you in even if you can't do anything inside. i did try select - not even that... and no, you can't see test - at least not on this sql - 5.0.* thanks again... -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
