Hi !

I am trying to create a user in mysql through shell script. How to create it using shell script.Thanks in advance.

Bye
Prasanthi

#!/bin/bash

mysql --user=root mysql
GRANT ALL PRIVILEGES ON *.* TO $1@localhost;

./script.sh john

will create the mysql user, john without a password and only will accept local connections for that user name. if you'd like it to be more specific, let me know.