Mysql

Frequently used commands
ps -ef | grep mysqld $ mysql -u root -p mysql> use mysql; mysql> insert into user (host,user,password,insert_priv,select_priv,update_priv) values ('localhost','guset',PASSWORD('password'),'Y','Y','Y'); mysql> flush privileges;
 * check process
 * the daemon process name is mysqld
 * startup or shutdown
 * 1) mysqldadmin -u root -p shutdown
 * 2) mysqldadmin -u root -p startup
 * 3) mysqldadmin status
 * create user. for more details Mysql Administration.

Configuration

 * the install directory is /user/local/mysql ←in my case.
 * configuration file is my.cnf (my.ini on Windows platform)
 * there is a default order to read configuration files on computer, for example the first to read is /etc/my.cnf, the second is /usr/local/etc/my.cnf etc.

Tips

 * The default port is 3306
 * Programmers use connectors(such as C connector, Java Connector etc.) to access mysql databases. Most can be downloaded from the official site.