Home >> MySQL

MySQL

How to Install ProFTP with virtual MySQL users

ProFTPd is the best FTP server I found for linux. It is not only very flexible, fast and secure, it also allows configurations with virtual MySQL users. This makes ProFTPd perfect for small and large configuration, inclusive of domain hosting services. This tutorial will walk you through the installation process of ProFTPd with a MySQL database. Install ProFTPd: # aptitude ... Read More »

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 »