Even if you've never used MySQL before, this Visual QuickStart Guide will have you up and running with the worldas most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology author Larry Ullman uses his trademark crystal-clear instructions and friendly prose to introduce you to everything thatas new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to interact with MySQL using SQL, the language common to all databases. The interface examples show how to use MySQLas own tools and how to use three popular programming languages (PHP, Perl, and Java). The book covers MySQL versions 3 and 4, as well as everything new in the eagerly anticipated version 5. Along the way, you'll find extensive coverage of MySQL installation, administration, database design, as well as its use with various programming languages, database programming techniques, utilities, advanced MySQL and SQL, and more! ac Takes an easy, visual approach to teaching MySQL, using pictures to guide you through the software and show you what to do. ac Works like a reference bookayou look up what you need and then get straight to work. ac No long-winded passagesaconcise, straightforward commentary explains what you need to know. ac Affordably priced, because buying a computer book shouldnat be an investment in itself. ac Companion Web site at www.DMCInsights.com/mysql2 contains complete source code for examples in the book, online resources, extra scripts and tutorials, updates, a reader forum, and more.The first line establishes a userathat can connect from any hostaand password without granting any privileges at all. ... aIDENTIFIED BY a#39;BroWs1nga#39;; except that would also give this user permission to select from the mysql database, which is not a good idea. ... The SHOW GRANTS command lists the privileges for a user.
|Title||:||MySQL, Second Edition|
|Publisher||:||Peachpit Press - 2006-05-10|