Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th July 2008, 16:15
bolero bolero is offline
Senior Member
 
Join Date: Apr 2008
Posts: 114
Thanks: 2
Thanked 8 Times in 8 Posts
 
Default Using MySQL non-root account

You may not want to use the MySQL root account in ispconfig for security reasons. I didn't know that I have to use the root account and did it the same way as I always do with PHPMyAdmin. Worked fine until I started creating databases. I had to add a few more permissions to the ispconfig account. Here is a list of grants you need to apply, so that you can stop using the MySQL root account for ispconfig.

Code:
GRANT ALL ON ispconfig.* TO 'ispconfig'@'localhost' IDENTIFIED by 'yourpasswordhere';
GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.db TO 'ispconfig'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.user TO 'ispconfig'@'localhost';
GRANT RELOAD on *.* TO 'ispconfig'@'localhost';
GRANT CREATE, DROP ON `web%`.* TO 'ispconfig'@'localhost';
The last line depends on keeping the user naming scheme of "web....". If you use a different webid prefix adapt that line.

Last edited by bolero; 31st July 2008 at 14:08. Reason: added RELOAD (if not present, edited db passwords will take effect only after a mysqld restart)
Reply With Quote
The Following User Says Thank You to bolero For This Useful Post:
falko (10th July 2008)
Sponsored Links
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
Missing Email dayjahone General 7 30th June 2008 15:29
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 14:36
i am having some problem ? cobro Installation/Configuration 20 30th April 2008 16:26
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Add Webmin to the system sushestvo Installation/Configuration 44 21st August 2007 16:52


All times are GMT +2. The time now is 20:51.


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