Inbound spam is the scourge of the modern internet and, the inconvenience to users aside, can cause serious performance and resource issues on the server. These can affect both the server overall and the timely deliver of clean email in particular. The best way to tackle inbound spam is at the entry point into the […]
Hello, The easiest way to duplicate MySQL database is just using mysqldump command. Based on following variables: OS: CentOS 6.0 64bit MySQL root password: q1w2e3!@# Database name: grand_shopper Duplicate database name: grand_shopper_dev New database user: dev_user Password: D3eVVbf7 Firstly, since I just want to copy and duplicate database inside the same server, I need […]
Hello, 1. Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical! 2. 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 […]
