INSTALLING PHPMYADMIN. (phpMyAdmin is a web interface used to develop and manage MySQL databases.)

1. At the Debian GNU/Linux w/ KDE Welcome Screen, chose the “Menu” option in the lower left part of the screen.
2. In the Menu chose the “Console Login” option. (You Can also simply click ALT+N from the Debian GNU/Linux w/ KDE Welcome Screen, in place of the first two steps in this section. This is a shortcut to the Console or “CONSOLE MODE”.)
3. At the Login prompt type: “root” and hit the [enter] key.
4. Type in the Password of the “root” user and hit the [enter] key.
5. Then you will type the following code:
   Code:

   test:~# apt-get update

   then press the [enter] key. This will download the latest, most up to date installation packages. Do not try to continue until it has completed the package header downloads.

6. Once all the package headers have been downloaded, type:
   Code:

   test:~# apt-get install phpmyadmin

   then press the [enter] key to continue. You will be prompted about being sure. Hit the “Y” key and press the [enter] key to continue.

7. Verify that the installation completed by looking at the last 5 lines of the installation script. Each line should have created a configuration file. You will be left at the # Command Prompt.
8. You will need to restart your Apache2 web server after installing phpMyAdmin. To do this type:
   Code:

   test:~# /etc/init.d/apache2 restart

   then press the [enter] key. This will restart the Apache2 server, and enforce the new modifications you just made.

9. Bring up a web browser and go to the IP Address of the machine you are working on: “http://localhost/phpmyadmin/” if you or working locally or “http://0.0.0.0/phpmyadmin/” if you are working remote. Hit the [enter] key.
10. You should be directed to a website showing the log in screen for phpMyAdmin.
11. Log in with “root” as the username and leave the password blank. This is the default username and password to get it for the first time. As a rule of security and in general, you will want to add a password to that account to make it more secure.
12. Congratulations, you have successfully installed phpMyAdmin!

Filed under: Computers, Linux-Unix, Software | No Comments »

INSTALLING MYSQL SERVER. (MySQL is one of the most popular Database Servers available and certainly the most powerful.) The MySQL Packages are necessary to use many various email systems, online bulletin boards, forums and many other data driven features you may want to use in the future.

1. At the Debian GNU/Linux w/ KDE Welcome Screen, chose the “Menu” option in the lower left part of the screen.
2. In the Menu chose the “Console Login” option. (You Can also simply click ALT+N from the Debian GNU/Linux w/ KDE Welcome Screen, in place of the first two steps in this section. This is a shortcut to the Console or “CONSOLE MODE”.)
3. At the Login prompt type: “root” and hit the [enter] key.
4. Type in the Password of the “root” user and hit the [enter] key.
5. Then you will type the following code:
   Code:

   test:~# apt-get update

   then press the [enter] key. This will download the latest, most up to date installation packages. Do not try to continue until it has completed the package header downloads.

6. Once all the package headers have been downloaded, type:
   Code:

   test:~# apt-get install mysql-server

   then press the [enter] key to continue. You will be prompted about being sure. Hit the “Y” key and press the [enter] key to continue.

7. When you are returned to the command prompt, you need to verify that the installation completed without errors. Read the last 4 lines of the installation script, found above the # Command Prompt. It should say “Stopping MySQL database server: mysqld” then “Starting MySQL database server: mysqld” then “Checking for corrupt, not cleanly closed and upgrade needing tables…” and lastly “Setting up mysql-server (version number)” .
8. Obviously the last step should have left you at the # Command Prompt.
9. Congratulations, you have successfully installed MySQL Server!

Filed under: Computers, Linux-Unix, Software | No Comments »