Re: how to create a databse

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.24@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+unsubscribe@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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.