Group Discounts available for 3+ students and Corporate Clients

General Security Issues

13.1.  General Security Guidelines

  • Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical.
  • Learn the MySQL access privilege system. The GRANT and REVOKE statements are used for controlling access to MySQL. Do not grant more privileges than necessary. Never grant privileges to all hosts.
  • Do not store any plaintext passwords in your database. Instead, use MD5(), SHA1(), or some other one-way hashing function and store the hash value.
  • Invest in a firewall. This protects you from at least 50% of all types of exploits in any software. Put MySQL behind the firewall or in a demilitarized zone.
  • See what are the privileges provided by the MySQL.

Check Out Our Related Courses

Sql Tutorials

Oracle Pl SQL Tutorials

Top 50 Sql Server Interview Questions

SQL Server T-SQL Training In Bangalore

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on General Security Issues"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6