위키
포럼
도구
바뀐글
랜덤

"우분투 pdo mysql 설치"의 두 판 사이의 차이

잔글 (봇: 자동으로 텍스트 교체 (-</source> +</syntaxhighlight>, -<source +<syntaxhighlight ))
 
(사용자 2명의 중간 판 6개는 보이지 않습니다)
1번째 줄: 1번째 줄:
{{다른뜻|CentOS pdo_mysql 설치}}
;우분투 pdo_mysql 설치
;우분투 pdo_mysql 설치


==확인==
==확인==
<source lang='console'>
<syntaxhighlight lang='console'>
root@zetawiki:~# php -v | head -1
root@zetawiki:~# php -v | head -1
PHP 5.5.9-1ubuntu4.14 (cli) (built: Oct 28 2015 01:34:46)  
PHP 7.0.15-0ubuntu0.16.04.4 (cli) ( NTS )
root@zetawiki:~# php -m | grep -i pdo
root@zetawiki:~# php -m | grep -i pdo
PDO
PDO
</source>
root@zetawiki:~# php -r 'echo PDO::MYSQL_ATTR_INIT_COMMAND;' 2>&1 | head -1
:→ PDO는 설치되어 있지만, 드라이버가 하나도 없다.
PHP Fatal error:  Uncaught Error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in Command line code:1
</syntaxhighlight>
:→ PDO는 설치되어 있지만, 드라이버가 하나도 없음


==설치==
==설치==
<source lang='console'>
<syntaxhighlight lang='bash'>
root@zetawiki:~# apt-get install php5-mysql
# ubuntu14, php5
apt-get install php5-mysql
</syntaxhighlight>
<syntaxhighlight lang='bash'>
# ubuntu16, php7
apt-get install php-mysql
</syntaxhighlight>
<syntaxhighlight lang='console'>
root@zetawiki:~# apt-get install php-mysql
Reading package lists... Done
Reading package lists... Done
Building dependency tree       
Building dependency tree       
Reading state information... Done
Reading state information... Done
The following additional packages will be installed:
  php7.0-mysql
The following NEW packages will be installed:
The following NEW packages will be installed:
   php5-mysql
   php-mysql php7.0-mysql
0 upgraded, 1 newly installed, 0 to remove and 40 not upgraded.
0 upgraded, 2 newly installed, 0 to remove and 37 not upgraded.
Need to get 62.9 kB of archives.
Need to get 125 kB of archives.
After this operation, 297 kB of additional disk space will be used.
After this operation, 484 kB of additional disk space will be used.
Get:1 http://mirror2.g.ucloudbiz.com/ubuntu/ trusty-updates/main php5-mysql amd64 5.5.9+dfsg-1ubuntu4.14 [62.9 kB]
Do you want to continue? [Y/n]
Fetched 62.9 kB in 0s (1,922 kB/s)  
</syntaxhighlight>
Selecting previously unselected package php5-mysql.
<syntaxhighlight lang='console'>
(Reading database ... 99232 files and directories currently installed.)
Get:1 http://kr.archive.ubuntu.com/ubuntu xenial-updates/main amd64 php7.0-mysql amd64 7.0.15-0ubuntu0.16.04.4 [123 kB]
Preparing to unpack .../php5-mysql_5.5.9+dfsg-1ubuntu4.14_amd64.deb ...
Get:2 http://kr.archive.ubuntu.com/ubuntu xenial/main amd64 php-mysql all 1:7.0+35ubuntu6 [1,936 B]
Unpacking php5-mysql (5.5.9+dfsg-1ubuntu4.14) ...
Fetched 125 kB in 0s (538 kB/s)    
Processing triggers for libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.14) ...
Selecting previously unselected package php7.0-mysql.
Setting up php5-mysql (5.5.9+dfsg-1ubuntu4.14) ...
(Reading database ... 72025 files and directories currently installed.)
Preparing to unpack .../php7.0-mysql_7.0.15-0ubuntu0.16.04.4_amd64.deb ...
Unpacking php7.0-mysql (7.0.15-0ubuntu0.16.04.4) ...
Selecting previously unselected package php-mysql.
Preparing to unpack .../php-mysql_1%3a7.0+35ubuntu6_all.deb ...
Unpacking php-mysql (1:7.0+35ubuntu6) ...
Processing triggers for php7.0-fpm (7.0.15-0ubuntu0.16.04.4) ...
Setting up php7.0-mysql (7.0.15-0ubuntu0.16.04.4) ...


Creating config file /etc/php5/mods-available/mysql.ini with new version
Creating config file /etc/php/7.0/mods-available/mysqlnd.ini with new version
php5_invoke: Enable module mysql for apache2 SAPI
php5_invoke: Enable module mysql for cli SAPI


Creating config file /etc/php5/mods-available/mysqli.ini with new version
Creating config file /etc/php/7.0/mods-available/mysqli.ini with new version
php5_invoke: Enable module mysqli for apache2 SAPI
php5_invoke: Enable module mysqli for cli SAPI


Creating config file /etc/php5/mods-available/pdo_mysql.ini with new version
Creating config file /etc/php/7.0/mods-available/pdo_mysql.ini with new version
php5_invoke: Enable module pdo_mysql for apache2 SAPI
Setting up php-mysql (1:7.0+35ubuntu6) ...
php5_invoke: Enable module pdo_mysql for cli SAPI
Processing triggers for php7.0-fpm (7.0.15-0ubuntu0.16.04.4) ...
Processing triggers for libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.14) ...
</syntaxhighlight>
</source>


==확인 2==
==확인 2==
<source lang='console'>
<syntaxhighlight lang='console'>
root@zetawiki:~# php -m | grep -i pdo
root@zetawiki:~# php -m | grep -i pdo
PDO
PDO
pdo_mysql
pdo_mysql
</source>
</syntaxhighlight>
:→ PDO용 MySQL 드라이버가 설치되었다.
:→ PDO용 MySQL 드라이버가 설치되었다.


==같이 보기==
==같이 보기==
*[[CentOS pdo_mysql 설치]]
*[[PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver']]
*[[PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver']]
*[[PDO]]
*[[PDO]]


==참고 자료==
==참고==
* http://askubuntu.com/questions/384677/how-do-i-install-and-enable-pdo-mysql-and-gd-extensions-for-php5
* http://askubuntu.com/questions/384677/how-do-i-install-and-enable-pdo-mysql-and-gd-extensions-for-php5


2020년 11월 2일 (월) 02:56 기준 최신판

  다른 뜻에 대해서는 CentOS pdo_mysql 설치 문서를 참조하십시오.
우분투 pdo_mysql 설치

1 확인[ | ]

root@zetawiki:~# php -v | head -1
PHP 7.0.15-0ubuntu0.16.04.4 (cli) ( NTS )
root@zetawiki:~# php -m | grep -i pdo
PDO
root@zetawiki:~# php -r 'echo PDO::MYSQL_ATTR_INIT_COMMAND;' 2>&1 | head -1
PHP Fatal error:  Uncaught Error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in Command line code:1
→ PDO는 설치되어 있지만, 드라이버가 하나도 없음

2 설치[ | ]

# ubuntu14, php5
apt-get install php5-mysql

# ubuntu16, php7
apt-get install php-mysql

root@zetawiki:~# apt-get install php-mysql
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  php7.0-mysql
The following NEW packages will be installed:
  php-mysql php7.0-mysql
0 upgraded, 2 newly installed, 0 to remove and 37 not upgraded.
Need to get 125 kB of archives.
After this operation, 484 kB of additional disk space will be used.
Do you want to continue? [Y/n]

Get:1 http://kr.archive.ubuntu.com/ubuntu xenial-updates/main amd64 php7.0-mysql amd64 7.0.15-0ubuntu0.16.04.4 [123 kB]
Get:2 http://kr.archive.ubuntu.com/ubuntu xenial/main amd64 php-mysql all 1:7.0+35ubuntu6 [1,936 B]
Fetched 125 kB in 0s (538 kB/s)      
Selecting previously unselected package php7.0-mysql.
(Reading database ... 72025 files and directories currently installed.)
Preparing to unpack .../php7.0-mysql_7.0.15-0ubuntu0.16.04.4_amd64.deb ...
Unpacking php7.0-mysql (7.0.15-0ubuntu0.16.04.4) ...
Selecting previously unselected package php-mysql.
Preparing to unpack .../php-mysql_1%3a7.0+35ubuntu6_all.deb ...
Unpacking php-mysql (1:7.0+35ubuntu6) ...
Processing triggers for php7.0-fpm (7.0.15-0ubuntu0.16.04.4) ...
Setting up php7.0-mysql (7.0.15-0ubuntu0.16.04.4) ...

Creating config file /etc/php/7.0/mods-available/mysqlnd.ini with new version

Creating config file /etc/php/7.0/mods-available/mysqli.ini with new version

Creating config file /etc/php/7.0/mods-available/pdo_mysql.ini with new version
Setting up php-mysql (1:7.0+35ubuntu6) ...
Processing triggers for php7.0-fpm (7.0.15-0ubuntu0.16.04.4) ...

3 확인 2[ | ]

root@zetawiki:~# php -m | grep -i pdo
PDO
pdo_mysql
→ PDO용 MySQL 드라이버가 설치되었다.

4 같이 보기[ | ]

5 참고[ | ]

원본 주소 "https://zetawiki.com/w/index.php?title=우분투_pdo_mysql_설치&oldid=607718"
문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}