#contents *Prerequisite [#d8ba79a7] -CentOS installation (You can refer [[Overall/CentOS]]) *Install&Setup [#j1b518a8] :Step.1|Install mysql server $ yum install mysql-server mysql-devel :Step.2|Edit mysql configration file. $ vi /etc/my.cnf [mysqld] ... character-set-server=utf8 [mysql] default-character-set=utf8 :Step.3| If you wish to connect database from remote host, you need to execute the following commands. $ mysql -u root > GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; *HowToUse [#p8f70496] **Start Process [#t2ca68ea] :Step.1|Start service $ sudo /etc/rc.d/init.d/mysqld start :Step.2|Config chkconfig so that mysqld is launched by default. $ sudo chkconfig mysqld on :Step.3|Stop service $ sudo /etc/rc.d/init.d/mysqld stop **Create Database and User [#te5d2855] :Step.1| Login mysql with root. $ mysql -u root -p :Step.2| Create database. > create database <dataase name>; > grant all privileges on <database name>.* to '<user name>' identified by '<password>'; *Author [#d4ec55d3] S.Yatsuzuka