Our features site is undergoing a refresh! Be sure to explore the revamped site and discover our latest product roadmap launching here on Monday, March 18th.

Remote MySQL Host Notes

Ryan Born shared this idea 9 years ago
Completed

We have lots of different servers and vendors we open up our database to. That requires that we add each of their IP's into the RemoteMySQL host listing. However, now that we have added many of these vendors and hosts, we really have no idea which is which in the list. It would be great to have a small note field (50 characters would do it for us) that would allow us to label what each host is for easy management and deletion in the future.

Best Answer
photo

cPanel & WHM Version 74 has reached the CURRENT tier! Update now to see this update in your cPanel interface, or read the related Release note.

Replies (10)

photo
1

I absolutely agree, particularly as many broadband providers will randomly but frequently change external IP for home workers particularly. I spend 3 hrs every day having to review all the ip addresses within panel remote mysql because we can't hold an identifying label. 50 characters would be enough for me too.

photo
1

We have the same problem ... many changing developers and temporary remote access IP that we need to manage. %0 char is fine.


And if you want to get more sophisticated adding a date field for auto-expiration would be a nice to have - definately not a need to have.

photo
1

We definitely could use this as well. We have many developers and temporary remote access requests we need to manage. 50 char is fine.


And a nice to have might be a date field for automatic removal. This is not a need to have.

photo
1

Of note: comments field should be mandatory. Otherwise, we would be in the same current situation :-)

photo
2

Addendum: Comments should be editable, in the same fashion as descriptions are in Greylisting UI; so users/admins can fix/update descriptions.

photo
2

We've got this queued up for release in v74 or v76. Right now the notes are stored in an additional system-level mysql database but we're working to pull that out and instead store it elsewhere. The full create-review-update-delete experience is in place, as well as the clean-up of entries when the account is terminated and the backup/restoration/transfer/rename of this data when the account moves.

photo
1

Great. Glad to know. Thank you for the heads up.

photo
2

Starting in v74 (slated for release this spring), we've added this feature!

Comments can be added, updated and removed alongside access hosts in the cPanel » Home » Databases » Remote MySQL interface.

Here's what it looks like:

2347a159c0b98894226ca9bfa645ff72

Comments can be alphanumeric and a max-length of 255 characters. For v74, these comments persist until they are deleted and will move when the account is transferred or backed up.

photo
1

Awesome - thank you!

photo
1

74 has hit the EDGE tier and is aimed at CURRENT later in July or early August. If you're interested, I recommend setting up an EDGE server (instructions on our blog) and taking a look at this feature!

Release Note

photo
2

cPanel & WHM Version 74 has reached the CURRENT tier! Update now to see this update in your cPanel interface, or read the related Release note.

Replies have been locked on this page!