Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th December 2007, 17:19
Hagforce Hagforce is offline
Senior Member
 
Join Date: Feb 2006
Posts: 210
Thanks: 37
Thanked 1 Time in 1 Post
Default Making users for My SQL database

Hello

Is there any way for domain admins in ISPConfig to make My SQL users with different rights to the databases they administrate.

In example the administrator of web_15 wants to add a user to his SQL database web15_db2 that has limited rights, for use on his web page.

Is it possible to do this?
Reply With Quote
Sponsored Links
  #2  
Old 21st December 2007, 12:52
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,009
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

In ISPConfig, every database has only one user. If you want to get more users for a database, you will have to craete them in the mysql user table, e.g. with phpmyadmin.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Hagforce (18th April 2008)
  #3  
Old 21st December 2007, 12:55
Hagforce Hagforce is offline
Senior Member
 
Join Date: Feb 2006
Posts: 210
Thanks: 37
Thanked 1 Time in 1 Post
Default

Thank you for replying

Does the induvidual database user have rights to do this, or do I have to log in as root to do this?
Reply With Quote
  #4  
Old 21st December 2007, 12:57
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,009
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
 
Default

You will have to login as root for this. As far as I know, mysql is not able to delegate the right to create users for just one database to a user that has onyl access to this database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Hagforce (18th April 2008)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
radiusd.conf[14]: sql: Module instantiation failed. euslemoc Installation/Configuration 8 6th November 2007 08:16
Mail System doesnt work! crichton Installation/Configuration 3 18th September 2007 00:49
Junk mail and spamassassin... sthompson Installation/Configuration 4 27th December 2006 17:11
ISPConfig and adding an SQL Database Texaskilt General 1 7th December 2006 10:52
users in database jooray Feature Requests 1 7th March 2006 00:07


All times are GMT +2. The time now is 15:05.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.