How to create new mysql user/db in Mac OS X?

Question

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?

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

ConstantineK · Accepted Answer · 2022-07-25T15:40:12.393

13

If you are using the terminal client, generally you can do things like reset the root users password for mysql or create databases.

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.

edited Jul 25 '22 at 15:40

answered Apr 18 '11 at 17:10

ConstantineK

5,622
1
18
23

The first link is broken – Andrew Jul 23 '22 at 15:29
Apologies but it looks like that's going to be permanent, they no longer appear to have a selfsame site. – ConstantineK Jul 25 '22 at 15:39

score 2 · Answer 2 · answered Apr 18 '11 at 15:46

2

You can use a GUI client, like Sequel Pro.

answered Apr 18 '11 at 15:46

Davide Gualano

804
2
12
21

This is a bad answer - you should at least tell people how to do it with the program you're suggesting – The Onin Jan 28 '18 at 05:44

score 2 · Answer 3 · edited Sep 07 '16 at 17:12

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>

score 0 · Answer 4 · answered Apr 18 '11 at 16:18

0

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

enter image description here

answered Apr 18 '11 at 16:18

Am1rr3zA

13,009
14
65
88

score 0 · Answer 5 · answered Sep 07 '16 at 16:40

0

Try, introduce complete path to mysql:

Go to Terminal:

$ /usr/local/mysql/bin/mysql -u user

I hope help you!

answered Sep 07 '16 at 16:40

Jose Carlos Ramos Carmenates

101
2

On a vanilla system this will lead to `-bash: /usr/local/mysql/bin/mysql: No such file or directory-bash: /usr/local/mysql/bin/mysqlx: No such file or directory` – nohillside Sep 07 '16 at 17:08
this is on MAC. – Jose Carlos Ramos Carmenates Sep 07 '16 at 17:14
Yes. On a standard OS X installation, there is no `mysql` in `/usr/local`. – nohillside Sep 07 '16 at 17:16
Please It's work for me. Check this https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/ – Jose Carlos Ramos Carmenates Sep 07 '16 at 17:33
I'm sure it does, *after* a manual installation of MySQL (which is the part missing in your answer) – nohillside Sep 07 '16 at 17:44

How to create new mysql user/db in Mac OS X?

5 Answers5