> -----Original Message----- > From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au] > Sent: Friday, October 15, 2010 5:54 PM > To: MY SQL Mailing list > Subject: Re: How do I GRANT SELECT to mysql.time_zone_name > for ANYONE?! > > > Any user can get into mysql, it's what they can do after that's the > > interesting part. > > Sorry, I'm not sure what you mean. Unless a username and host > combination matches a record in the mysql.user table, then the user > cannot log into the server. > > $ mysql -u random_user -p > Enter password: > ERROR 1045 (28000): Access denied for user > 'random_user'@'localhost' (using password: NO) > > $ mysql -u random_user -p > Enter password: > ERROR 1045 (28000): Access denied for user > 'random_user'@'localhost' (using password: YES)
Don't use the -p password prompt and you get into mysql... develo...@mypse:~$ mysql -u random_user Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2393 Server version: 5.0.51a-3ubuntu5.7 (Ubuntu) (random_u...@localhost) [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | +--------------------+ 2 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
