How to install LEMP stack on Centos 7
There are many methods to install LEMP stack (Linux, Nginx, MariaDB & PHP-FPM) on Centos 7. Here we present to you method by using VPSSIM…
Category: MYSQL
How to install Mtop (MySQL top) in CentOS
mtop (MySQL top) monitors a MySQL database showing the queries which are taking the most amount of time to complete. Features include ‘zooming’ in on…
How to reset OpenCart administrator password?
Log into Phpmyadmin, goto table oc_user, we’ll show: The password was encrypt with the randomized salt. Now we research which method used to encrypt the…
PHP & MYSQL: Anti Sql Injection with mysql_real_escape_string function
Mysql command will be: Mysql command will be: With this command will cause one user login without the correct password. => use mysql_real_escape_string to prevent…
PHP MYSQL: list of Timezones, Set Timezone
Recently I needed to check the time zone in one of my applications, because it is accessed from multiple locations in United States and soon…
Maxlength of MySQL TEXT Data Types
Data types and range of data management system MySQL database (Read more) TEXT Data Types in MySQL CHAR CHAR data type for storing a data…
PHP: retore big MYSQL-database
This tutorial shows you how to restore a big MYSQL-database. Step 1: split MYSQL file into many part We use PHP-script below (ex: split.php) After…
Change root password MYSQL in Kloxo via SSH
Step 1: Login VPS or dedicated server using SSH. Step 2: Open SSH console. Step 3: Use following commands: service mysqld stop mysqld_safe –skip-grant-tables &…
PHP & MYSQL: Determine Auto Increment value of a table
How to Determine Auto Increment value of a table MYSQL Method 1: Code PHP: Result: 84586 #Showing rows 0 – 0 ( 1 total, Query…
MYSQL: How to DELETE with INNER JOIN
MYSQL: How to DELETE with INNER JOIN There are 2 tables, proxy and proxy2, and I need to delete data from proxy. proxy.md5 = proxy2.md5…