suvozy/Setup.md

#Launch an instance http://docs.aws.amazon.com/AmazonVPC/latest/GettingStartedGuide/GetStarted.html

Security group

phpMyAdmin

Inbound

Type	Protocol	Port Range	Destination
SSH	TCP	22	0.0.0.0/0
HTTP	TCP	80	0.0.0.0/0

Outbound

Type	Protocol	Port Range	Destination
All traffic	All	All	0.0.0.0/0

Assign phpMyAdmin to the new EC2 instance and visit

http://YOUR_SERVER_IP

#Setup EC2

chmod 400 key.pem
ssh -i key.pem ec2-user@YOUR_SERVER_IP

##Root login

sudo -i

##Update and install

yum -y update
yum install -y gcc make gcc-c++
yum install -y php55-mysqlnd php55 php55-xml php55-mcrypt php55-mbstring php55-cli mysql55 mysql55-server httpd24

-y will tell yum to say yes to all questions.

##Start your engines

service httpd start
service mysqld start

##MySQL Setup

/usr/bin/mysqladmin -u root password SUPERSECUREPASSWORD

##Setup startup scripts for apache and MySQL

cd /etc/rc.d/rc3.d
rm K15httpd
rm K36mysqld
ln -s ../init.d/mysqld S30mysql
ln -s ../init.d/httpd S85httpd

##Install phpMyAdmin

cd /var/www/html
wget https://files.phpmyadmin.net/phpMyAdmin/4.4.13.1/phpMyAdmin-4.4.13.1-english.tar.gz
tar -xzvf phpMyAdmin-4.4.13.1-english.tar.gz -C /var/www/html
mv phpMyAdmin-4.4.13.1-english phpmyadmin
rm -rf phpMyAdmin-4.4.13.1-english.tar.gz

check for updates: https://www.phpmyadmin.net/downloads/

We now need to add permission for this folder, find the user group (should be apache) with this command:

egrep 'User|Group' /etc/httpd/conf/httpd.conf

Which will return:

User apache
Group apache

And last, run this command to associate that user with the phpmyadmin folder:

chown -R apache.apache phpmyadmin/

##Install Config

cd /var/www/html/phpmyadmin/
cp config.sample.inc.php config.inc.php
mkdir config
chmod o+rw config
cp config.sample.inc.php config/config.inc.php
chmod o+w config/config.inc.php

##Setup Config

nano /var/www/html/phpmyadmin/config.inc.php

$cfg['blowfish_secret'] = '{^QP+-(3mlHy+Gd~FE3mN{gIATs^1lX+T=KVYv{ubK*U0V';

reference: http://www.question-defense.com/tools/phpmyadmin-blowfish-secret-generator

##Restart Server

service httpd restart

##Setup phpMyAdmin

http://YOUR_SERVER_IP/phpmyadmin/index.php

with username root password SUPERSECUREPASSWORD

##Remove config folder

rm -rf config

#Setup RDS Setup RDS with username awsuser password mypassword

##Edit Config

nano /var/www/html/phpmyadmin/config.inc.php

$cfg['Servers'][$i]['host'] = 'mydbinstance.abcdefghijkl.us-east-1.rds.amazonaws.com:3306'

##Access phpMyAdmin

http://YOUR_SERVER_IP/phpmyadmin/index.php

with username awsuser password mypassword

##phpinfo

nano /var/www/html/info.php

<?php phpinfo(); ?>

http://YOUR_SERVER_IP/info.php

##Test db connection

nano /var/www/html/db_test.php

<?php
$link = mysqli_connect('mydbinstance.abcdefghijkl.us-east-1.rds.amazonaws.com', 'awsuser', 'mypassword', 'information_schema', 3306);
var_dump($link);

<?php
$link = mysqli_connect('localhost', 'root', 'SUPERSECUREPASSWORD', 'information_schema');
var_dump($link);

http://YOUR_SERVER_IP/db_test.php

#Git Deploy https://gist.github.com/oodavid/1809044

lmon · 2014-12-16T15:50:41Z

thank you!
(you have a typo: "Git Depoly" should be "Git Deploy") 😄

pakwai122 · 2015-03-02T05:14:40Z

sudo yum install -y php55-mysqlnd php55 php55-xml php55-mcrypt php55-mbstring php55-cli mysql55 mysql55-server httpd24

sudo yum groupinstall -y "Web Server" "MySQL Database" "PHP Support"

What are the difference between these two scripts? currently, I'm using ec2 to host a Wordpress site with your server script to setup which is nice, but the script looks missed sth that "groupinstall" has. How can I do the groupinstall to connect the RDS plus install the phpmyadmin?? cuz I tried the groupinstall and it failed to connect the RDS and install phpmyadmin, please help.

tywoplenty · 2015-03-25T20:13:57Z

Thank you =)

asacolips · 2015-03-26T14:21:46Z

This is awesome, thank you! I've been struggling with getting php 5.5 running on ec2 and this process worked flawlessly.

orange7986 · 2015-04-16T01:46:31Z

So cool! thank you.

ghostidentity · 2015-05-12T11:25:51Z

Very helpful, thank you.

sameernagegowda · 2015-07-08T10:31:01Z

Brilliant stuff.. thanks a lot

mahendramcoders · 2015-09-02T06:14:39Z

i am executing this command service mysqld start it getting error comman not unrecongnised service

rijasmk · 2015-10-01T05:59:56Z

To upgrade PHP version http://stackoverflow.com/questions/29206795/how-to-install-php5-6-in-amazon-linux/31602840#31602840

vint2000 · 2015-10-14T16:04:06Z

How do I create an ALIAS for phpmyadmin, for security reasons

adeelahmed · 2016-01-14T19:14:28Z

Thanks very much, A great help!!

kaizenlpi · 2016-01-21T01:23:31Z

Tyvm! On the last step, I tried http://YOUR_SERVER_IP/db_test.php with my ec2's url. The browser returns: object(mysqli)#1 (19) { ["affected_rows"]=> int(0) ["client_info"]=> string(79) "mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $" ["client_version"]=> int(50011) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(0) ["host_info"]=> string(61) "rackspace.cakmjmk8ufvv.us-east-1.rds.amazonaws.com via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(10) "5.6.23-log" ["server_version"]=> int(50623) ["stat"]=> string(134) "Uptime: 8363 Threads: 2 Questions: 4473 Slow queries: 0 Opens: 81 Flush tables: 1 Open tables: 74 Queries per second avg: 0.534" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(74) ["warning_count"]=> int(0) }

What happened?

makkaba · 2016-04-16T01:04:57Z

thanks a lot !!

Creativefriends · 2017-02-07T16:51:27Z

Hey buddy, am having some issues can I hire you to set things up? the wordpress is already done, but not able to connect to existing database, please email: awesome(dot)info@creativefriends(dot)asia
thanks

jeffmcneill · 2017-07-29T05:14:54Z

Install PhpMyAdmin from the Amazon EPEL Repository, after Enabling EPEL:

yum-config-manager --enable epel
yum install phpmyadmin

Edit the file /etc/httpd/conf.d/phpMyAdmin.conf and replace 127.0.0.1 with the ip address of the client.

nano /etc/httpd/conf.d/phpMyAdmin.conf

Restart the web server

service httpd restart

Test to see if it works

https://host.domain.tld/phpmyadmin/

suvozy/Setup.md

Select an option

No results found

Select an option

No results found

Security group

Inbound

Outbound

lmon commented Dec 16, 2014

Uh oh!

pakwai122 commented Mar 2, 2015

Uh oh!

tywoplenty commented Mar 25, 2015

Uh oh!

asacolips commented Mar 26, 2015

Uh oh!

orange7986 commented Apr 16, 2015

Uh oh!

ghostidentity commented May 12, 2015

Uh oh!

sameernagegowda commented Jul 8, 2015

Uh oh!

mahendramcoders commented Sep 2, 2015

Uh oh!

rijasmk commented Oct 1, 2015

Uh oh!

vint2000 commented Oct 14, 2015

Uh oh!

adeelahmed commented Jan 14, 2016

Uh oh!

kaizenlpi commented Jan 21, 2016

Uh oh!

makkaba commented Apr 16, 2016

Uh oh!

Creativefriends commented Feb 7, 2017

Uh oh!

jeffmcneill commented Jul 29, 2017 •

edited

Loading

Uh oh!

suvozy/Setup.md

Security group

Inbound

Outbound

lmon commented Dec 16, 2014

Uh oh!

pakwai122 commented Mar 2, 2015

Uh oh!

tywoplenty commented Mar 25, 2015

Uh oh!

asacolips commented Mar 26, 2015

Uh oh!

orange7986 commented Apr 16, 2015

Uh oh!

ghostidentity commented May 12, 2015

Uh oh!

sameernagegowda commented Jul 8, 2015

Uh oh!

mahendramcoders commented Sep 2, 2015

Uh oh!

rijasmk commented Oct 1, 2015

Uh oh!

vint2000 commented Oct 14, 2015

Uh oh!

adeelahmed commented Jan 14, 2016

Uh oh!

kaizenlpi commented Jan 21, 2016

Uh oh!

makkaba commented Apr 16, 2016

Uh oh!

Creativefriends commented Feb 7, 2017

Uh oh!

jeffmcneill commented Jul 29, 2017 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

jeffmcneill commented Jul 29, 2017 •

edited

Loading