Published on : February 4, 2011 by Vipin R.N
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 […]
Published on : October 19, 2010 by George K.
Simple 🙂 Issue the mysql command
Published on : August 31, 2010 by Sharafuddin M.A
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 […]
Published on : April 30, 2009 by Faheem P.
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
Published on : April 15, 2009 by Faheem P.
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 […]