O I P O P – 私人领域

Liunx下修改MySQL字符集：

1.查找MySQL的cnf文件的位置

find / -iname ‘*.cnf’ -print

/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/texmf/web2c/texmf.cnf
/usr/share/texmf/web2c/mktex.cnf
/usr/share/texmf/web2c/fmtutil.cnf
/usr/share/texmf/tex/xmltex/xmltexfmtutil.cnf
/usr/share/texmf/tex/jadetex/jadefmtutil.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-large.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-small.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-huge.cnf

阅读全文…

sudo /etc/init.d/xxx [start/stop/restart]
临时启动,停止,重新启动某项计算机服务,如果是普通用户,前面的sudo不要忘记.

sudo vim [FileName]
使用vim编辑一个文件,如果没有权限,需要使用sudo.

mysql -uroot -p
linux下使用mysql命令行root用户登录