This article shows you how to manage your databases for your websites using phpMyAdmin. Managing your database includes creating new databases, tables, entries. Or even deleting or editing them. Though I will warn your right now, if you don’t know what you are doing, or are just experimenting with phpMyAdmin, you can serious screw up installed php packages. Tread with caution. However, phpMyAdmin gives a much nicer and easier to used interface for interacting with MySQL than a command line.
Note: If your are not familar with databases, or MySQL, or don’t know why you would want to install this, then this tutorial probably isn’t for you. This was writen more for enthusaists, and others who have an idea of what they are doing. But if you still are interested, by all means. Just “Export” your database before messing around too much so you can recover it if you do mess it up.
What you will need
- Remote access to the server
- phpMyAdmin Download – Download the zip file of what ever language package suites you.
What to do? First thing’s first, and you are going to want to download phpMyAdmin and put it on a network share. Then you are going to either use Remote Desktop Connection or Advanced Admin Console to gain access to the server.
Open up the compressed file and extract the phpmyadmin files to “C:\inetpub\phpmyadmin”. Also, create a directory named ‘config’ inside the phpmyadmin folder. This will be needed later. The directory should look something like this[…]