Creating mysql users via linux command line?

Question

I'm working on a python script to setup servers quickly and it basically has a list of commands I want to execute on the linux commandline.

I can install all the software I need but not sure how to create a mysql user solely via command line? I can I can go into the mysql shell and do it but is there a way to do it solely from the linux shell(once the user is created I can do all the database setup remotely with a python script)?

Michael Berkowski · Accepted Answer · 2013-06-27 14:06:33Z

33

You do it with the same query you'd use in the client, but execute it on the command line with the -e flag:

mysql -uroot -prootpw -e "GRANT ALL PRIVILEGES ON dbname.* TO username@hostname IDENTIFIED BY 'userpassword'"

Or pipe in the command

echo "GRANT ALL PRIVILEGES ON dbname.* TO username@hostname IDENTIFIED BY 'userpassword'" | mysql -uroot -prootpw

edited Jun 27, 2013 at 14:06

answered Feb 13, 2012 at 15:58

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Oleg Mikheev Over a year ago

But it requires a running MySQL doesn't it?

Michael Berkowski Over a year ago

@Qwe Any modification to a MySQL database including simply setting the root password requires a running MySQL instance.

Collectives™ on Stack Overflow

Creating mysql users via linux command line?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related