SERVER : Install PHPMyAdmin
Tuesday, 9. January 2007, 13:30:06
In the future I want to use a few services that rely on MySQL, so I've decided to install PHPMyAdmin so that i don't have to play with the console in order to add/edit/remove mysql tables and recors.
In order to install it, here's what you have to do :
This will install PHPMyAdmin and the required libraries. It will take some time since it must download about 8-10Mb of data.
After a few minutes it should end without a warning. If everything went well, you'll have the PHPMyAdmin installed. In order to use it, you'll have to access the following address : http://your_ip_address/phpmyadmin/
The first time you start, you should enter "root" as the username, and leave the password empty.
The root user in MySQL is not the same with the root user of the system.
After the first login, you should see something similar to this :
As you can see, PHPMyAdmin shows a warning that the administrator user has no password and as such this represents a security risk. We're going to fix this right now, so select privileges
On the new page click on the "Edit Privileges" button for the root user on your system, as shown in the picture : 
The new page is quite long, so scroll down to the "Change Password" area and enter a new password for the root user (make shore you remember it, since you won't be able to add/edit/remove tables without that password).
After you press the Go button, you should see somethings like this (at the top of the page):
If you have 2 root users, one is root@localhost and the other is root@your_server_name then do the above steps for root@localhost (you can do it for the other too to be on the safe side).
Now log off from PHPMyAdmin and log in again (with the password) and the red warning should be gone (which is a good thing
)
So, from now on, you can add/remove/edit mysql tables, entries and users using the simple to use PHPMyAdmin interface.
Here's what the buttons do in PHPMyAdmin 
In order to install it, here's what you have to do :
apt-get install phpmyadmin
This will install PHPMyAdmin and the required libraries. It will take some time since it must download about 8-10Mb of data.
After a few minutes it should end without a warning. If everything went well, you'll have the PHPMyAdmin installed. In order to use it, you'll have to access the following address : http://your_ip_address/phpmyadmin/
The first time you start, you should enter "root" as the username, and leave the password empty.
The root user in MySQL is not the same with the root user of the system.After the first login, you should see something similar to this :
As you can see, PHPMyAdmin shows a warning that the administrator user has no password and as such this represents a security risk. We're going to fix this right now, so select privileges
On the new page click on the "Edit Privileges" button for the root user on your system, as shown in the picture : The new page is quite long, so scroll down to the "Change Password" area and enter a new password for the root user (make shore you remember it, since you won't be able to add/edit/remove tables without that password). After you press the Go button, you should see somethings like this (at the top of the page):
If you have 2 root users, one is root@localhost and the other is root@your_server_name then do the above steps for root@localhost (you can do it for the other too to be on the safe side).
Now log off from PHPMyAdmin and log in again (with the password) and the red warning should be gone (which is a good thing
)So, from now on, you can add/remove/edit mysql tables, entries and users using the simple to use PHPMyAdmin interface.
Here's what the buttons do in PHPMyAdmin
WIDGETIZE