• Contact
  • Contact Us
  • Disclamer
  • Home 1
  • Home 2
  • Home 3
  • Privacy Policy
Friday, May 23, 2025
How VPS - How to use/setup VPS
  • Login
  • Home
  • Management guides
    • Web servers software
      • Directadmin
      • Hocvps Script
      • Centmin Mod
      • CWP
      • Kloxo-MR
      • Plesk
    • Control Panels
    • Securing VPS/Servers
      • SSL Certificates
      • Upgrading
      • Authentication
  • Operating System
    • CentOS
    • Fedora
    • Debian
    • Linux
    • Arch
    • BSD
    • CoreOS
  • Reviews
  • Coupon
    • Domain Coupon
    • Hosting Coupon
No Result
View All Result
  • Home
  • Management guides
    • Web servers software
      • Directadmin
      • Hocvps Script
      • Centmin Mod
      • CWP
      • Kloxo-MR
      • Plesk
    • Control Panels
    • Securing VPS/Servers
      • SSL Certificates
      • Upgrading
      • Authentication
  • Operating System
    • CentOS
    • Fedora
    • Debian
    • Linux
    • Arch
    • BSD
    • CoreOS
  • Reviews
  • Coupon
    • Domain Coupon
    • Hosting Coupon
No Result
View All Result
How VPS - How to use/setup VPS
No Result
View All Result
Home VPS/Servers management guides

How-to: Setup MySQL and PHPMyAdmin on a VPS.

How VPS by How VPS
November 2, 2018
in VPS/Servers management guides
0
How-to: Setup MySQL and PHPMyAdmin on a VPS.
0
SHARES
477
VIEWS
Share on FacebookShare on Twitter

Contents

  1. Installing MySQL
  2. Installing phpMyAdmin

How-to: Setup MySQL and PHPMyAdmin on a VPS.MySQL is a powerful open source Relational Database used by many dynamic websites across the internet.

Originally developed in 1994 by Michael Widenius and David Axmark. MySQL was originally corporately sponsored under the name  MySQL AB. In 2008 MySQL AB was acquired by Sun Microsystems. In 2010, Oracle purchased Sun Microsystems. However MySQL is released under the GNU Public License therefore its continued support is still community based.

MySQL is commonly used as the database for most LAMP stacks or other AMP stacks. We have written a previous article on setting up a LAMP stack if you need to read up on that subject.



phpMyAdmin is a powerful PHP based gui for MySQL. phpMyAdmin was originally developed by Tobias Ratschiller, however has since gained more of a community support and it is used by developers everywhere.

Assuming you have already installed and configured Apache with PHP5 as your web server, this How-to will guide you through the remaining steps to install MySQL and phpMyAdmin.

Installing MySQL

First you need to install MySQL. On CentOS this couldn’t be easier just run the following:

 

yum install mysql-server

chkconfig mysqld on

/etc/init.d/mysqld start

 

Installing phpMyAdmin

Installing phpMyAdmin is almost as easy as installing MySQL, just a few more steps.

First you need to download and unzip the latest source from here. Once you download the files unzip in your servers web directory.

 

[root@ cent5 html]# cd var/www/html/

[root@ cent5 html]# wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.0.5/phpMyAdmin-4.0.5-all-languages.tar.gz

[root@ cent5 html]# tar xvf phpMyAdmin-4.0.5-all-languages.tar.gz

 

This will create a directory called phpMyAdmin-4.0.5-all-languages in your web root. I would suggest you rename it something more easy to remember. Also to setup phpMyAdmin you will need to create a directory called config and make it writeable by the www user, in our case apache.

 

[root@ cent5 html]# mv phpMyAdmin-4.0.5-all-languages phpMyAdmin



[root@ cent5 www]# cd phpMyAdmin

[root@ cent5 phpMyAdmin]# mkdir config

[root@ cent5 phpMyAdmin]# chgrp apache config

[root@ cent5 phpMyAdmin]# chmod 760 config

 

Next point your Browser to http://YourIPorHostName/phpMyAdmin/setup/

Select new server and enter your local MySQL server information, and click save. You should now be able to access your MySQL Database Server and create new databases, tables etc.

You should take additional steps to secure phpMyAdmin and do not leave this directory open to everyone. Use some form of secure authentication over SSL to accomplish this! Additionally you can block access to http via IPTables, and then access it my tunneling port 80 over an SSH session.

 

ssh -f ssh -f root@ cent5 -L 80:IPADDRESSOFSERVER:80 -N

 

 

Previous Post

How-to: Install LAMP stack on your Linux VPS

Next Post

How-to Setup a VPS to host websites.

Next Post
How-to Setup a VPS to host websites.

How-to Setup a VPS to host websites.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

No Result
View All Result

Recent Post

Install Imagemagick on CentOS
CentOS

Install Imagemagick on CentOS

by How VPS
June 28, 2023
0

This is how I installed Imagemagick on a vanilla CentOS server Start off by installing the prerequisites yum install php-pear...

Read more
how to Check phpinfo

How to Check phpinfo of Hosting or VPS?

June 28, 2023
Failed to download metadata for repo 'appstream' on Centos 8

How to fix error: Failed to download metadata for repo ‘appstream’ on Centos 8

February 25, 2022
How to Fix MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"?

How to Fix MySQL Error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed”?

November 17, 2020
How to optimize Mysql or MariaDB

How to optimize Mysql or MariaDB

November 3, 2020

Recent News

  • Install Imagemagick on CentOS
  • How to Check phpinfo of Hosting or VPS?
  • How to fix error: Failed to download metadata for repo ‘appstream’ on Centos 8

Category

  • Arch
  • Authentication
  • Backups
  • BSD
  • Centmin Mod
  • CentOS
  • Control Panels
  • CoreOS
  • CWP
  • Debian
  • Directadmin
  • Encryption
  • Fedora
  • Firewalls
  • Hocvps Script
  • Hosting providers
  • Kloxo-MR
  • Linux
  • Mitigations
  • Operating System
  • Plesk
  • Reviews
  • Securing VPS/Servers
  • Security Patches
  • SSL Certificates
  • Uncategorized
  • Upgrading
  • VPS/Servers management guides
  • Vulnerability Detection
  • Web servers software
  • Webhosting Control Panel
  • About
  • Advertise
  • Careers
  • Contact

© 2025 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Management guides
    • Web servers software
      • Directadmin
      • Hocvps Script
      • Centmin Mod
      • CWP
      • Kloxo-MR
      • Plesk
    • Control Panels
    • Securing VPS/Servers
      • SSL Certificates
      • Upgrading
      • Authentication
  • Operating System
    • CentOS
    • Fedora
    • Debian
    • Linux
    • Arch
    • BSD
    • CoreOS
  • Reviews
  • Coupon
    • Domain Coupon
    • Hosting Coupon

© 2025 JNews - Premium WordPress news & magazine theme by Jegtheme.

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In
Thabet