Advanced Search

Return to Snippet

Revision: 14587
at June 7, 2009 11:24 by stiobhart
Initial Code 
-- mySQL granting DB specific privileges:
GRANT ALL PRIVILEGES on DBNAME.* TO 'user'@'%' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;   

-- mySQL granting generic specific privileges:
GRANT ALL PRIVILEGES on *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
granting DB specific and general access priveleges from the CLI

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
mySQL - granting access permissions

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, database, user

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL