How to reset MySQL root password

1. Stop mysql service shell> /etc/init.d/mysql stop 2. Start to MySQL server without password. shell> mysqld_safe –skip-grant-tables & 3. Connect to mysql server using mysql client. shell> mysql -u root Welcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 107Server version: 5.1.49-1ubuntu8.1 (Ubuntu)Type ‘help;’ or ‘h’ for help. Type…

How to install Drupal 7.0 on Ubuntu 10.04

Drupal is a free and robust content-management system which runs on LAMP(Linux, Apache, MySQL and PHP) server. PostgreSQL and MariaDB are also compatible with with Drupal. Before start Drupal 7.0 installation, we have to install following packages related to LAMP. Here, I’m imagine that Ubuntu 10.04 is already installed 🙂 – A web server. Apache…

Quick Reference of MySQL Data Types

    Quick Reference of MySQL Data Types There are three primary categories, which is true for almost every database software: Text Numbers Dates and times Within each of these, there are a number of variants—some of which are MySQL-specific—you can use. Choosing your column types correctly not only important what information can be stored…