Top Nav

Revoke MySQL DROP Privilege On Plesk Database User

Had a request from client to add database user on a Plesk server but to remove the DROP DATABASE privilege so that they could not accidentally delete their database. By default, database users created through Plesk do have the DROP DATABASE privilege. Plesk does not currently allow fine-grained control over database privileges so the only way to implement this change is to modify the privileges directly from a MySQL command line. After some testing we found these command will have the desired effect:

Of course replace “testdb” and “testdbuser” with your actual database and username.

0

LFTP With GoDaddy

Trying to get my usual mirror script working with GoDaddy but it kept hanging with “Delaying before reconnect…”. Solution turned out to be adding:

to the options.  Thanks to unsigned_nerd for this one!

 

0

Percona XtraDB Upgrade With Yum Shell

Ran into dependency problems today trying to upgrade a Percona XtraDB server cluster. Yum shell to the rescue:

This way I can run the remove and installs as part of a single transaction.

0

Redirect HTTP to HTTPS on IIS

If you need to force HTTPS on the entire site then add the following to the web.config file:

If you want to force HTTPS on a specific URL, then use this instead:

 

 

 

0

Redirect HTTPS to HTTP

If you want to redirect all HTTPS traffic to HTTP then add the following to your .htaccess file:

 

0