系统运维技巧（五）MySQL的其他安装方式

 
[root@serv02 local]# vim file 
[root@serv02 local]# head -n2 file 
/etc/my.cnf
/etc/init.d/mysqld

[root@serv02 local]# tar -cPvf mysql.tar -T file
[root@serv02 local]# cd ~
--上述三步可以一步到位

#打包不压缩
[root@serv02 htdocs]# find /usr/local/mysql//etc/my.cnf /etc/init.d/mysqld | xargs tar -cPvf mysql.tar
#打包压缩
[root@serv02 htdocs]# find /usr/local/mysql//etc/my.cnf /etc/init.d/mysqld | xargs tar -cjPvf mysql.tar.bz2

[root@serv03 ~]# yum install /usr/bin/scp -y
[root@serv02 local]# scp mysql.tar192.168.1.13:/root
root@192.168.1.13's password: 
mysql.tar 100% 1103MB 39.4MB/s 00:28 

[root@serv03 ~]# tar -xPvf mysql.tar

[root@serv01 opt]# groupadd -g 500 mysql
[root@serv01 opt]# useradd -u 500 -g 500 -r -M -s /sbin/nologin mysql 
#如果没有mysql用户，会报如下错误
Starting MySQL. ERROR! Manager of pid-filequit without updating file.

[root@serv03 ~]# vim ~/.bash_profile
[root@serv03 ~]# cat ~/.bash_profile | grep PATH
PATH=/usr/local/mysql/bin/:$PATH:$HOME/bin
export PATH
[root@serv03 ~]# . ~/.bash_profile 

[root@serv03 ~]# /etc/init.d/mysqld start

[root@serv03 ~]# mysql -uroot -phelloworld
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.58-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| discuz |
| larry |
| mysql |
| phpbb |
| phpbbtest |
| test |
| ultrax |
| wordpress |
+--------------------+
9 rows in set (0.00 sec)

mysql> 

我的邮箱：wgbno27@163.com 新浪微博：@Wentasy27
 微信公众平台：JustOracle（：justoracle）
 数据库技术交流群：336882565（加群时验证 From CSDN XXX）
 By Larry Wen