Advanced Search

Return to Snippet

Revision: 914
at December 27, 2007 00:05 by yuconner
Updated Code 
mysql> CREATE DATABASE ''databasename''; 

mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''username''"@"''hostname''" IDENTIFIED BY "''password''";

mysql> FLUSH PRIVILEGES;

mysql> EXIT

Revision: 913
at August 21, 2006 01:09 by yuconner
Initial Code 
mysql> CREATE DATABASE ''databasename''; 

mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''username''"@"''hostname''" -> IDENTIFIED BY "''password''";

mysql> FLUSH PRIVILEGES;

mysql> EXIT
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
$ mysql -u ''adminusername'' -p

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Command line instructions to create a database in MySQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
database

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL