By default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. MySQL Remote Access You need type the following commands which will allow remote connections. Step # 1: Login Using SSH (if server is outside [...]
InnoDB is one of MySQL storage engines, it supports transactions, row-level locking, and foreign-keys. However, by default, InnoDB is not enabled by APACHE. To enable it, locate the my.cnf configuration file (normally in C:/Apache/mysql/bin directory) and search for the following lines: # Comment the following if you are using InnoDB tables skip-innodb #innodb_data_home_dir = “C:/xampp/mysql/” [...]
Obvioulsy, a web server needs to be running on the Windows machine. Refer to this post for instructions on how to install Apache2 in Windows. Download ActivePerl from http://www.activestate.com/Products/ActivePerl/?mp=1. Click on Free Download to start the download process. There is no need to input any contact info. Just leave it blank and press ‘Next’ to [...]
xampp provides a convenient way to quickly and easily install and setup a web server that works without much configuration. However, permalinks feature won’t work with the default installation of xampp, even though you can properly customize the permalinks structure to create the .htaccess file. When you click on any permalinks, your WordPress blog will [...]
If you want to install and set up a dynamic web server with Apache, a lot of applications such as Apache web server, mySQL database, PHP and Perl scripting language, and not to mention important extensions and tools to manage the web server’s applications. It’s not a easy and simple task. But luckily, there is [...]
XAMPP from Apache Friends is a collection of free open source apps that make it easy to install Apache distribution containing MySQL, PHP and Perl. There are four XAMPP distributions for Windows, Linux, Mac OS X and Solaris. To set up an Apache web server with XAMPP, simply download and extract XAMPP, and the Apache [...]
I have installed mysql-5.0.67-win32. ‘InnoDB‘ is ‘DISABLED’ when executing ‘show engines’. According to documentation MySql is compiled with support of inno-db (From doc: A value of DISABLED occurs either because the server was started with an option that disables the engine, or because not all options required to enable it were given.) In my.ini I [...]
(5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5) (5 out of 5)