Tag Archives: Database

Jun 9 2013

How to install phpMyAdmin on Ubuntu 13.04


Install phpMyAdmin on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

Install phpMyAdmin on Ubuntu 11.10 or 11.04 or 10.10 or 10.04 LTS

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

Features:

  1. Web interface
  2. MySQL database management
  3. Import data from CSV and SQL
  4. Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF library), ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others
  5. Administering multiple servers
  6. Creating PDF graphics of the database layout
  7. Creating complex queries using Query-by-example (QBE)
  8. Searching globally in a database or a subset of it
  9. Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  10. Active query monitor (Processes)

How to install it?

Update the UBUNTU Machine

Upgrade Ubuntu Packages

Upgrade Ubuntu Packages

Upgrade Ubuntu Packages

Upgrade Ubuntu Packages

Install phpMyAdmin

install phpMyAdmin

install phpMyAdmin

Done!!!

Getting Started with Ubuntu 10.10

A Complete Beginner’s Manual for Ubuntu 10.04 (Lucid Lynx)

Ubuntu: An Absolute Beginners Guide:

The Incredible Guide to NEW Ubuntu (Karmic Koala)

Old Computer, New Life: Restoring Old Hardware With Ubuntu

Computer Inside Your Computer: How To Use VirtualBox:

Related articles

About these ads
Jun 9 2013

Install MySQL Server on Ubuntu 13.04


Install MySQL Server on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

Install MySQL Server on Ubuntu 11.10 or 11.04 or 10.10 or 10.04 LTS

MySQL is a relational database management system (RDBMS)that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius‘ daughter, My. The SQL phrase stands for Structured Query Language.

Free-software-open source projects that require a full-featured database management system often use MySQL.

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack—LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python“.

Update the UBUNTU Machine

Update Ubuntu Packages

Update Ubuntu Packages

Update Ubuntu Packages

Update Ubuntu Packages

Install MySQL-Server

install mysql server

install mysql server

configure phpMyAdmin

configure phpMyAdmin

configure phpMyAdmin database

configure phpMyAdmin database

Database Administrator Password for MySQL Server

Database Administrator Password for MySQL Server

MySQL Application Password for phpMyAdmin

MySQL Application Password for phpMyAdmin

MySQL Application Password for phpMyAdmin confirmation

MySQL Application Password for phpMyAdmin confirmation

Done!!!

Getting Started with Ubuntu 10.10

A Complete Beginner’s Manual for Ubuntu 10.04 (Lucid Lynx)

Ubuntu: An Absolute Beginners Guide:

The Incredible Guide to NEW Ubuntu (Karmic Koala)

Old Computer, New Life: Restoring Old Hardware With Ubuntu

Computer Inside Your Computer: How To Use VirtualBox:

Related articles

Sep 16 2012

Licensing – PostgreSQL


 

PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.

PostgreSQL Database Management System
(formerly known as Postgres, then as Postgres95)

Portions Copyright (c) 1996-2011, The PostgreSQL Global Development Group

Portions Copyright (c) 1994, The Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN “AS IS” BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

References:

http://www.project-open.org/documentation/project_open_license

http://www.project-open.org/documentation/project_open_license_free

http://www.project-open.org/documentation/project_open_license_commercial

http://www.postgresql.org/about/licence/

http://www.aolserver.com/license/

http://en.wikipedia.org/wiki/Mozilla_Public_License

http://en.wikipedia.org/wiki/Free_software

http://en.wikipedia.org/wiki/AOLserver