[B! MariaDB] shigiryouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shigiryou id:shigiryou

MariaDBã«é–¢ã™ã‚‹shigiryouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Ruby on Rails 5.0 ã§MariaDBã‚’æ‰±ã† - Qiita
å‰å›žã®ç¶šãã§ã™ã€‚ rubyãŠå‹‰å¼·ã‚’ç¶šã‘ã¾ã™ã€‚ 1. MariaDBã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« 1.1 æœ¬ä½“ ã“ã¡ã‚‰ã‚’å‚è€ƒã«MariaDBã‚’å…¥ã‚Œã¾ã™ã€‚ä½•ã‚‚èª¬æ˜Žã™ã‚‹äº‹ã¯ãªã„ãã‚‰ã„ç°¡å˜ã§ã™ã€‚ [root@localhost share]# yum -y install mariadb-server mariadb .......... å®Œäº†ã—ã¾ã—ãŸ! [root@localhost share]# yum -y install mariadb-devel.x86_64 .......... å®Œäº†ã—ã¾ã—ãŸ! [root@localhost share]# systemctl start mariadb [root@localhost share]# systemctl enable mariadb .......... 8æœˆ 03 17:42:15 localhost.localdomain systemd[
shigiryou 2019/05/01
MariaDB

RubyOnRails
ãƒªãƒ³ã‚¯
MariaDB vs. MongoDB Comparison
shigiryou 2018/08/25
MongoDB

MariaDB

MySQL
ãƒªãƒ³ã‚¯
ã€MariaDBã€‘ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰å¤–éƒ¨ã‹ã‚‰æŽ¥ç¶šã¾ã§ã®è¨å®š - å‹•ã‹ã–ã‚‹ã“ã¨ãƒã‚°ã®å¦‚ã—
ç’°å¢ƒ Ubuntu Server 14.04 MariaDB 10.1.14 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« å…¬å¼ã‚µã‚¤ãƒˆè¦‹ã‚Œã°ã‚¯ãƒƒã‚½ä¸å¯§ã«æ›¸ã„ã¦ã‚ã‚‹ã‹ã‚‰ãã‚Œè¦‹ã‚ˆã†ãªï¼ˆæŠ• Downloads - MariaDB åˆæœŸè¨å®š ã¾ãšã¯ãƒ€ãƒ«ã„æ–‡å—ã‚³ãƒ¼ãƒ‰å•é¡Œã‚’è§£æ±ºã™ã¹ãã€ã™ã¹ã¦ã®DBã‚’UTF-8ã«ã—ã¦ã€å¤–éƒ¨ã‹ã‚‰ã®æŽ¥ç¶šã‚’è¨±å¯ã™ã‚‹ /etc/mysql/my.cnf ã®ä»¥ä¸‹ã‚’ä¿®æ£ [client] ï¼ˆè¿½è¨˜ï¼‰ default-character-set=utf8 [mysqld] ï¼ˆè¿½è¨˜ï¼‰ skip-character-set-client-handshake character-set-server = utf8 collation-server = utf8_general_ci init-connect = SET NAMES utf8 (ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆ) # bind-address = 127.0.0.1 è¨å®šåæ˜
shigiryou 2016/10/30
è†ƒè‚è‡

MariaDB

MySQL
ãƒªãƒ³ã‚¯
ç¬¬20å›žã€€mycliã‚’ä½¿ã£ã¦å¿«é©ã«SQLã‚’å®Ÿè¡Œã™ã‚‹ | gihyo.jp
æ–°ã—ã„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ©Ÿèƒ½ã‚’å®Ÿè£…ã™ã‚‹éš›ã«ã€ãƒãƒ¼ã‚«ãƒ«ã‚„é–‹ç™ºè€…å‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å®Ÿè£…ã™ã‚‹å‰ã«ä½•åº¦ã‹SQLã‚’ãŸã‚ã—ã«å®Ÿè¡Œã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ãã®éš›ã«ã€è£œå®Œæ©Ÿèƒ½ã‚„ä»¥å‰å®Ÿè¡Œã—ãŸSQLã®æ¤œç´¢æ©Ÿèƒ½ç‰ãŒã‚ã‚‹å ´åˆã¨ãªã„å ´åˆã§ã¯ã€ä½œæ¥ã®åŠ¹çŽ‡ãŒå¤‰ã‚ã£ã¦ãã¾ã™ã€‚ ãã“ã§ã€ä»Šå›žã¯è£œå®Œã‚„æ¤œç´¢æ©Ÿèƒ½ãªã©ã€å¤šãã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚’ã‚‚ã¤mycliã¨ã„ã†ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«ã¤ã„ã¦ç´¹ä»‹ã‚’ã—ã¦ã„ãã¾ã™ã€‚ ãƒ‡ãƒ¢ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒ ä»Šå›žã¯5.7.12ã‚’ç¬¬5å›žã€€Dockerã§è¤‡æ•°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®MySQLã‚’é–‹ç™ºç’°å¢ƒã«ç”¨æ„ã™ã‚‹ã§ä½œæˆã—ãŸç’°å¢ƒã§å®Ÿè¡Œã—ã¦ç¢ºèªã—ã¦ã„ãã¾ã™ã€‚ã¾ãŸã€ä»Šå›žä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã€Œç¬¬2å›žã€€MySQLã«ã¯ã˜ã‚ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã¦ã¿ã‚‹ã€ã§ç´¹ä»‹ã‚’ã—ã¦ã„ã‚‹éƒµä¾¿ç•ªå·ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç”¨ã„ã¦ç´¹ä»‹ã‚’è¡Œã„ã¾ã™ã€‚ mycliã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã“ã§ã¯MySQLã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®1ã¤ã§ã‚ã‚‹mycliã‚’ç´¹ä»‹ã—ã¾ã™ã€‚mycliã¯è‡ªå‹•è£œå®Œ
shigiryou 2016/06/26
mycli

MySQL

MariaDB
ãƒªãƒ³ã‚¯
é€£è¼‰è¨˜äº‹ ã€Œå¿«é€ŸMySQLã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªï¼ã€
MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å®Œå…¨ã‚¬ã‚¤ãƒ‰ é€£è¼‰ï¼šå¿«é€ŸMySQLã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªï¼ï¼ˆ1ï¼‰ã€€è»½å¿«ãªå‹•ä½œã§çŸ¥ã‚‰ã‚Œã‚‹MySQLã§DBã‚¢ãƒ—ãƒªã®æ§‹ç¯‰ã‚’è¡Œã†ã€‚ä»Šå›žã¯ã€MySQLã®æ¦‚è¦ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†
shigiryou 2016/06/20
MySQL

MariaDB
ãƒªãƒ³ã‚¯
mycli
mycli BlackLivesMatter We value the diversity of our community. We strive to amplify the voices of the oppressed to eradicate racism and xenophobia. We ask our community to stand together in support of the Black community. MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. Source: https://github.com/dbcli/mycli Bug tracker: https://githu
shigiryou 2016/06/19
mycli

MySQL

MariaDB

completion

excellent

è£œå®Œ
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰(MariaDB) - CentOSã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
[root@centos ~]# vi /etc/my.cnf.d/server.cnfã€€â†ã€€MariaDBè¨å®šãƒ•ã‚¡ã‚¤ãƒ«ç·¨é›† [mysqld] character-set-server = utf8ã€€â†ã€€è¿½åŠ (MariaDBã‚µãƒ¼ãƒãƒ¼ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã«ã™ã‚‹) [root@centos ~]# mysql_secure_installationã€€â†ã€€MariaDBåˆæœŸè¨å®š /usr/bin/mysql_secure_installation: è¡Œ 379: find_mysql_client: ã‚³ãƒžãƒ³ãƒ‰ãŒè¦‹ã¤ã‹ ã‚Šã¾ã›ã‚“ NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In o
shigiryou 2016/05/29
MariaDB

MySQL
ãƒªãƒ³ã‚¯
Memo: MariaDBã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«/åˆæœŸè¨å®š - Qiita
$ sudo systemctl start mariadb.service $ sudo /usr/bin/mysql_secure_installation /usr/bin/mysql_secure_installation: è¡Œ 379: find_mysql_client: ã‚³ãƒžãƒ³ãƒ‰ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just insta
shigiryou 2016/05/29
MariaDB

MySQL
ãƒªãƒ³ã‚¯
How to Install LAMP (Linux, Apache, MariaDB and PHP) on Fedora 23 Server and Workstation
How to Install LAMP (Linux, Apache, MariaDB and PHP) on Fedora 23 Server and Workstation If you ever wanted to host your own website or just want to try your PHP programming skills, you will most definitely have stumbled upon LAMP. For those of you, who donâ€™t know what LAMP is, this is a stack of web service software. LAMP uses the first letter of each package included in it â€“ Linux, Apache, Mysql
shigiryou 2016/05/22
Fedora

23

LAMP

MySQL

MariaDB

PHP

RapidSetup

Apache

GettingStarted
ãƒªãƒ³ã‚¯
AWSå†å…¥é–€ Amazon RDSç·¨ | DevelopersIO
ä¸Šè¨˜ã®ä¸ã®RDBMSå…¨ã¦ã«åŠ ãˆã¦ã€ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã«åˆã‚ã›ã¦å†è¨è¨ˆã—ãŸAuroraã€MySQLã®ãƒ•ã‚©ãƒ¼ã‚¯ã§ã‚ã‚‹MariaDBãŒä½¿ç”¨ã§ãã¾ã™ã€‚ MySQLï¼šæœ€ã‚‚ã‚·ã‚§ã‚¢ãŒã‚ã‚‹OSSã®RDBMSã€‚ Oracleï¼šé«˜ã„ã‚·ã‚§ã‚¢ãŒã‚ã‚‹å•†ç”¨RDBMSã€‚ SQL Serverï¼šé«˜ã„ã‚·ã‚§ã‚¢ãŒã‚ã‚‹å•†ç”¨RDBMSã€‚Windowsã¨ã®è¦ªå’Œæ€§ãŒé«˜ã„ã€‚ PostgreSQLï¼šæ©Ÿèƒ½ãŒè±Šå¯ŒãªOSSã®RDBMSã€‚ Auroraï¼šAWSãŒã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã«å†è¨è¨ˆã—ãŸRDBMSã€‚MySQL 5.6äº’æ›ã§MySQLã®5å€é«˜é€Ÿã¨è¨€ã‚ã‚Œã¦ã„ã¾ã™ã€‚ MariaDBï¼šMySQLã‹ã‚‰ãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸRDBMSã€‚MySQLäº’æ›ã€‚ æ€§èƒ½å‘ä¸ŠãŒç°¡å˜ã«å®Ÿæ–½å¯èƒ½ Amazon RDSã§ã¯ã€æ§˜ã€…ãªã‚¹ãƒšãƒƒã‚¯ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½¿ç”¨ã§ãã¾ã™ã€‚æœ€å¤§40å€‹ã®vCPUã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚„244GBã®ãƒ¡ãƒ¢ãƒªã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚æ€§èƒ½ãŒä¸è¶³ã—ã¦ããŸã‚‰ã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ã‚µã‚¤ã‚ºã‚’å¤‰æ›´ã™
shigiryou 2016/05/21
AWS

RDS

Aurora

MySQL

MariaDB
ãƒªãƒ³ã‚¯
MySQL å¤–éƒ¨ãƒ›ã‚¹ãƒˆã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹
MySQL å¤–éƒ¨ãƒ›ã‚¹ãƒˆã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ 2010.06.09 MySQL root ã§ãƒã‚°ã‚¤ãƒ³å¾Œã€ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ã‚’èª¿ã¹ã¦ã€å¤–éƒ¨IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’è¿½åŠ ç™»éŒ²ã™ã‚‹ã€‚ â– ãƒ¦ãƒ¼ã‚¶ã‚’èª¿ã¹ã‚‹ mysql> use mysql; mysql> select user, host from user; +---------+----------------------+ | userÂ Â Â | hostÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â | +---------+----------------------+ | rootÂ Â Â | aaa-web.mydomain.com | | rootÂ Â Â | localhostÂ Â Â Â Â Â Â Â Â Â Â | | kataoka | localhostÂ Â Â Â Â Â Â Â Â Â Â | +---------+----------------------+ 5 rows in s
shigiryou 2015/11/12
[ã‚¢ã‚¯ã‚»[æ‡‡åˆ‡ä¸å¯§][æ¸‹è°·ç”Ÿæ´»][excellent]

MySQL

MariaDB

Network

CommndLine

tips

ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æŽ¥ç¶š
ãƒªãƒ³ã‚¯
How To Install LAMP Stack In Fedora 23/24 | Unixmen
LAMP is a combination of operating system and open-source software stack. The acronym LAMP comes from the first letters of Linux, Apache HTTP Server, MySQL/MariaDB database, and PHP, Perl or Python. In this tutorial, let us see how to install LAMP stack in Fedora 23 server. Although, the same procedure will work Fedora 22 and earlier versions. My testbox hostname and IP address are server.unixmen.
shigiryou 2015/11/08
Fedora

23

LAMP

apache

MariaDB

eazy

install
ãƒªãƒ³ã‚¯
CentOS6.6ã§MySQL5.6ã‹ã‚‰MariaDB10.1.4ã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ãŸè©± - Qiita
Help us understand the probl em. What are the probl em?
shigiryou 2015/10/13
MySQL

MariaDB
ãƒªãƒ³ã‚¯
Tutorials
We use cookies for advertising, social media and analytics purposes. Read about how we use cookies in our updated Privacy Policy. If you continue to use this site, you consent to our use of cookies and our Privacy Policy.
shigiryou 2015/10/13
Fedora

excellent

SSH

Apache

PHP

MariaDB

MySQL

GettingStarted

åˆæœŸè¨å®š
ãƒªãƒ³ã‚¯
CentOS7ã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« â€“ sawara.me
å‰å›žã®è¨˜äº‹ã§CentOSãŒMariaDBã«ãªã£ã¨ã£ãŸã£ã¦ã„ã†è©±ã‚’ç´¹ä»‹ã—ãŸã®ã§ã™ãŒã€ã˜ã‚ƒã‚ã€MySQLã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å‡ºæ¥ãªã„ã®ã£ã¦èžã‹ã‚ŒãŸã®ã§ã€ä¸€å¿œã“ã¡ã‚‰ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ äº‹å‰æº–å‚™ ä¸€å¿œäº‹å‰ã«MariaDBã®ä½•ã‹ã—ã‚‰ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚Œã°å‰Šé™¤ã—ã¾ã™ã€‚ ä»Šå›žã¯mariadb-libsãŒå…¥ã£ã¦ã„ã¾ã—ãŸã®ã§ã€ã“ã‚Œã‚’ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ [bash] # MariaDBã®ä½•ã‹ã—ã‚‰ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã„ã‹ç¢ºèª yum list installed | grep maria # å®Ÿè¡Œçµæžœ mariadb-libs.x86_64 1:5.5.35-3.el7 @anaconda # ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum -y remove mariadb-libs [/bash] RPMã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä¸€ç•ªã‚ˆãã‚„ã‚‹æ–¹æ³•ã§ã™ã€‚ã“ã®ãƒ–ãƒã‚°ã§ã‚‚ã‚ˆãã“ã®æ–¹æ³•ã§ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’ç´¹ä»‹ã—ã¦ãŠã‚Šã¾ã™
shigiryou 2015/10/04
CentOS

CentOS7

MySQL

MariaDB
ãƒªãƒ³ã‚¯
CentOS7ã®MySQL(MariaDB)ãŒèµ·å‹•ã§ããªã„ - Qiita
#æ¦‚è¦ CentOS7ãŒå‡ºãŸã®ã§å–œã‚“ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨MySQLã¯ç„¡ã„ã‚iptablesã¯firewalldã«ç½®ãæ›ã‚ã£ã¦ã‚‹ã‚ã§ãƒ†ãƒ³ãƒ¤ãƒ¯ãƒ³ãƒ¤ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ãã®ä¸ã§ã‚‚ã€CentOS7ã§MySQLã®ä»£ã‚ã‚Šã¨ã—ã¦æ–°ãŸã«å°Žå…¥ã•ã‚ŒãŸMariaDBã‚’èµ·å‹•ã™ã‚‹éš›ã«ã‚³ã‚±ãŸã®ã§ãã®ãƒ¡ãƒ¢ã‚’ãƒ»ãƒ»ãƒ» #åŽŸå› MySQLã®ã‚·ã‚¹ãƒ†ãƒ ãƒ•ã‚©ãƒ«ãƒ€/var/lib/mysqlã®æ‰€æœ‰è€…ãŒrootã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ ãã“ã§chown -R mysql:mysql /var/lib/mysqlã‚’å®Ÿè¡Œã—ã¦æ‰€æœ‰è€…ã‚’ç›´ã—ã¾ã—ãŸã€‚ ã¾ã•ã‹ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«rootã«ãªã‚‹ã¨ã¯æ€ã£ã¦ãªã„ã‹ã‚‰ã€ç‰¹å®šã™ã‚‹ã¾ã§ã«ã™ã”ã„æ™‚é–“ãŒã‹ã‹ã£ãŸorz #å€‹äººçš„ãƒ¡ãƒ¢ ##ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚©ãƒ«ãƒ€ã‚’å¤‰æ›´ã—ãŸå ´åˆ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚©ãƒ«ãƒ€ã‚’å¤‰æ›´ã—ãŸéš›ã¯ã€æ‰€æœ‰è€…ã€ãƒ©ãƒ™ãƒ«ã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ã€‚ ã¾ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚å®Ÿè¡Œ #ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚©ãƒ«ãƒ€ã®ãƒ©ãƒ™ãƒ«å¤‰æ›´ root# semanage fco
shigiryou 2015/09/26
CentOS

7

MySQL

MariaDB
ãƒªãƒ³ã‚¯
CentOS 7ã«MySQLæœ€æ–°ç‰ˆã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ä½¿ç”¨ã—ãŸOS [root@localhost ~]# cat /etc/redhat-release CentOS Linux release 7.1.1503 (Core) æœ€æ–°ã®MySQLã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ä»Šå›žã¯è¨˜äº‹ä½œæˆæ™‚ç‚¹ã§æœ€æ–°ã®5.6.24ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.24-1.el7.x86_64.rpm ä»–ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã„ãŸã„ãªã©ã®å ´åˆã¯å…¬å¼ã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãã ã•ã„ã€‚ http://dev.mysql.com/downloads/mysql/ MariaDBã‚’ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS 7ã‹ã‚‰ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒMySQLã‹ã‚‰MariaDBã«å¤‰æ›´ã•ã‚Œã¦ã„ã¾ã™ã€‚ MariaDBã¯MySQLã¨äº’æ›æ€§ã®ã‚ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½
shigiryou 2015/09/26
CentOS

7

MariaDB

MySQL
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
shigiryou 2015/09/21
MariaDB

MySQL
ãƒªãƒ³ã‚¯
CentOS7
ãƒ›ãƒ¼ãƒ CentOS7 VulsRepoã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 Vulsã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 OpenVAS(GVM)ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 Webminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 Userminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 Cockpitã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 Nginxã§ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆå‡¦ç† CentOS7 Nginxã§CGI(Perl) CentOS7 Nginxã§PHP CentOS7 Nginxã§SSLè¨¼æ˜Žæ›¸ã®è¨å®š(SNIå«ã‚€) CentOS7 Nginxã§ãƒãƒ¼ãƒãƒ£ãƒ«ãƒ›ã‚¹ãƒˆ CentOS7 Nginxã®ã‚¢ã‚¯ã‚»ã‚¹åˆ¶é™ CentOS7 Nginxã®åŸºæœ¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡ãƒã‚§ãƒƒã‚¯ CentOS7 WordPressã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 RainLoopã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« CentOS7 PHPListã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Ce
shigiryou 2015/03/28
CentOS

CentOS7

setting
ãƒªãƒ³ã‚¯
1