MySQL Tutorials

Reset MySQL root password

In: MySQL / Miscellaneous

Tutorial teach administrator on how to reset MySQL root password if forgotten. But, this technique require the server root password…

MySQL max_allowed_packet & MySQL gone away problem

In: MySQL / Miscellaneous

Tutorial to solve the MySQL gone away issue by change the max_allowed_packet size…

MySQL repair crashed table

In: MySQL / Tables and Fields

Tutorial to teach MySQL administrator on repair tables that being corrupted…

Check MySQL database size

In: MySQL / Miscellaneous

Tutorial teach administrator using a query to checking database size…

Backing Up And Restoring Your MySQL Database

In: MySQL / Basics

If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent…

Optimizing MySQL Queries and Indexes

In: MySQL / Miscellaneous

Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes…

Using MySQL Database with PHP Programming

In: MySQL / Basics

Now it is time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination…

Database Driven Website Using PHP & MySQL: Part 1

In: MySQL / Miscellaneous

Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. This book…

Database Driven Website Using PHP & MySQL: Part 2

In: MySQL / Miscellaneous

This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data into a table, and…

Database Driven Website Using PHP & MySQL: Part 3

In: MySQL / Miscellaneous

This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi-purpose…