나의 일상이다반사

php mysql 모듈 설치

> yum install php php-mysql

> adduser user_id

> passwd user_pw

sshd root 접속 권한 삭제

> vi /etc/ssh/sshd_config

PermitRootLogin no

> /etc/rc.d/init.d/sshd restart

html 디렉토리 user_id 로 권한설정

/var/www/html

------------- mysql 설정

/etc/my.cnf 파일 설정

-----------------------------------------------------------

alter database db명 default character set utf8

------------------------------------------------------------

/etc/init.d/mysqld start

> mysql

mysql> use mysql

mysql> update user set password=password('root_pw') where user = 'root';

mysql> commit;

msyql> flush privileges;

mysql> create database db_name;

mysql> insert into user (host, user, password) values (

    -> 'localhost','user_id', password('user_pw'));

mysql> insert into db values ( '%', 'service', 'service', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',

         'Y','Y','Y','Y');

mysql> commit;

mysql> exit;

> /etc/init.d/mysqld restart

> mysql -uuser_id -puser_pw db

create table test ( a varchar(10));

insert into test values ('afdafdfds');

------------ php 설정

>vi /etc/php.ini

short_open_tab = On

>vi /etc/httpd/conf.d/php.conf

AddHandler php5-script .html .php

AddType text/html .html .php

>/etc/init.d/httpd restart

-- php mysql 테스트 index.html

<?

$connect = mysql_connect('localhost','user_id','user_pw') or die ("SQL서버에 접속을 할수 없습니다");

$result = mysql_select_db('db_name',$connect);

mysql_query("set names utf8");

$query = "SELECT * FROM test";

$result = mysql_query($query);

$nev = mysql_fetch_array($result);

echo $nev[a];

?>

서버네임 설정

>vi /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=domain

>vi /etc/httpd/conf/httpd.conf

ServerName domain

// 시간설정

rdate -s time.bora.net

// mysql c library

yum install mysql-devel