Home >> Tag Archives: MySQL

Tag Archives: MySQL

MySQL Installation instruction for Linux Operating System

Dowload MySQL RPM files from http://dev.mysql.com/downloads/mysql/5.1.html Download the following files from the “Linux x86 generic RPM (dynamically linked) downloads” option. 1. Server 2. Client programs 3. Shared client libraries 4. Libraries and header files Now as root, install the rpm’s: rpm -i MySQL-server-5.1.20-0.i386.rpm rpm -i MySQL-client-5.1.20-0.i386.rpm rpm -i MySQL-devel-5.1.20-0.i386.rpm rpm -i MySQL-shared-5.1.20-0.i386.rpm (If you already have an earlier version of ... Read More »

Change MySQL root Password

mysqladmin is a command to change ROOT password To setup root password for first time, use mysqladmin command at shell prompt as follows: # mysqladmin -u root password NEWPASSWORD if you want to change (or update) a root password, then you need to use following command # mysqladmin -u root -p’oldpassword’ password newpass For example, If old password is Redhat, ... Read More »

How to take Backup & Restore Database in MySQL

Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. An examples on how to use mysqldump to backup and restore To backup: # mysqldump -u root -p(root_password) (database_name) > filename.sql To restore: # mysql -u root -p (root_password) (database_name) < filename.sql Read More »