Page 6 - Open Soource Technologies 304.indd

Sarabjit Kumar, Lovely Professional University Unit 1: My SQL

Unit 1: My SQL Notes

CONTENTS
Objectives
Introduction

1.1 Current and Future Versions of My SQL
1.1.1 How to Get My SQL
1.2 Installing My SQL

1.2.1 Installing My SQL on Linux/Unix
1.2.2 Installing My SQL on Mac OS X
1.2.3 Installing My SQL on Windows

1.3 Basic Security Guidelines
1.3.1 Starting My SQL
1.3.2 Securing Your My SQL Connection

1.4 Summary
1.5 Keywords
1.6 Self Assessment Questions
1.7 Review Questions

1.8 Further Reading

Objectives

After studying this unit, you will be able to:

• Discuss current and future versions of My SQL.
• Explain installing My SQL.

• Understand basic security guidelines in My SQL.

Introduction

My SQL is the world’s most popular open source database software, with over 100 million
copies of its software downloaded or distributed throughout it’s history. With its superior speed,
reliability and ease of use, My SQL has become the preferred choice for Web, Web 2.0, SaaS,
ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates
the major problems associated with downtime, maintenance and administration for modern,
online applications.
Many of the world’s largest and fastest-growing organizations use My SQL to save time
and money powering their high-volume Web sites, critical business systems, and packaged
software—including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube,
Wikipedia, and Booking.com.

LOVELY PROFESSIONAL UNIVERSITY 1