What is XAMPP?
I decided that the quickest way to get you up and running with your own web server would be to use Apache Friend’s XAMPP. XAMPP is an application that combines Apache (the web server), MySQL (database), PHP (scripting language) and phpMyAdmin (database administration) all into one.
Read the rest of this entry »

• 0 Comments

In the Getting Started with MX Breadcrumbs tutorial, you will learn how to use MX Breadcrumbs for quickly inserting breadcrumbs in your site pages. Beginning with the files in your installation package, you will understand what MX Breadcrumbs is, how it works, and what you can do with it. Although much of the tutorial and sample site were done in PHP, the ColdFusion and ASP steps are nearly identical. The primary difference is in the database configuration and connection sections, where separate instructions are provided.
Read the rest of this entry »

• 0 Comments

This tutorial will guide you threw the installation process. In this install example we use CPanel hosting control panel system to create a new MySQL database. Your hosting control panel interface may be different but the tutorial may still be helpful.
Read the rest of this entry »

• 0 Comments

Not a Linux fan? Looking for a hassle?free way of setting up a PHP environment on your Windows box? Read as Matthew guides us through the process of installing Apache, MySQL and PHP on a Windows based machine, otherwise known as WAMP.

This article is geared towards people who want to code and test their own, or other people’s, php scripts on their Windows box. No advanced technical knowledge is assumed. This tutorial is unsuitable for advanced users. Why Apache and MySQL? Because they are available for free, quite easy to use and reliable. Why windows? Because there are many installation guides written for the Linux user, but Windows generally gets overlooked. And getting it all to work can be a real daunting task.
Read the rest of this entry »

• 0 Comments

A MySQL Enterprise subscription is the most comprehensive offering of MySQL database software, services and support; it ensures that your business achieves the highest levels of reliability, security, and uptime. An Enterprise Subscription includes:
1. The MySQL Enterprise Server – the most reliable, secure, and up-to-date version of the world’s most popular open source database
2. The MySQL Enterprise Monitor – An automated virtual DBA assistant that monitors all your MySQL Servers around-the-clock, identifies exceptions to MySQL best practices, and provides expert advice on fixing any problems discovered
3. MySQL Production Support – Technical and consultative support when you need it, along with regularly scheduled service packs, hot-fixes, and more.
Read the rest of this entry »

• 0 Comments

The customizable PHP script Generic HTML Form Processor is intended to assist researchers and students in quickly setting up surveys and experiments that can be administered via the Web. This script relieves researchers from the burdens of writing new cGi scripts and building databases for each Web study. Generic HTML Form Processor processes any syntactically correct HTML form input and saves it into a dynamically created open-source database. We describe five modes for usage of the script that allow increasing functionality but require increasing levels of knowledge of PHP and Web servers: The first two modes require no previous knowledge, and the fifth requires PHP programming expertise. use of Generic HTML Form Processor is free for academic purposes, and its Web address is www.goeritz.net/brmic.
Read the rest of this entry »

• 0 Comments

You can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 4.0 at the time of writing.
Read the rest of this entry »

• 0 Comments

SQLYog Enterprise Edition Version 6.55 Review
This software is one of the most popular GUI-based tools for MySQL. Most of the features of the software are geared to help the daily work of DBAs and developers. The software is rich in features and therefore this review will only highlight some of the cool capabilities.

Connection to Remote Servers
Most companies require you to use the ssh protocol to access their servers. While it is easy to setup your own ssh tunnel to connect to your remote database, it is quite cumbersome to do that. SQLYog allows you to easily do this and lets you save your secure MySQL connection. I use this all the time and I do not even think about ssh tunneling anymore.

On the downside, when I tried to connect to another database, the software opened a separate window for me. This made it difficult for me to switch from one window to another. This can be annoying if you want to compare two databases but it could also be a security measure so that you do not accidentally apply the wrong SQL statements to the wrong database.

Download pdf MySQL Magazine

• 0 Comments