Category Archives: MySQL

Apache CentOS Linux MySQL PHP

LAMP STACK

What is a LAMP Stack? “LAMP stack is a popular open source web platform commonly used to run dynamic web sites and servers. It includes Linux, Apache, MySQL, and PHP/Python/Perl and is considered by many the platform of choice for development and deployment of high performance web applications which require a solid and reliable foundation.” …

Database MySQL

Installing phpMyAdmin and connecting to remote database server

phpMyAdmin is one of the many tools that allows administrators the ability to effectively and efficiently work with their databases. This can can either be a local database or on a remote database. Where ever the location of your database, phpMyAdmin will easily allow you to connect to both.   Installing phpMyAdmin This can be done …

Administration Database MySQL

How to Display MySQL Storage Engines

How to Display MySQL Storage Engines From the MySQL command line, issue the following command: SHOW ENGINES; You should receive a result similar to:   Typically the default storage engine will be set to MyISAM. This storage engine normally provides the best combination of performance and functionality, although it lacks transaction capabilities and uses table-level …

MySQL

Monitoring MySQL

Monitoring MySQL servers can be difficult in a way that a novice won’t be able to monitor MySQL that easily. MySQL gives a comprehensive list of variables to check your server’s health and performance. 1. Check MySQL Status Yes, this is the first thing you should be looking at! It would not make sense to monitor your …

MySQL

MySQL Basic fundamentals

A Basic MySQL Tutorial    Introduction: MySQL MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL . Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, …

MySQL

How can I convert my MyISAM tables to InnoDB?

If you want to convert a MyISAM table to InnoDB, the process is fairly easy, but you can do something extra to speed things up. Before converting the table, adjust its order so that the primary key column is in order: ALTER TABLE tablename ORDER BY ‘primary_key_column'; This will pre-arrange the table so that it …

FreeBSD MySQL

Reset MySQL Password

Resetting a MySQL Root Password is one of the easiest things to do. However, finding documentation on how to do so can be challenging.   We as system administrators, have to reset passwords. Remembering how to do so, is a challenge all in itself. I decided to write a very simple and straight forward article …