"06-18" CentOS use notes

Using Chinese Input Method

1. Sogou IME only supports Ubuntu
2. sudo yum install "@Chinese support"
3. System---> Preferences---> Input Method--Start Input Method features--first input Method--and input Method--add "Chinese-pinyin"
4. Ctrl+space Switching Input Method

MySQL Installation

Yum Installation

Reference http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html

To start the MYSQLD service:sudo service mysqld start

Check Service Status:sudo service mysqld status

To connect to a server:mysql -uroot -p

Start Services: Service MySQL Start | | Restart

Check configuration: Chkconfig--list | grep mysqld

Set power on auto start: Chkconfig mysqld on

Set root user password: mysqladmin-u root password ' root '

Password reset in Safe mode: Copy from http://www.linuxidc.com/Linux/2014-03/98718.htm

Start MySQL:
#/etc/init.d/mysql start

After successful startup, view the MySQL process information and get the Mysqld_safe installation directory:
#ps-ef | Grep-i MySQL
Root 3466 1 0 01:45 pts/1 00:00:00/bin/sh/usr/bin/mysqld_safe--datadir=/var/lib/mysql--pid-file=/var/lib/mysql/bsc. Test.pid
MySQL 3569 3466 01:45 pts/1 00:00:00/usr/sbin/mysqld--basedir=/usr--datadir=/var/lib/mysql--plugin-dir=/usr/lib64 /mysql/plugin--user=mysql--log-error=/var/lib/mysql/bsc. Test.err--PID-FILE=/VAR/LIB/MYSQL/BSC. Test.pid
Root 3597 3105 0 01:45 pts/1 00:00:00 grep-i MySQL

To start MySQL in a safe manner:
#/usr/bin/mysqld_safe--skip-grant-tables >/dev/null 2>&1 &

Start MySQL:
#/usr/bin/mysql-u Root MySQL

Update Password:
Update Mysql.user set Authentication_string=password (' root ') where user= ' root ' and Host = ' localhost ';

Login: Mysql-u root-p

MySQL config file path by:/ect/my.cnf

[Mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links are recommended to prevent assorted security riskssymbolic-links=0[ Mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

"06-18" CentOS use notes