GoDaddy Apache cPanel: Install SSL Certificate
- Category: cPanel
- Hits: 8061
An article to remind me how to install an SSL certificate with GoDaddy.
Why?
A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time.
The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article.
How?
I know there are instructions on the GoDaddy website but this is how I do it along with screenshots:
Minimal Privileges for MySQL Database Backup Cron Job
- Category: cPanel
- Hits: 5561
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users).
How?
I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database I want a backup of:
GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser';
