Check Apache, MySql, and PHP versions

To further check LAMP stack installation, the following can be made to know the exact installed version of each application. Check the exact Apache...

 

Access a MySQL database from the terminal

Directly access a MySQL database from the terminal. For example. A MySQL user should have been created, with a privilege already granted. mysql...

 

Grant a privilege to a MySQL user on a database

To be able for a MySQL user to add, edit, delete, and select records from a database, a permission should be first granted to be able to access a MySQ...

 

Create a MySQL database user

Create a user to access a MySQL database to add, edit, delete, and list records. For example. Create a MySQL user from the terminal. Access the M...

 

Insert new records to a MySQL database using PDO in PHP

Prepare records to be inserted to a MySQL database using the PDO prepare() function in PHP, then use the execute() function to perform the query. F...

 

Update a MySQL record using PDO in PHP

Access MySQL database using PDO in PHP and update MySQL records with the prepare() function, it already has an auto-escaping feature for any given par...

 

Select MySQL database records using PDO in PHP

One simple way of selecting records from a MySQL database using PDO is with the use of the function query(). This function executes an SQL select stat...

 

Access MySQL database using PDO in PHP

Most, if not all new PHP server installations now a days include the PHP Data Objects API (PDO_MySQL), this extension is recommended if there's a chan...

 

Restore a MySQL backup file (.sql) from the terminal

Efficiently import MySql backup database records from an .sql file using the command mysql from the terminal. For example. mysql -uNAME -pPASSWORD D...

 

Backup MySQL database into an .sql file from the terminal

Import MySql database records from the terminal using the MySql command mysqldump, it is a quick and easy way to backup MySql database records. For e...

 

Install LAMP on Ubuntu in six easy steps

Only six easy steps are needed to install Linux Apache MySql Php (LAMP) Stack on Ubuntu. Note: This LAMP installation was specifically tested to be...