Install Phpmyadmin Solaris

PhpMyAdmin is a web-based, open-source administration tool used for managing and installing web technologies on web servers, and is commonly used by popular web hosting services. The PhpMyAdmin application is an excellent addition to any Ubuntu Linux web server, as it makes taking care of tasks like database management, app installation.

7.4 Installing MySQL on Linux Using Native Package Managers

Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management systems. This section provides basic instructions for installing MySQL using those package management systems.

Native package installations can take care of the download and dependencies required to run MySQL, but the MySQL version will often be some way behind the currently available release. You will also normally be unable to install development releases, as these are not usually made available in the native repository.

Distribution specific instructions are shown below:

• Red Hat Linux, Fedora, CentOS

  For Red Hat and similar distributions, the MySQL distribution is divided into a number of separate packages, mysql for the client tools, mysql-server for the server and associated tools, and mysql-libs for the libraries. The libraries are required if you want to provide connectivity from different languages and environments such as Perl, Python and others.

  To install, use the yum command to specify the packages that you want to install. For example:

  MySQL and the MySQL server should now be installed. A sample configuration file is installed into /etc/my.cnf. An init script, to start and stop the server, will have been installed into /etc/init.d/mysqld. To start the MySQL server use service:

  To enable the server to be started and stopped automatically during boot, use chkconfig:

  Which enables the MySQL server to be started (and stopped) automatically at the specified the run levels.

  The database tables will have been automatically created for you, if they do not already exist. You should, however, run mysql_secure_installation to set the root passwords on your server.

• Debian, Ubuntu, Kubuntu

  On Debian and related distributions, there are two packages, mysql-client and mysql-server, for the client and server components respectively. You should specify an explicit version, for example mysql-client-5.1, to ensure that you install the version of MySQL that you want.

  To download and install, including any dependencies, use the apt-get command, specifying the packages that you want to install.

  Before installing, make sure that you update your apt-get index files to ensure you are downloading the latest available version.

  A sample installation of the MySQL packages might look like this (some sections trimmed for clarity):

  The apt-get command will install a number of packages, including the MySQL server, in order to provide the typical tools and application environment. This can mean that you install a large number of packages in addition to the main MySQL package.

  During installation, the initial database will be created, and you will be prompted for the MySQL root password (and confirmation). A configuration file will have been created in /etc/mysql/my.cnf. An init script will have been created in /etc/init.d/mysql.

  The server will already be started. You can manually start and stop the server using:

  The service will automatically be added to the 2, 3 and 4 run levels, with stop scripts in the single, shutdown and restart levels.

• Gentoo Linux

  As a source-based distribution, installing MySQL on Gentoo involves downloading the source, patching the Gentoo specifics, and then compiling the MySQL server and installing it. This process is handled automatically by the emerge command.

  DP Double Trouble, Part 2 has the sexy Christina Carter in hardcore boy-girl action. Storyline: Christina’s in Vegas on business and decides to see what Sin City has to offer her sexual desires. After hiring male escorts (Tommy Gunn and Marcus London) Part 2 picks up with Christina deep in the throws of hard 3-way sex.

  The MySQL server and client tools are provided within a single package, dev-db/mysql. You can obtain a list of the versions available to install by looking at the portage directory for the package:

  To install a specific MySQL version, you must specify the entire atom. For example:

  After installation, you should initialize the data directory and set the password for the MySQL root user (see Section 9.1, “Initializing the Data Directory”). Alternatively, use the configuration interface to perform those tasks:

  During installation, a sample configuration file is created for you in /etc/mysql/my.cnf, and an init script is created in /etc/init.d/mysql.

  To enable MySQL to start automatically at the normal (default) run levels, use this command:

phpMyAdmin is the graphical web-based database management tool for MySQL. phpMyAdmin is easy to use and provides most of the option’s to work and manage your MySQL server. It also provides an easy way to set up database replication between multiple MySQL hosts with easy step wizard.

This article will help you to install phpMyAdmin in Ubuntu systems using the apt package manager. To install phpMyAdmin on CentOS, Redhat and Fedora refer below link.

• How to Install phpMyAdmin on CentOS/RHEL.

Step 1 – Install LAMP Stack

We assume you already have installed LAMP on your system. If you do not have installed, Use the following command to install it. Below command will install Apache2, PHP5 and MySQL server in your Ubuntu, Debian and LinuxMint systems.

Step 2 – Install phpMyAdmin

After installing LAMP stack on your system, let’s install phpMyAdmin using the command in your Ubuntu system.

During installation it will prompt for selecting web server, you have installed on your system. Select appropriate web server you used.

Step 3 – Configure Apache2 for phpMyAdmin

The installer creates and an Apache configuration file /etc/phpmyadmin/apache.conf for phpMyAdmin. Also, create a soft link to be used by Apache. Make sure a soft link is created at /etc/apache2/conf-available/phpmyadmin.conf. In case a soft link is not created and enable phpMyAdmin.

After updating the above entry, restart Apache2 service using the following command

Step 4 – Access phpMyAdmin

You phpMyAdmin installation has been completed successfully. Open you favourite web browser and access following url to open phpMyAdmin, change the localhost with servers hostname or ip address.

Using single phpMyAdmin we can manage multiple MySQL servers by adding multiple remote MySQL server. Use this article to add multiple MySQL hosts in phpMyAdmin.