GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com

myBlog

myBlog Home

Back to Blog MTNCOMP


SQL

SQL security and permissions revisited

Published: Friday, May 29, 2020 written by Drew Jackson
View Count: 22
Keywords: SQL Server, mySQL, MariaDB, permissions, security



In the past few months, working on mySQL and MariaDB, the permissions can get a bit tricky.
 
using the root account is not the best. usually you have to create a new user for your specific database (schema) and apply that.
 
what is interesting are the log files that show more permission issues that I have ever experienced rather than in MSSQL.
 
Oh well, just get used to the mySQL workbench, and the flavor of MariaDB or mySQL underneath and you'll be fine. It does take a while to get used to the interfaces and the workbench is not as good as MS SQL t-sql and SMS Studio.
 
more to come...

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2020 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.