【06-18】CentOS使用筆記

標籤：

使用中文IME

1. 搜狗IME只支援Ubuntu
2. sudo yum install "@Chinese Support"
3. 【系統】--->【喜好設定】--->【IME】-->【啟動IME特性】-->【首先IME】-->【IME】-->添加【漢語-Pinyin】
4. Ctrl+Space切換IME

mysql安裝

yum安裝

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

啟動mysqld服務：sudo service mysqld start

檢查服務狀態：sudo service mysqld status

串連伺服器：mysql -uroot -p

 

 

啟動服務：service mysql start | | restart

 檢查配置：chkconfig --list | grep mysqld

設定開機自動啟動：chkconfig mysqld on

設定root使用者密碼：mysqladmin -u root password ‘root‘

 

安全模式下重設密碼：copy自 http://www.linuxidc.com/Linux/2014-03/98718.htm

啟動mysql：
#/etc/init.d/mysql start

啟動成功後查看mysql進程資訊，擷取mysqld_safe的安裝目錄：
#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 16 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

以安全方式啟動mysql:
#/usr/bin/mysqld_safe --skip-grant-tables >/dev/null 2>&1 &

啟動mysql：
#/usr/bin/mysql -u root mysql

更新密碼：
update mysql.user set authentication_string=password(‘root‘) where user=‘root‘ and Host =‘localhost‘;

 

登入：mysql -u root -p

mysql設定檔路經：/ect/my.cnf

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is 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使用筆記