php和mysql相关配置
1.php.ini的配置文件详解
ls /usr/local/php/etc/php.ini
/usr/local/php/bin/php -i|head
disable_functions =eval,assert,popen,passthru,escapeshellarg,escapeshellcmd,passthru,exec,system,chroot,scandir,chgrp,chown,escapeshellcmd,escapeshellarg,shell_exec,proc_get_status,ini_alter,ini_restore,dl,pfsockopen,openlog,syslog,readlink,symlink,leak,popepassthru,stream_socket_server,popen,proc_open,proc_close
display_errors = Off(错误日志)
log_errors = On
error_log =/usr/local/php/logs/php_errors.log
mkdir /usr/local/php/logs/
chmod 777 /usr/local/php/logs/
error_reporting = E_ALL & ~E_NOTICE(452行)
vim /data/www/forum.php
ls /usr/local/php/logs
cat /usr/local/php/logs/php_errors.log
一个:open_basedir = /data/www:/tmp(限制到某个目录)
多个:vim /usr/local/apache/conf/extra/httpd-vhosts.conf
ServerName www.test.com
ServerAlias www.aaa.com
php_admin_value open_basedir "/data/www:/tmp"
2.php扩展模块如何安装
(查看模块) /usr/local/php/bin/php -m
cd /usr/local/src/php-5.4.36/ext
/usr/local/php/bin/php -m |grep -i curl(有没有curl这个模块)
/usr/local/php/bin/phpize(这是命令)
./configure --with-php-config=/usr/local/php/bin/php-config
make
make install
(扩展模块存放的目录)/usr/local/php/lib/php/extensions/no-debug-non-zts-20100525/
vim /usr/local/php/etc/php.ini
extension=curl.so(885行)
/usr/local/php/bin/php -m (看curl是否加载进来)
或者grep '^extension=' /usr/local/php/etc/php.ini
3.mysql配置讲解(mysql调优:http://www.apelearn.com/bbs/thread-5758-1-1.html)
vim /etc/my.cnf
interactive_timeout = 8
wait_timeout = 8
long_query_time = 1
log_slow_queries = /data/mysql/slow.log
4.mysql的root密码重置
设置密码:mysqladmin -uroot password 'xxr525970.'
登录:mysql -uroot -pxxr525970.
重置密码:
vim /etc/my.cnf
加入skip_grant
/etc/init.d/mysqld restart
mysql->use mysql->update user set password=password('xxr525970.') where user='root';
去掉skip_grant
/etc/init.d/mysqld restart
5.远程登录mysql
mysql -uroot -h192.168.255.3 -P3306 -pxxr525970.
远程登录授权:
mysql -uroot -h127.0.0.1 -P3306 -pxxr525970.
grant all on *.* to 'root'@'192.168.255.15' identified by '123456';
本地登录多个mysql:
mysql -uroot -S /tmp/mysql.sock -pxxr525970.
6.mysql常用操作
(有哪些库) show databases;
切换库:use 库名
查看使用的库:select database();
看表:show tables;
表里包含的字段:desc 表名
表的创建语句:show create table 表名\G;
创建库:use 库名
create database xxr;
创建表:
create table tb1(`id` int(4),`name` char(40)) ENGINE=MYISAM DEFAULT CHARSET=gbk;
插入数据:
insert into tb1 values(1,'xie');
insert into tb1 (`id`) values(3);
insert into tb1 (`name`) values('haha');
更新数据:
update tb1 set id=2 where name= 'xie';
删除一行:
delete from tb1 where name='xie'
清空一个表:
truncate table xxr.tb1;
删除一个表:
drop table tb1;
删除一个库;
drop database xxr;
修复一个表:
repair table 表名;
刷新权限:flush privileges;
数据库队列:show processlist;
查看状态:show status like '';
查看mysql参数:show varizbles like '';
临时修改参数:set global 参数名;
7.mysql备份及恢复
mysqldump -uroot -p --default-character-set=gbk 库名 >位置;
mysql -uroot -p --default-character-set=gbk 库名
页:
[1]