Tips & Tricks

How to flush-hosts in MySQL

Probably many of you have met the MySQL max connections issue and that you need to do flush-hosts. This tutorial will explain how to do it. Firstly you need to have the admin user of your MySQL server. In most cases it is root. Login through SSH and execute the following command:mysqladmin -uroot -p flush-hosts […]

Operation Systems

Installing Apache, MySQL and phpMyAdmin on Ubuntu Linux

Firstly we will need to open console terminal and write the following User@TheUbuntuBox ~# sudo apt-get install apache2 autoconf automake1.4 autotools-dev libapache2-mod-php5 php5 php5-common php5-curl php5-dev php5-gd php-pear php5-ldap php5-mhash php5-mysql php5-mysqli php5-snmp php5-sqlite php5-xmlrpc php5-xsl php5-imap php5-mcrypt php5-pspell php5-gd autoconf automake1.4 autotools-dev libapache2-mod-php5 mysql-server We just installed Apache2, MySQL Server and PHP5. Now we […]

Scripting & Programming

PHP MySQL connection simple script

Before you can access and work with data in a database, you must create a connection to the database. In PHP, this is done with the mysql_connect() function. Syntax mysql_connect(servername,username,password);   Parameter Description servername Optional. Specifies the server to connect to. Default value is “localhost:3306” username Optional. Specifies the username to log in with. Default […]