To allow remote access to MySql first create a MySql user and assign host as %. CREATE USER ‘newuser’@’%’ IDENTIFIED BY ‘password’; then grant privileges GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’%’; then flush privileges FLUSH PRIVILEGES; You may need to add the following to /etc/mysql/my.cnf to listen for all ip’s instead of […]
Tag: apache
WAMP allow Phpmyadmin access remotely
Edit the file C:\wamp\alias\phpmyadmin.conf Change the line Require local to Require all granted Wampserver 2.5
Wamp Configuration Virtual Hosts
This guide will change the document root, create a virtual host, bypass proxy(if behind corporate server)for the virtual host. 1. Change 2 entries in httpd.conf DocumentRoot “c:/wamp/www/” to DocumentRoot “d:/webdir/” and <Directory “c:/wamp/www/”> to <Directory “d:/webdir/”> 2. Search for and uncomment the line below to enable virtual hosts # Virtual hosts Include conf/extra/httpd-vhosts.conf 3. Add […]
Force Files To Download Instead Of Open In Web Browser
You can change the file directivies for a folder by adding a .htaccess file in the folder and including the following code: <IfModule mod_headers.c> <FilesMatch “\.(?i:mp3|ogg)$”> ForceType application/octet-stream Header set Content-Disposition attachment </FilesMatch> </IfModule> This will force .mp3 and .ogg files to prompt for action rather than open with the default browser setting. The IfModule […]
Prevent Access And Directory Listing To A Folder Using .htaccess
If someone browses to a folder on your website that does not have an index file it will, by default, list the directory’s contents. If you have an Apache based web server you can prevent access to this folder by placing a .htaccess file within it containing the following code: Options -Indexes This can also […]