Remove Joomla Database
Here is som
e
short content from MySQL 5.5 Reference Manual:
13.1.13. DROP DATABASE Syntax
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
When a database is dropped, user privileges on the database are not automatically dropped. See Section
13.7.1.5. “REVOKE Syntax ”..
13.7.1.5. REVOKE Syntax
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...
REVOKE removes privileges, but does not drop mysql.user table entries. To remove a user account
entirely, use DROP USER (see Section 13.7.1.2, “DROP USER Syntax”) or DELETE.
13.7.1.2. DROP USER Syntax
DROP USER user [, user] ...
13.7.6.3. FLUSH Syntax
FLUSH [NO_WRITE_TO_BINLOG | LOCAL] flush_option [, flush_option] ...
No the serie
s
of command that remove the joomla part from your MySQL-database
mysql -u root -p
DROP DATABASE IF EXISTS
joomla_258
;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM
 
j
 
258
 
@localhost
 
;
DROP USER
j
 
258
 
@localhost
 
;
FLUSH
PRIVILEGES
;
exit
Remove Joomla
Remove the joomla web
-
p
a
ge files from Ubuntu server
sudo
rm -r /var/www/
joomla_
258
 
Disable joomla site
Remove the web site from apache
server
sudo a2dissite
joomla_
258
 
sudo rm /etc/apache2/sites-available/
joomla_
258
sudo /etc/init.d/apache2 restart
Page
16
of
19
Rev.:
155
-
December 3, 2012
 
22:40
Additional

How To Install Joomla 2.5.x On Ubuntu 12.xx using VirtualBox & Win7
Ubuntu
 
software
 
Apt-get
Manual is here
The apt-get command is a powerful command-line tool used to work with Ubuntu's Advanced Packaging
Tool (APT) performing such functions as installation of new software packages, upgrade of existing
software packages, updating of the package list index, and even upgrading the entire Ubuntu system.
Being a simple command-line tool, apt-get has numerous advantages over other package management tools
available in Ubuntu for server administrators. Some of these advantages include ease of use over simple
terminal connections (SSH) and the ability to be used in system administration scripts, which can in turn be
automated by the cron scheduling utility.
- Update the Package Index:
The APT package index is essentially a database of available packages from
the repositories defined in the /etc/apt/sources.list file. To update the local package index with the latest
changes made in repositories, type the following:
sudo apt-get update
- Upgrade Packages:
Over time, updated versions of packages currently installed on your computer may
become available from the package repositories (for example security updates). To upgrade your system,
first update your package index as outlined above, and then type:
sudo apt-get upgrade
p
 
hpMyAdmin
 
Homepage is
phpMyAdmin is a free software tool written in PHP intended to handle the
 
administration of MySQL servers over the Web. Since the phpMyAdmin’s interface
 
is based entirely in your browser, you will need a web server (such as LAMP) to
 
install phpMyAdmin.
phpMyadmin is a very powerfull tool that can be used to
 
minipulate mysql databases and also will alow you to keep track of other users as
 
well. Now that you have tested phpMyAdmin and seen what it is all about, you may
 
have decided to remove it from your system and not really sure how to go about doing it. well here we will
show you the basic command that are needed to do just that.
Install phpMyAdmin
- Open the Terminal,
and enter
sudo apt-get install phpmyadmin
- Press “y” for yes and then press enter to continue.
- You will be asked to choose the web server to be automatically configured by the install process, if you
installed the LAMP server then simply choose apache2 server by using (Tab) and and then use space to
toggle, once you have done that then (Tab) to the ok and again hit the space to except.
- Now the install needs to set up the database in mysql for phpmyadmin, you may wish to configure this
manually or you may choose to have it configured automatically. I would recommend that you choose the
auto configuration for the beginner. Make sure that yes is highlighted in red and press the space bar.
- Next you will be asked for the administration password for mysql, This is the password you entered during
installation of MySQL, This will allow the installation to create the database needed for phpmyadmin.
- Here is where you will choose the password for phpmyadmin, this will allow you to log onto phpmyadmin
in your web browser. Enter the password, press enter and then retype the password for confirmation.
- After a few more seconds the installation will be finished and you will be back at the command prompt. If
all went well you should see something like this.
Ubuntu software
Rev.:
155
-
December 3, 2012
 
22:40
Page
17
of
19