Grant Remote Access to MySQL server in CentOS

 To grant remote access here are the steps: Step 1. Edit the file etc/my.cnf and add these lines on [mysqld_safe] [mysqld_safe]     Port = 3...

Continue Reading→

MySQL Password Validation Plugin system variables.

As you might have noticed, you will be prompted to enable "VALIDATE   PASSWORD" component while setting up password for MySQL root...

Continue Reading→

Create your First Website in Localhost using Joomla Content Management System ( Part-1 : Setup Apache, PHP, MySQL and Joomla in your local PC )

In this tutorial we will setup Apache, PHP and MySql Server in our local computer and create our very first Web site using Joomla Content Ma...

Continue Reading→

Install and configure your local server to test PHP application and PHP based content management system ( Part-7: Wrap up User Management System PHP Application )

  Before wrap up let's modify our new user registration form. Open the HTML file insert_form.html in text editor and modify the code as...

Continue Reading→

Install and configure your local server to test PHP application and PHP based content management system ( Part-6: Delete Records in Database Table from PHP Application )

  So far we have completed Create, Read, and Update part of CRUD. Now let's start the  Delete part. We will follow same technique applie...

Continue Reading→

Install and configure your local server to test PHP application and PHP based content management system ( Part-5: Update Records in Database Table from PHP Application )

  In this part we will learn how to update a particular record from MySql database. To update a record in database we have to select the id ...

Continue Reading→

Install and configure your local server to test PHP application and PHP based content management system ( Part-4: Insert Records in Database Table from PHP Application )

  So far we have configured our database and read all records from userlogin table. Let's create another file to insert new record in ...

Continue Reading→

Install and configure your local server to test PHP application and PHP based content management system ( Part-3: Connect database from PHP application )

  To connect our MySql database which was created earlier in Part-2 ,  let's create a folder inside www folder of WampServer installa...

Continue Reading→

Install and configure your local server to test PHP application and PHP based content management system ( Part-2: Set up Database Server )

  So far we have tested our first PHP Program on our local server. Now, we will move to Database configuration. Every dynamic website includ...

Continue Reading→