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.

Convert mysql rows into json using php

convert-php-mysql-to-json-format When we are dealing with web services, we are received the server side data into the JSON format or other. When it comes at PHP, then transforming the MySQL data to JSON Format becomes very important task for developer. In very less time JSON has gained its popularity over the XML format in terms

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