[[ https://www.mysql.com/ | MySQL Home ]]

====== Configuration (mysql-5.5.27) ======
  * Under /etc/mysql, copy my-medium.cnf as my.cnf. (available template files are: my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf. my-medium.cnf is more than enough for small database such as "chemical")

  * Edit my.cnf: replace "skip-locking" with "skip-external-locking" to avoid warning message like "'--skip-locking' is deprecated" ([[http://rickie622.blog.163.com/blog/static/21238811201112883741967/ | ref]]). Update: for ver5.5.27, it is already "skip-external-locking" by default.

  * Install an initial database. (i.e., create the required user databases and put them in the right places)
<code>
sudo mysql_install_db --user=mysql
</code>

  * Add "yxue" to "mysql" group by editing /etc/group.

  * start mysql server. At this point, you should be able to run "mysql" from command line and get welcome information
<code>
sudo chmod +x /etc/rc.d/rc.mysqld
sudo /etc/rc.d/rc.mysqld start
</code>

  * setup a password for the Mysql root user
<code>
sudo su mysql
mysqladmin -u root password <new-password>
</code>

  * Note: the default database folder is "/var/lib/mysql/"
====== Mysql Commandline Quick Guide ======
===== Connect database =====
<code>
mysql -u root -p
mysql> use databackup;
mysql> help #get help information
mysql> show tables; #show tables in current database
</code>

===== Create tables =====

===== Run query =====
<code>
mysql> select * from datbak;
</code>

===== Insert a record =====
<code>
mysql>
</code>