Computer Programming web Web programming Tips


By Sergey Skudaev

Using the XAMPP Shell

Download and install XAMPP, an easy to install Apache distribution containing MySQL, PHP, and Perl:

Hover your mouse over an image to enlarge it. Click the image to make it small again.

xampp executable

Click the Shell button on the XAMPP control panel.

xampp shell show databases

Login to MySQL with the root user. View exiting databases with the "SHOW DATABASES" command.

xampp shell create user

Create a user "johns" with password "Password7@".

xampp shell grant permissions

Grant user with all privileges.

xampp shell grant permissions

Select a database with command "use " Show exiting tables.

xampp shell create table

Create a visitors table.

xampp shell insert

Insert a visitor´s record.

xampp shell update

Update the visitors record.

xampp executable

Display records from the visitord table.

xampp executable

Delete a visitor.

PHP links:


My eBooks on


No comments yet.

Add Comment

* Required information
(never displayed)
Smile Sad Huh Laugh Mad Tongue Crying Grin Wink Scared Cool Sleep Blush Unsure Shocked
Which is darker: black or white?
Enter answer:
Enter code:
Notify me of new comments via email.
Remember my form inputs on this computer.
I have read and understand the privacy policy. *
I have read and agree to the terms and conditions. *
Powered by Commentics