Tag Archives: mysql
Install LAMP stack on Ubuntu 16.04

Update system sudo apt-get update && sudo apt-get dist-upgradesudo apt-get update && sudo apt-get dist-upgrade Install Apache sudo apt-get install…

Copying MySQL database to another server

* Export database from old server: mysqldump -u[username] -p[password] db_name > db_backupmysqldump -u[username] -p[password] db_name > db_backup * Copy backup…

How to upgrade XAMPP in Windows

> Open XAMPP Control Panel (run as administrator!). > Stop services and uninstall them from services list if any. >…

Create Function in MySQL

Let’s see an example: DELIMITER $$ CREATE FUNCTION `countonline`(`dtstart` DATETIME, `dtend` DATETIME) RETURNS BIGINT(20) LANGUAGE SQL NOT DETERMINISTIC READS SQL…

Get MySQL version in CakePHP 3

You need to import ConnectionManager: use CakeDatasourceConnectionManager;use CakeDatasourceConnectionManager; $stmt = ConnectionManager::get(’default’)->query(’SELECT version() as v’); $stmt->execute(); echo $stmt->fetch(’assoc’)[’v’];$stmt = ConnectionManager::get(‘default’)->query(‘SELECT version()…

Get MySQL server version with Kohana

$mysql_version = DB::query(Database::SELECT, ‘SELECT version() as v;’)->execute()->get(’v’, 0); echo $mysql_version;$mysql_version = DB::query(Database::SELECT, ‘SELECT version() as v;’)->execute()->get(‘v’, 0); echo $mysql_version;

Kohana MySQL Database Schema

Kohana 3.3 MySQL Database Schema github CREATE TABLE IF NOT EXISTS `roles` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name`…

Hardening a MySQL Server

Below are some quick tips that you should follow to secure your MySQL Server. Secure root account with a strong…

Let’s go Phishing

Phishing is an attempt to steal sensitive information by impersonating a well known organization or website. In the same manner…

Cracking MySQL passwords with John The Ripper

Dump MySQL Password Hashes mysql_hashdump extracts the usernames and encrypted password hashes from a MySQL server. You can then use…

Next Page