jpeg or .png) 243
Links to an Image 244
Date Formatting 244
Links from Text 245
text/plain: link 245
text/plain: imagelink 246
Preserving the Original Formatting 247
Displaying Parts of a Text 247
Download Link 248
Hexadecimal Representation 248
SQL Pretty Printing 249
External Applications 249
External Application Example: In-Cell Sort 250
Summary 251
Chapter 17: Character Sets and Collations 253
Language Files and UTF-8 253
Versions of MySQL Prior to 4.1.x 254
Data Recoding 254
Character Sets 255
Choosing the Effective Character Set 256
The Impact of Switching 256
Importing and Exporting with Character Sets 257
MySQL 4.1.x and Later 258
Collations 258
The Home Page 259
Creating a Database 259
Available Character Sets and Collations 260
Effective Character Sets and Collations 260
The Database View 261
The Table View 262
Importing and Exporting with Character Sets 263
Server View 263
Kanji Support 263
Summary 264
Chapter 18: MySQL 5.0 Features 265
Observations on the History of MySQL 5.0 265
Views 266
Manually Creating a View 266
Right Panel and Views 267
Creating a View from Results 268
Table of Contents
[ x ]
Renaming a View 270
Performance Hint 270
Routines: Stored Procedures and Functions 270
Creating a Stored Procedure 271
Changing the Delimiter 271
Entering the Procedure 271
Testing the Procedure 272
Manipulation 272
Manually Creating a Function 273
Testing the Function 274
Exporting Stored Procedures and Functions 274
Triggers 275
Manually Creating a Trigger 276
Testing the Trigger 277
Information_schema 277
Profiling 278
Summary 279
Chapter 19: MySQL Server Administration 281
Entering the Server View 281
User and Privileges Management 282
The User Overview 282
Adding a User 283
User Name 284
Host 284
Password 284
Database Creation and Rights 285
Global Privileges 285
Resource Limits 285
Editing a User 286
Edit Privileges 286
Database-Specific Privileges 286
Changing the Password 288
Changing Login Information or Copying a User 289
Removing a User 290
Database Information 290
Enabling Statistics 291
Sorting Statistics 291
Checking the Database Privileges 291
Dropping Selected Databases 292
Server Operations 292
Server Status Verification 292
The General Status Page 292
InnoDB Status 293
Table of Contents
[ xi ]
Server Variables 294
Server Processes 294
Storage Engines 295
The Binary Log 296
Summary 296
Chapter 20: Troubleshooting and Support 297
System Requirements 297
Base Configuration 298
Solving Common Errors 298
Error Messages 298
Cannot Load MySQL Extension 298
MySQL Said: Can't Connect to Local MySQL Server 299
Socket Problem (Linux/UNIX) 299
Named Pipe Problem (Windows) 299
Error # 2003: The Server is not Responding 299
MySQL Said: Access Denied 300
When Using http Authentication 300
When Using http, cookie, or config Authentication 300
Access Denied .
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25