In most cases if you are on a shared host, you will not see a php.ini file in your directory. If you do not see one, then create a file called php.ini and upload it in the root folder. In that file add the following code:
php -i | grep 'php.ini'
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 300
The main issue here is that apache does not have access to the folders. The default permission is given to the ec2-user in the AMI.
run this in your terminal and you should be good to go.
sudo chown -R apache:apache /var/www/html Continue reading “WordPress on EC2 Requires FTP Credentials”
The can use phpMyAdmin to execute this SQL
DELETE FROM wp_comments WHERE comment_approved = 0
sudo nano /etc/httpd/conf.d/phpMyAdmin.conf
Require ip xxxx (your IP)
sudo service httpd restart
Once you have wp-config open, add this line of code to the bottom:
define( ‘WP_ALLOW_REPAIR’, true );
This line will enable you to optimize and repair your database by navigating to www.yourwebsite.com/wp-admin/maint/repair.php (just replace “yourwebsite.com” with your actual URL).