Setting up MySQL

This is a simple setup example, please refer to the MySQL documentation for details.

Setting up MySQL on Linux

Installing MySQL 5 on Linux using rpm

• To list all mysql packages installed: rpm -qa | grep -i mysql
• Remove all mysql packages listed: rpm -e package_names
• Find running process: ps aux | grep mysql
• Kill running process: kill -9 pid
• Get packages:
  • wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-server-5.0.27-0.glibc23.i386.rpm/from/http://mysql.mirrors.pair.com/
  • wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-client-5.0.27-0.glibc23.i386.rpm/from/http://mysql.mirrors.pair.com/
• Install packages: sudo rpm -ivh MySQL-server-5.0.27-0.glibc23.i386.rpm MySQL-client-5.0.27-0.glibc23.i386.rpm

Starting up MySQL

• /sbin/service mysql start

Creating database

• mysql -u root -p
• create database database_name default character set utf8;

Drop database

• mysql -u root -p
• drop database database_name;

Backup database

• mysqldump -u root -p database > database.dump

Restore database

• mysql -u root -p database < database.dump

Other useful mysql commands

• show databases;
• show tables;