fixed it. thankyou so much.
On 6 January 2013 04:33, Subodh Nijsure <subodh.nijs...@gmail.com> wrote: > On Ubuntu following works - > > Run: > sudo dpkg-reconfigure mysql-server-5.1 > > Now this will allow you set password for 'root' user. > > Les assume you want to create user joe and create database joedb , want to > assign password 'joepassword' > > Now login to the mysql as: > > > mysql -u root -p'root-password' > > select PASSWORD('joepassword'); > -- Note down string that is displayed here. > drop user joe@localhost; > grant all privileges on *.* to joe@localhost with grant option; > create user 'joe'@'localhost' IDENTIFIED BY PASSWORD '.......'; > -- Enter password you got by running select password('joedb') > command where ... is > > create database joedb character set utf8; > > Now you can login as: > > mysql -u joe -p'joepassword' -D joedb > > Now you can use joe, joedb, joepassword in your settings file to use mysql > as backend. > > -Subodh > > > > On Sat, Jan 5, 2013 at 7:41 AM, ANKIT BAGARIA <mr.bagaria...@gmail.com>wrote: > >> I have installed mysql as databse and i am not able to create a database. >> I know the command for it but dont know where to type it. Django tutorials >> tell to run the command in database interactive. But I am not able to >> figure out how to to so. Please help me in creating a database. >> Thankyou. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/django-users/-/rXKRbmFTED0J. >> To post to this group, send email to django-users@googlegroups.com. >> To unsubscribe from this group, send email to >> django-users+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/django-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- ANKIT BAGARIA -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.