top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the Security Points we need to keep in mind while using MySQL?

0 votes
321 views
What are the Security Points we need to keep in mind while using MySQL?
posted Jun 20, 2014 by Amritpal Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Following Points should be followed while using MYSQL.
1.Access to the user table should never be given to avoid SQL injection attacks.
2.Privileges such as GRANT and REVOKE must be made use of.
3.SHOW GRANTS can be used to see the list of users who have access
4.Never run the MySQL server as the Unix root user
5.Validation of data and queries should be thoroughly checked.

answer Jun 23, 2014 by Rahul Mahajan
Similar Questions
+1 vote

Are there any defined rules that should be considered while writing function definition ?

0 votes

This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat.

I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order that somehow "duplicated" the items. I need to see if there was only 1 of each item or two removed from inventory). I don't need to do a "restore" into the database, just have a look at the backup.

Is this possible without going through the hoops of creating a copy of the database and restoring to the copy (I assume this is possible) - I DO NOT want to restore into the currently running database :-)

0 votes

I'm noticing that across our several databases and hundreds of tables that column definitions are not consistent. I'm wondering if there is a tool or query (using INFORMATION_SCHEMA perhaps) that will show me all databases, tables and columns where they don't match (by column name).

For example in one table foo_id might be UNSIGNED and in other's it is not. Or maybe it's INT(11) in some and INT(10) or worse MEDIUMINT in others. Or extending further Charset/Collation might mismatch and be that stupid "latin1_swedish_ci" and fixed to be "utf8" in others.

Stuff like that. I want to see everything where there is some difference.

...