List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:October 16 2010 1:06am
Subject:RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!
View as plain text  
 

> -----Original Message-----
> From: Jesper Wisborg Krogh [mailto:jesper@stripped] 
> 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...

developer@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_user@localhost) [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
+--------------------+
2 rows in set (0.00 sec)


Thread
How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Daevid Vincent15 Oct
  • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Johnny Withers15 Oct
    • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Suresh Kuna15 Oct
      • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Jesper Wisborg Krogh15 Oct
        • RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Daevid Vincent15 Oct
          • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Jesper Wisborg Krogh16 Oct
            • RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Daevid Vincent16 Oct