「Plesk」の版間の差分
提供: 初心者エンジニアの簡易メモ
(→apache,nginx周り) |
(→apache,nginx周り) |
||
行21: | 行21: | ||
service httpd restart | service httpd restart | ||
service plesk-php56-fpm restart | service plesk-php56-fpm restart | ||
+ | ==mysqlコンソールでの文字化け修正== | ||
+ | 現状こうなってるので | ||
+ | mysql> show variables like '%char%'; | ||
+ | +--------------------------+----------------------------+ | ||
+ | | Variable_name | Value | | ||
+ | +--------------------------+----------------------------+ | ||
+ | | character_set_client | latin1 | | ||
+ | | character_set_connection | latin1 | | ||
+ | | character_set_database | latin1 | | ||
+ | | character_set_filesystem | binary | | ||
+ | | character_set_results | latin1 | | ||
+ | | character_set_server | latin1 | | ||
+ | | character_set_system | utf8 | | ||
+ | | character_sets_dir | /usr/share/mysql/charsets/ | | ||
+ | |||
+ | -/etc/my.cnf | ||
+ | [mysqld] | ||
+ | character-set-server=utf8 | ||
+ | [client] | ||
+ | default-character-set = utf8 | ||
+ | |||
+ | $ sudo service mysqld start | ||
+ | |||
+ | mysql> show variables like '%char%'; | ||
+ | +--------------------------+----------------------------+ | ||
+ | | Variable_name | Value | | ||
+ | +--------------------------+----------------------------+ | ||
+ | | character_set_client | utf8 | | ||
+ | | character_set_connection | utf8 | | ||
+ | | character_set_database | utf8 | | ||
+ | | character_set_filesystem | binary | | ||
+ | | character_set_results | utf8 | | ||
+ | | character_set_server | utf8 | | ||
+ | | character_set_system | utf8 | | ||
+ | | character_sets_dir | /usr/share/mysql/charsets/ | |
2017年11月24日 (金) 12:44時点における版
webサーバ
ドキュメントルート
/var/www/vhosts/xxx.ex-cloud.biz/httpdocs
phpバージョンについて
nginxからみたphpのバージョンは変わるが、コンソールから見たバージョンは変わらない。
コンソールのphpバージョン変更方法
sudo mv /usr/bin/php /usr/bin/php_bk sudo ln -s /opt/plesk/php/7.1/bin/php /usr/bin/php
動作中のサービス一覧
plesk/ツールと設定/サービス管理
apache,nginx周り
/etc/nginx/plesk.conf.d/ip_default/hoge.conf /etc/httpd/conf/plesk.conf.d/ip_default/hoge.conf /var/www/vhosts/system/hoge/logs/proxy_hoge_error_log /var/www/vhosts/system/hoge/logs/hoge_error_log service nginx restart service httpd restart service plesk-php56-fpm restart
mysqlコンソールでの文字化け修正
現状こうなってるので
mysql> show variables like '%char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |
-/etc/my.cnf
[mysqld] character-set-server=utf8 [client] default-character-set = utf8
$ sudo service mysqld start
mysql> show variables like '%char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |