Have you tried to Managing users in mysql 50

Asked By 10 points N/A Posted on -

Hello experts,

I am preparing a sever and database for my office.

Firstly I have to design for 50 users.

I am newbie and don’t know how to do this.

I have searched the term “managing users in MySQL 50” and found a variety of results.

I am looking for script with each explanation.

So I can make changes at any stage whenever I required.

Best Answer by Joseph A Reese
Answered By 0 points N/A #166574

Have you tried to Managing users in mysql 50


Hi Toles,

First store all the 50  usernames and password s in csv file.

e.g mike,mike123



Then write a  bash script to read the csv file  line by line and  then use the create user command to create mysql  users.





[ ! -f $INPUT ] && { echo "$INPUT file not found"; exit 99; }

while read username pwd


cmd1="CREATE user’$username’@’localhost’  identified by password ‘$pwd’;"

cmd2="GRANT ALL PRIVILEGES ON *.* TO '$username'@'localhost' ;“



$MYSQL -uroot -p -e "$SQL"



If you want to add or delete users you just need to update the csv file.


Hope this will help you. Best of luck

Best Answer
Best Answer
Answered By 0 points N/A #166576

Have you tried to Managing users in mysql 50




Though you are new and you don’t know how to start to design and manage a database which contain 50 users. For these you have to follow these steps:

1.   First, you have to setup a database to your Server and which operation system you use. Which you will find helpful at this following link: http://dev.mysql.com/doc/refman/5.6/en/installing.html

2.   Then after finishing the setup, you have to create a database which includes a user table by using CREATE queries. Which you can follow in this link: http://dev.mysql.com/doc/refman/5.6/en/creating-database.html

Create Database syntex

3.   After that you have to create a table using these kind of syntax. http://dev.mysql.com/doc/refman/5.6/en/creating-tables.html

Create Table syntex

4.   Then you have to load your data in the table using INSERT syntax. You will find the necessary syntax in here: http://dev.mysql.com/doc/refman/5.6/en/loading-tables.html

The easy way to load a lot data by creating a text file which contain a row for each of your user name. You will find helpful if you visit at this site too: http://www.w3schools.com/sql/default.asp



Good Luck.

Login/Register to Answer

Related Questions