MySQL

MySQL for Beginners

Tags: cPaneldatabaseMySQLmysqldumpphpmyadminrepairWHM

Published on : February 4, 2011 by

MySQL for Beginners

In this post, I’ll explain some MySQL basics that would be very useful for beginners Reset MySQL root password Log in as Root and Stop the MySQL daemon. Then Start the MySQL daemon and skip the grant tables which store the passwords. Now you should be able to connect to mysql without a password. If […]

Continue Reading...


List out all the mysql database tables with storage engine INNODB

Tags: databasesinnodbMySQLstorage engine

Published on : October 19, 2010 by

List out all the mysql database tables with storage engine INNODB

Simple 🙂 Issue the mysql command

Continue Reading...


MySQL Storage Engines – an overview, their limitations and an attempt for comparison

Tags: comparison of storage enginesinnodbinnodb or myisammyisamMySQLstorage engines

Published on : August 31, 2010 by

MySQL Storage Engines – an overview, their limitations and an attempt for comparison

MySQL is a database management system. Most of us are using MySQL database and majority don’t know how to choose the data base engines, what are the different types of storage engines available in mysql and how they differ from each other. In this article let me give you a brief idea about the Storage […]

Continue Reading...


How do I reset the root mysql pass, lxadmin created ?

Tags: forgot passhypervmlxadminMySQLVPS

Published on : April 30, 2009 by

How do I reset the root mysql pass, lxadmin created ?

Oh, do it from the GUI lxadmin gives you OR else, do it console based way. # cd /usr/local/lxlabs/lxadmin/httpdocs/ # lphp.exe ../bin/common/misc/reset-mysql-root-password.phps

Continue Reading...


How to upgrade MySQL 5.0 to MySQL 5.1 in a cPanel server

Tags: cPanelMySQLmysql version 5.1

Published on : April 15, 2009 by

How to upgrade MySQL 5.0 to MySQL 5.1 in a cPanel server

Our database management service team got a similar request two years back when we had to upgrade MySQL version 4.0 to MySQL 5.0. We are listing here the same approach for the current needs of upgrading MySQL 5.0 to 5.1 File responsible for the MySQL version is /var/cpanel/cpanel.config Open it, find the variable mysql-version and […]

Continue Reading...


Let's Connect

Categories

Your Cart

Cart is empty.

Subtotal
₹0.00
APPLY
0
Send this to a friend