How To Create Multiple or More MYSQL Server

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

How To Create Multiple or More MYSQL Server

Postby dakmuo » 04. December 2009 13:00

Hi..

Im new with apache and i love to using xampp.

Now i waas create Virtual Host for Multiple Website, and its DONE Perfect!

But ive little problem, that how to create/build/install multiple or more MYSQL Server / PHPMYADMIN?

I Hope some one can help me about this..

Im pretty sure lot professional reading this post...

Thanks :)
dakmuo
 
Posts: 7
Joined: 04. December 2009 12:54
Location: Johor Bharu, Malaysia

Re: How To Create Multiple or More MYSQL Server

Postby Knight1 » 05. December 2009 09:46

Hi dakmuo,
do I understand you correctly that you want to give multiple User their own Database to use?
For that you don't need to install multiple Servers. You just need to add different Databases und User-Accounts.
This added User-Accounts get the only and exclusively access to the Database they can use.
So the Users can Login to the Database-Server via their PHP-Scripts and phpMyAdmin and see only their own DB's.

How to add new Databases and User-Accounts with their corresponding rights see the Documentation of phpMyadmin or the MySQL-Manual.


Kai aka Knight1
Image
User avatar
Knight1
 
Posts: 310
Joined: 18. October 2003 10:03
Location: Trier
Operating System: Windows 7 Ultimate x64

Re: How To Create Multiple or More MYSQL Server

Postby dakmuo » 05. December 2009 19:54

Hi Knight1..

Thanks for sharing..

But, i dont find anything instruction on your given link..

Can u show more details to me? Im realy newbies about MYSQL, phpmyadmin and etc.

For your information.. Im using XAMPP on Windows Xp Professional.

Hope u can help me with some shotscreen, instruction and etc. :)

Thanks...
dakmuo
 
Posts: 7
Joined: 04. December 2009 12:54
Location: Johor Bharu, Malaysia

Re: How To Create Multiple or More MYSQL Server

Postby Knight1 » 05. December 2009 20:14

Look: http://wiki.phpmyadmin.net/pma/user_management

Otherwise click through phpMyAdmin for more overview.
The links are mostly named self-explanatory.


Kai aka Knight1
Image
User avatar
Knight1
 
Posts: 310
Joined: 18. October 2003 10:03
Location: Trier
Operating System: Windows 7 Ultimate x64

Re: How To Create Multiple or More MYSQL Server

Postby dakmuo » 05. December 2009 21:01

Hi Knight1,

right now, i'm able to create a database per user which means 1 user with 1 database.

i need a multiple database per user which is 1 user can have more than 1 database that he/she capable to create by themselves. but the problem is, user somehow can view another users' database if i give them access to add new database for themselves..

what / which privileges setting that i need to add to user?

Thanks :)
dakmuo
 
Posts: 7
Joined: 04. December 2009 12:54
Location: Johor Bharu, Malaysia

Re: How To Create Multiple or More MYSQL Server

Postby Knight1 » 05. December 2009 21:07

Why don't do you give the user the rights for the second database the user has to have the rights for as you made with the other database?


Kai aka Knight1
Image
User avatar
Knight1
 
Posts: 310
Joined: 18. October 2003 10:03
Location: Trier
Operating System: Windows 7 Ultimate x64

Re: How To Create Multiple or More MYSQL Server

Postby dakmuo » 05. December 2009 21:15

Hi Knight1.


When i Add New User..

i choose Create database with same name and grant all privileges.

and what i get is.. 1 user with 1 database as user name.

And.. i dont know how to give rigth to user, to create more database on user account.

When i give user right to create database, he/she can see another user database. i dont want this happen..

maybe in theory, i have the basic idea, but curently i have no idea on how to do it...
could u explain more on this... maybe.. step by step instruction. Thanks
dakmuo
 
Posts: 7
Joined: 04. December 2009 12:54
Location: Johor Bharu, Malaysia

Re: How To Create Multiple or More MYSQL Server

Postby Knight1 » 05. December 2009 21:22

on the startingpage you see a link privileges there you can add the rights.

bye


Kai aka Knight1
Image
User avatar
Knight1
 
Posts: 310
Joined: 18. October 2003 10:03
Location: Trier
Operating System: Windows 7 Ultimate x64

Re: How To Create Multiple or More MYSQL Server

Postby dakmuo » 07. December 2009 23:51

Hi everybody..

This case not settle yet.. anyone can help me, please reply to this post..

The problem is..

How to create MULTIPLE USER WITH MULTIPLE DATABASE for MYSQL..

My Question seems like u look at WHM Cpanel / PLESK that can create many user and user can create many database without see other user..

For information, i do this project with XAMPP base on Windows XP.

Thanks :)
dakmuo
 
Posts: 7
Joined: 04. December 2009 12:54
Location: Johor Bharu, Malaysia

Re: How To Create Multiple or More MYSQL Server

Postby Wiedmann » 08. December 2009 01:35

i choose Create database with same name and grant all privileges.
and what i get is.. 1 user with 1 database as user name.

You must select "Grant all privileges on wildcard name (username\_%)" and nothing in "Global privileges".

Now you have a user without a database, but the user can create as many databases it wants, only the database names must begin with "username_".

Maybe additionally you want add:
Code: Select all
$cfg['AllowUserDropDatabase'] = true;

to the "config.inc.php" (\xampp\phpMyAdmin). Thus a user can delete a created database.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: How To Create Multiple or More MYSQL Server

Postby dakmuo » 08. December 2009 18:01

Hi Wiedmann..


Wow.. Thank You So Much!~

U are brilliant.. hehe.. now i can create 1 user with unlimited database and the user cant see other user database.. wow..

Very wonderful.. Thank you so much Wiedmann... Thank you.. Thank you... :mrgreen:

And other thing, how can i LIMIT user to create at least only 10 database per user?
and to give user permission to create user in same database.

All i need to know, same like what is have in MYSQL section in cPanel.

Thanks Again.. :D
dakmuo
 
Posts: 7
Joined: 04. December 2009 12:54
Location: Johor Bharu, Malaysia


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 8 guests