Hello World from OSS Silicon Valley

• List of Backups
• View the diff.
• View the diff current.
• View the source.
• Go to HowToUse/MySQL/5.1.
  • 1 (2015-01-23 (Fri) 22:49:02)
  • 2 (2015-08-17 (Mon) 02:41:34)
  • 3 (2015-11-10 (Tue) 01:56:01)
  • 4 (2016-12-20 (Tue) 07:30:46)

---

_ Prerequisite

• CentOS installation (You can refer Overall/CentOS)

_ Install&Setup

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

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

_ Author

S.Yatsuzuka