A Default MySQL installation is completely vulnerable to attacks. MySQL installation should be made as secure as possible. This is to protect the data collections and the information maintained by the MySQL server from unauthorized or anonymous access. In This post, i will share with you on how to secure your database server with the [...]
Archive for the ‘Database’ Category
Posted in 
Tags: 
SQL to Select a random row from a database table
January 5th, 2012 
Frank BorosThere are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don’t require additional application logic, but each database server requires different SQL syntax. Incoming search terms:sql logo (9)database sql (1)db2 sql select random record (1)
Auto Optimize Your MySQL Tables Script
September 20th, 2010 Frank BorosIn my quest to make our clients MySQL driven e-commerce websites running fast, I’ve pieced together a script and cron job that will save you some support calls down the road.
Unique Text in MySQL Database Text Field
May 15th, 2010 Frank BorosPosted by Guest memeber “Dipon” MySQL Database, Text Field index can’t be selected as Unique. So checking duplicate data insert on text flied, its make resource usage high. For prevent duplicate data insert in text and reduce database usage, also the resource, I have to find alternative solution. Its so easy. I add a extra [...]
