3 replies to this topic

[bbqroast]

If you setup MySQL with XAMPP you will already have PHPMyAdmin installed, installing it is out of the scope of this tutorial but I have another one here: (Make sure you read the second one too!) http://forum.codecal...er-package.html

PHPMyAdmin is a very powerful tool for managing your MySQL database(s).

First navigate to http://localhost/phpmyadmin you will be asked for a username and password. Login as 'root', you will have setup the password in the MySQL setup (if you used XAMPP you will have done it on the security page).

Once you are logged in you will see you will have a list of databases on the left panel, their will be a couple of ones already- you just want to find 'test' if its not there you can create it using the create database form on the front page (just leave everything except the name form empty).
 1.jpg   99.85K   78 downloads
Once test is open you can create a new table on 'test', I am going to create one called 'names' with 3 columns. Once you create it you will be asked to enter the information on each column. The first one is going to be called `ID` (without the two `) and its going to be a int, you will notice there are many other options just leave them- except for the index and Auto Increment (or AI) fields: change ID's index to 'primary' and tick the AI/ Auto Increment box.
 2.jpg   48.09K   73 downloads
The next one should be called 'first' and the type should be 'text' do the same for the second which should be called 'last'. Having confirmed these details press 'save'. You will then be sent to a page showing the 'structure' of the table, ID should be underlined.
 3.jpg   88.68K   68 downloads
You can start 'populating' the table by clicking insert (its on the bar along the top) and entering the details:
LEAVE ID BLANK it will automatically be set and can be used effectively, I recommend you add say 5 rows to the table.

Edited by bbqroast, 28 August 2011 - 11:20 PM.

[arif27]

Nice tutorial, but I want to add something. the first installation of xampp is make the phpmyadmin and xampp folder accessible to everyone. If you want to add password use this link.

http://localhost/sec...mppsecurity.php

Then write your usernma and password. Just sharing. :)

[Epatron]

arif27 said:

http://localhost/sec...mppsecurity.php

^ You should add this link to tutorial, otherwise looks good n cool! :)

[bbqroast]

I have written another (two) tutorials on setting up and securing XAMPP. Like I said it is really out of the scope but I will link it.