In this case I had done a restore from a MySQL 5.1 server to a MySQL 5.6 server. That was not too smart, because it broke the mysql database table structures and prevented me from logging in remotely. Local login worked both via the socket and TCP. mysql -u root -p -h remoteHostName Enter password: […]
Apache 2.4 changed the security configuration directives a bit. Here is an example using basic auth:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<Directory"/path/to/your/wordpress">
AllowOverride All
Options+FollowSymLinks+ExecCGI-Indexes
Order allow,deny
Allow from all
<RequireAll>
AuthType Basic
AuthName"Protected Resource"
AuthUserFile/path/to/your/.htpasswd
Require valid-user
</RequireAll>
</Directory>
What tripped me up for a while was that I still had the Require all granted directive inside the container, and that needed to be removed for the auth to work.
erics, August 25th, 2016 
Categories: How-To's, Technology Error, howto, login, mysql, mysql_upgrade, remote, Remote Login, tips
| 
No comments 
