Go Back   SharingDVB All Tutorials sharing > Free CCcam Newcamd MDBox OBox > VPS Tutorials

Thread Tools Display Modes
Old 12-29-2014, 11:11 PM   #1
admin's Avatar
Join Date: Dec 2014
Posts: 227
Thumbs up How to Setup MySQL and PHPMyAdmin on VPS

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.

[[email protected] html]# cd var/www/html/
[[email protected] html]# wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.0.5/phpMyAdmin-4.0.5-all-languages.tar.gz
[[email protected] 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.

[[email protected] html]# mv phpMyAdmin-4.0.5-all-languages phpMyAdmin
[[email protected] www]# cd phpMyAdmin
[[email protected] phpMyAdmin]# mkdir config
[[email protected] phpMyAdmin]# chgrp apache config
[[email protected] 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 [email protected] -L 80:IPADDRESSOFSERVER:80 -N

admin is offline   Reply With Quote
Old 12-29-2014, 11:27 PM   #2
Super Moderator
Join Date: Dec 2014
Posts: 89

thank you admin good service
skyit is offline   Reply With Quote

« Previous Thread | Next Thread »
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 01:33 PM.
[email protected]
A vBSkinworks Design