Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Can any one please let me know how to create new user and new db in MySQL? How to use mysqladmin in Mac OS X?

share|improve this question
    
Would you consider editing this question to make it more relevant to Mac OS X? General beginner mysql questions might get better answers at Stack Overflow. Also do read the FAQ so you are less likely to ask questions that read like "what book can I study to learn mysql on mac?" Cheers and welcome nevertheless! –  bmike Apr 18 '11 at 19:01

4 Answers 4

up vote 3 down vote accepted

If you are using the terminal client, generally you can do things like reset the root users password for mysql or create databases. A simple example can be found at the MySQL docs site, of which I will copy the highlights.

To create a new MySQL user:

  • Login to MySQL in Terminal:mysql -u username

  • In the prompt:CREATE USER 'admin'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';

  • If you want to create a database: create database name; is all you need to do

If you do decide to use mysqladmin, mysqladmin can create and drop databases, but it cannot create new users.

share|improve this answer
    
Thank you all it works. –  Sarbbottam Bandyopadhyay Apr 22 '11 at 14:45

You can use a GUI client, like Sequel Pro.

share|improve this answer

You have many choices, you can use MySQL Query browser , or PhpMyadmin.

enter image description here

share|improve this answer

Thanks everyone. I used the below commands to figure it out.

Sarbbottam-Bandyopadhyays-MacBook-Pro:bin sarbbottam$ mysql -u root

mysql> create database tutorialdb;

mysql> create user 'tutorialuser'@'localhost' identified by 'tutorialuser';

mysql> grant all on tutorialdb.* to 'tutorialuser'@'localhost';

mysql> exit

Bye

Sarbbottam-Bandyopadhyays-MacBook-Pro:bin sarbbottam$ mysql -u tutorialuser -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1532 Server version: 5.5.9 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.