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?

Continue reading MySQL user not connecting

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…