#1 (permalink)  
Old 02-08-2010, 11:00 PM
Registered User
 
Join Date: Feb 2010
Posts: 1
b0xa is on a distinguished road
Post User Specific MySQL Remote Access

In the current version, when configuring 'Remote MySQL' you add hosts & it applies to ALL MySQL accounts related to the current account.

Enabling hosts to be set on a per-user basis is much more secure & a far better option (IMO). The workaround I found was to simply modify the users table via SSH, however it did seem to effect privileges until I reset them in cPanel.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-09-2010, 12:21 AM
serversignature's Avatar
Registered User
 
Join Date: Nov 2007
Location: Bangalore
Posts: 105
serversignature is on a distinguished road
Cached memory can be freed with FLUSH PRIVILEGES which reloads the privileges from the grant tables in the mysql database, have you tried that ?

Thanks,
Kiran
__________________
Serversignature.com - Professional Linux Consulting.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
mysql , remote , user specific

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
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
restict access to specific user prasad_dhamane cPanel and WHM Discussions 2 05-23-2008 09:36 AM
I need to limit FTP access for a user to a specific IP. carock cPanel and WHM Discussions 2 08-15-2007 09:35 AM
MySQL database remote access (Access Host) akot2 cPanel Newbies 4 12-21-2006 09:45 AM
I need to know if I can give a user access to stats for a specific domain only, so adnaan cPanel and WHM Discussions 1 11-17-2004 06:10 PM
Disable cPanel access for a specific user Pap cPanel and WHM Discussions 12 04-13-2004 01:36 AM


All times are GMT -5. The time now is 04:59 PM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
© cPanel Inc