The -e option with mysql allows you to run queries and would allow doing
user creation etc as well.
Aman Raheja
lakshmi.narasimharao@stripped wrote:
>Hi,
>
>
>
>
>I have to create user and database using script file.
>
>
>
>
>My requirements are given below.
>
>
>
>
>1. Login as root
>
>
>
>
>2. Execute the script file for database and user creation.
>
>
>
>
>
>3. Exit
>
>
>
>
>My script file should have
>
>
>
>
>mysql -u root
>
>create database mnms;
>
>user creation command
>
>
>
>
>The script file will be called in Win batch file and the same batch file
>will be executed.
>
>
>
>
> Thanks,
>
>Narasimha
>
