PHP – Page 2 – My Brain BLOG

MySQL user not connecting

Problem:
Windows Server 2016, IIS Website, Setup a MySQL server/database, setup a WordPress website, quickly connect with root and root-password. Everything works fine!

Now you want things more secured, so you add a MySQL user with a password and rights to only the wordpress database. Change wp-config.php with the new login and you get a “Error Establishing a Database Connection” when accessing the WordPress website or admin.

Change back to root and the problem is solved. How to fix this?

PHP mail on IIS Windows 2016 Server

How?

IIS MANAGER
Configure SMTP E-mail here to send using an external mailserver will work for ASP scripts – Deliver to SMTP server with credentials

IIS 6.0 MANAGER
Configure the SMTP server here to make the PHP mail-function work.
Properties:
Access-Connection – Grant only your own server IP and 127.0.0.1
Access-Relay – Grant only your own server IP and 127.0.0.1
Delivery-outbound security – Basic Auth login details TLS
Delivery-Advanced – Smart Host smtp server name

PHP.INI
SMTP = 127.0.0.1
smtp_port = 25

SERVICES
configure SMTPSVC to start automatic, so you won’t go crazy after your next reboot…

Display all PHP Errors and Warnings

When debugging PHP I find myself searching again and again for this little piece of code to display the PHP errors. So here it is for future reference…
If you wish to see all the PHP errors and warnings in your script, simply include the following bit of code:

error_reporting(E_ALL);
ini_set(‘display_errors’, ‘1’);

Now, continue to beat your head against the keyboard while you hunt down that missing semicolon or closing parenthesis. Need help, contact My Brain.