how to make new user account....is admin account not root account?

Asked by Ganga Jeena

i have downloaded desktop version of ubuntu 9 .10 and tried making new user accounts but was denied permission. How do I tackel it? How to make new user accounts ....Can I have the Root password please.....!!

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Connector/J Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Stonepost (shawnmsaling) said :
#1

You placed the question under MySQL Connector/J - are you refering to a new user for Ubuntu or for MySQL?
Ubuntu -
      - You would use "sudo adduser username"
      - When it asks for your password, enter in YOUR password as Sudo gives you Super User powers, never full ROOT.
      - If you want to use ROOT ***** and I strictly recommend it not be used, or setup***** then you would do the following
            - "sudo password"
            - It will ask for YOUR password like above
            - Then you will be prompted to enter the ROOT password 2 times.
     - To activate the ROOT account use:
         "sudo passwd -l root"
All the above can be accessed here - _https://help.ubuntu.com/9.10/serverguide/C/user-management.html

MySQL -
     - Connector/J is just that, a form of opening the doorway to MySQL Database.
     - To create a user in MySQL you and do this many ways: Web App, CLI, GUI (i.e. MySQL Admin).

         - CLI
             - Open a Terminal and type in mysql -u [username] -p
                     * this would be the username you set up at time of installation of MySQL
             - You would use the "CREATE USER" as the example bellow:
                   mysql> CREATE USER [username] IDENTIFIED BY (PASSWORD) '[password]';
                      * if you want the password in plain text omit PASSWORD from the entry, other wise it will be hashed (MD5).

      - To Enable ROOT in MySQL:
              - I would suggest checking this MySQl Reference - _http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

I hope this covers what you are looking for.

And there you have it, how to create a user and enable root in both Ubuntu and MySQL.

Revision history for this message
Stonepost (shawnmsaling) said :
#2

Ganga, did this answer your question?

Can you help with this problem?

Provide an answer of your own, or ask Ganga Jeena for more information if necessary.

To post a message you must log in.