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

Reply
 
Thread Tools Display Modes
Old 12-29-2014, 11:11 PM   #1
admin
Administrator
 
admin's Avatar
 
Join Date: Dec 2014
Posts: 218
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:
Code:
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.

Code:
[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.

Code:
[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 user@IPADDRESSOFSERVER -L 80:IPADDRESSOFSERVER:80 -N

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



thank you admin good service
skyit is offline   Reply With Quote
Reply

« 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 12:57 PM.
SharingDVB@
A vBSkinworks Design