MySql Archive

1045 – Access denied for user ‘root’@’localhost’ (using password: YES)

While dealing with phpMyAdmin for novice user, sometime you unable to login into mysql using the mysql console. It throws #1045 - Access denied for user 'root'@'localhost' (using password: YES) error on screen. If root@localhost wasn't granted the necessary rights to access the database or you provided the wrong password, you will then encounter this error.

MySQL vs MySQLi in php

The mysqli and mysql  are the database extension which allows you to access the functionality provided by MySQL 4.1 and above. The PHP code consists of a core, with optional extensions to the core functionality. PHP's MySQL-related extensions, such as the MySQLi extension, and the MySQL extension, are implemented using the PHP extension framework. An