How to Make Mysql database as a Multi user server

Question

0.00/5 (No votes)

See more:

hello

i am having two remote MySQL database servers ,one with 5.5 community edition and win2012 server OS on storage server and another with 5.1 community edition and winxp os on a p4 machine. for the both i have around 200+ users accessing data through winform applications.

now we are planning to upgrade our server on p4 machine and bought a higher end machine with win7,xeon processor configuration and we installed MySQL 5.5 community edition server.

the problem is MySQL server is not allowing to connect to it unless we manually add each user. adding 200+ users is tedious job and the no of users are increasing every day. is there any solution for this so that i can make my MySQL server as multiuser without adding each user manually.

thanks in advance

Posted 1-Dec-14 17:54pm

vikaskallidantheyil

Updated 1-Dec-14 18:19pm

v4

Add a Solution

Comments

Mehdi Gholam 2-Dec-14 0:53am

Managing users is part of the DBA's job.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2014-12-01T22:39:00

Solution 1

You can create a script of exiting user on the old DB:

SQL

select
	CONCAT_WS(' ', 'create user', '''', User, '''', 'identified by password', '''', Password, ''';')
from mysql.user

Than run that script on the new DB...

http://dev.mysql.com/doc/refman/5.1/en/create-user.html[^]

Posted 1-Dec-14 22:39pm

Kornfeld Eliyahu Peter