6月5号
上午:
1、
*新建编写shell脚本:vim mem.sh
*修改文件的执行权限:chmod +x mem.sh
*执行文件:./mem.sh
*重启httpd:service httpd restart
*CGI:通用网络接口,安全低性能差
*用php做web开发
*vim hello.php
*mount /dev/cdrom /iso
*yum install php
*php hello.php
*mysql-server的使用
*安装mysql:yum install mysql-server
*service mysqld restart
*初始化安全设置:mysql_secure_installstion
*mysql -u root -p:root连接要密码masql
*mysql root密码忘记了怎么改:
*vim /etc/my.cnf
[mysqld]
skip-grant-tables
*service mysql restart
*mysql -uroot
mysql>update mysql.user set password=password("123456") where user="root";
*改完之后就重新进入/etc/my.cnf把刚刚添加那一行注释掉
*service mysqld restart
*mysql的用户与权限
*添加用户:
grant usage on *.* to hyp13@'%' indentified by '123456';*.*是代表可以访问所有数据库
grant all on test.* to hyp13@'%' indentified by '123456';test.*是只限制hyp13用户只能查看test数据库
*远程连接:mysql -h 10.10.10.128 -uusername -ppassword:以刚刚新创建的用户身份进入mysql
*mysql dump备份:mysql dump -uroot -p123456 bb> /tmp/bb.sql
*修改mysql文件的拥有者:chomd mysql.mysql /var/lib/mysql/ -R
*冷备份:cp /var/lib/mysql/ -rf
*恢复:cp data /var/lin/mysql/ -rf
下午:
2、
*部署UCenter:
*准备环境:
yum install php-mysql
yum install php-gd:解决验证码问题
service httpd restart
*从10.10.10.1的uplooking上下载两个包:
lftp 10.10.10.1
cd uplooking
get UCenter_1.6.0_SC_UTF8
get UCenter_Home_2.0_SC_UTF8
cd
exit:回到root的家目录
*解压文件
*为每一个应用程序单独创建一个库,一个用户,设置密码,授权
* mysql安装
yum install mysql-serverservice mysqld restart
mysql_secure_installation
mysql -uroot -p666666
* mysql root密码丢失:
vim /etc/my.cnf
[mysqld]
skip-grant-tables
# ...
servcie mysqld restart
mysql -uroot
mysql> update mysql.user set password=password("uplooking") where user="root";
mysql> exit
vim /etc/my.cnf
[mysqld]
# skip-grant-tables
# ...
servcie mysqld restart
* 基础的SQL操作
* mysql的用户及权限
* mysql简间备份恢复:
* 冷备, 物理备份, 全备:
* 备份:
service mysqld stop
cp -rf /var/lib/mysql ~/mysql.bak
* 恢复:
service mysqld stop
\cp -rf ~/mysql.bak/* /var/lib/mysql
chown mysql.mysql /var/lib/mysql -R
service mysqld start
* 热备, 逻辑备份:
* 备份:
mysqldump -uroot -puplooking classdb > /tmp/classdb.sql
mysqldump -uroot -puplooking classdb t09 > /tmp/t09.sql
mysqldump -uroot -puplooking --databases db01 db02 db03 > /tmp/db123.sql
mysqldump -uroot -puplooking --all-databases > /tmp/all.sql
* 恢复:
vim /tmp/classdb.sql
create database classdb;
use classdb;
cat /tmp/classdb.sql | mysql -uroot -puplooking
* 重置整个mysql(学习使用):
service mysqld stop
cp -rf /var/lib/mysql /var/lib/mysql.bak
rm /var/lib/mysql/* -rf
service mysqld restart
* UCenter 部署:
1. 准备环境:
yum install php-mysql php-gd
servcie httpd restart
2. 上传解压软件:
mkdir ~/ucenter
cd ~/ucenter/
unzip ~/UCenter_16.6.0_SC_UTF8.zip
ls
advanced readme upload utilities
cp upload/ /www/ucenter -rf:复制文件
chown apache.apache /www -R://将/www下的文件的拥有者更改为apache
3. 准备安装所需要的数据库信息:
mysql -uroot -puplooking
mysql> create database ucenter;
mysql> grant all on ucenter.* to uchome@'%' identified by 'ucpassword';
mysql> exit
4. 修改php.ini:
vim /etc/php.ini
short_open_tag=On
service httpd restart
4. 安装:
浏览器打开:
http://10.10.10.1/ucenter
* UCenter_Home 部署:
1. 上传解压软件:
mkdir ~/ucenter_home
cd ~/ucenter_home
unzip ~/UCenter_Home_2.0_SC_UTF8.zip
ls
2.0_changelog.txt readme.txt update upload
cp upload/* /www/ -rf
chown apache.apache /www -R
2. 准备安装所需要的数据库信息:
mysql -uroot -puplooking
mysql> create database uchome;
mysql> grant all on uchome.* to uchomeuser@'%' identified by 'uchomepassword';
mysql> exit
3. 打开 http://10.10.10.1/ucenter/, 之后 使用密码登录, 点击左边的"应用管理", 右边点击"添加新应用", 选择"URL安装", 应用程序安装地址中, 把"domainname"改为自己的IP地址, 点击"安装"
4. 根据提示完成UCenter_Home的安装
5. 解决"消息"bug:
rm /www/uc_client/ -rf
cp ~/ucenter/advanced/uc_client/ /www/ -rf
chown apache.apache /www -R