Mysql

From WebHostingNeeds.com

MySQL is popular open source database program.

Contents 1 INSTALLATION 2 WORKING WITH MYSQL 3 MANAGING MYSQL 4 Securing MySQL 5 BACKUP 6 OPTIMIZE MYSQL 7 UTF 8 8 PASSWORD 9 ERRORS

INSTALLATION

• Installing latest version of MySQL from mysql.com
• Installing MySQL from source on linux
• How to move MySQL data directory

WORKING WITH MYSQL

• create mysql database
• creating mysql user account
• repair mysql table
• repair mysql database
• Drop or delete a table in MySQL
• Repair MyISAM table

MANAGING MYSQL

• mysqladmin processlist
• mysqladmin status
• show variables
• How do I know when to adjust my query cache sizes in MySQL
• How can I monitor what my MySQL server is doing

Securing MySQL

• Securing MySQL: step-by-step
• How can I secure my MySQL server

BACKUP

• Backup MySQL Database
• mysqldump

OPTIMIZE MYSQL

• mytop
• optimize mysql
• optimize mysql my.cnf
• enable slow log in mysql
• MySQL log slow queries
• mysqladmin
• Install MySQL Performance Tuning Primer Script
• innotop
• Find site with high mysql usage
• Limit MySQL connections for users
• Using the New MySQL Query Profiler

UTF 8

• convert mysql database to utf8
• php script to convert database to utf8

PASSWORD

• How to reset your mysql password
• How to change mysql root password
• Change a MySQL user password
• Reset MySql root Password in Windows

ERRORS

• ERROR 1030 HY000 Got error 28 from storage engine
• mysql Incorrect information in file