设置数据文件目录属性这一步相当重要,许多朋友第一次使用 tar 包安装 Mysql 的时候就因该目录权限问题导致 Mysql 无法启动。相当头大 .
# /usr/local/mysql/bin/mysql_install_db ( 初始化数据库 )
# service mysql start ( 启动 Mysql)
# /usr/local/mysql/bin/mysqladmin -u root -p password 'xxxxx' ( 设置管理员密码 xxx 默认值为空 )
好了,至此 mysql 安装完毕 .
以上是编译安装的
搭建 mysql 数据库:
创建 mysql 用户和用户组
# groupadd -g 200 mysql
# useradd -u 200 -g mysql -d /usr/local/mysql/data -M mysql
# id mysql
uid=200(mysql) gid=200(mysql) groups=200(mysql)
解压缩 mysql 数据库文件
# tar zxvf mysql-standard-4.1.7-pc-linux-i686.tar.gz -C /usr/local/
# cd /usr/local/
# ls
apache2 etc include libexec sbin src
bin games lib mysql-standard-4.1.7-pc-linux-i686 share
# ln -s mysql-standard-4.1.7-pc-linux-i686 mysql
# cd mysql
# ls
bin docs lib scripts tests
configure EXCEPTIONS-CLIENT man share
COPYING include mysql-test sql-bench
data INSTALL-BINARY README support-files
建立用到的库文件并更改权限
# mkdir /var/lib/mysql
# chown -R mysql:mysql /var/lib/mysql/
# chown -R mysql:mysql /usr/local/mysql-standard-4.1.7-pc-linux-i686/
创建 mysql 数据库的配置文件
# cd /usr/local/mysql
# cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
]# ls
bin docs lib scripts tests
configure EXCEPTIONS-CLIENT man share
COPYING include mysql-test sql-bench
data INSTALL-BINARY README support-files
# ./scripts/mysql_install_db
更改初始化数据库产生的家目录文件
# cd /usr/local/mysql/data/
# ll
-rw-rw---- 1 root root 8835 Jun 24 11:17 cisco-bin.000001
-rw-rw---- 1 root root 69239 Jun 24 11:17 cisco-bin.000002
-rw-rw---- 1 root root 38 Jun 24 11:17 cisco-bin.index
drwxr-x--- 2 mysql mysql 4096 Jun 24 11:17 mysql
drwxr-x--- 2 mysql mysql 4096 Oct 24 2004 test
[root@cisco data]# chown -R mysql:mysql /usr/local/mysql/data/
[root@cisco data]# ll
-rw-rw---- 1 mysql mysql 8835 Jun 24 11:17 cisco-bin.000001
-rw-rw---- 1 mysql mysql 69239 Jun 24 11:17 cisco-bin.000002
-rw-rw---- 1 mysql mysql 38 Jun 24 11:17 cisco-bin.index
drwxr-x--- 2 mysql mysql 4096 Jun 24 11:17 mysql
drwxr-x--- 2 mysql mysql 4096 Oct 24 2004 test
启动 mysql 数据库
# /usr/local/mysql/bin/safe_mysqld --user=mysql &
# Starting mysqld daemon with databases from /usr/local/mysql/data
给数据库管理员设定密码,并登陆数据库,创建一个新数据库
# /usr/local/mysql/bin/mysqladmin -u root password '123'
# /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.7-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
+----------+
2 rows in set (0.00 sec)
mysql> create database cacti;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| phpbb |
| test |
+----------+
3 rows in set (0.00 sec)
mysql> exit
这样构建 Cacit 运行的 PHP+Mysql 环境就基本上完成了。
下边开始安装 Cacit 所需要的 rrdtools 图形工具以及 snmp 工具
编译安装 rrdtool
# tar zxvf rrdtool-1.0.50.tar
# cd rrdtool-1.0.50
# ./configure --prefix=/usr/local/rrdtool
# make && make install
Rrdtool 1.0版本的自带GD库文件,安装简单方便,但是1.2版本的就没有自带,所以安装比较复杂
1.2版本的安装方法稍后介绍 安装net-snmp安装包(使用系统自带的就OK)
安装 net-snmp、snmpwalk 和 snmpget 命令
# rpm -qa | grep net-snmp ( 查看系统中有否已经装有所需的软件 )
net-snmp-5.0.9-2.30E.15
net-snmp-devel-5.0.9-2.30E.15
net-snmp-libs-5.0.9-2.30E.15
net-snmp-utils-5.0.9-2.30E.15
CACTID 的安装需要以下支持:
net-snmp-devel (需要编译安装net-snmp时添加--enable-developer选项)
mysql
mysql-devel (mysql源文件编译安装后默认支持)
openssl-devel (Redhat默认安装)
# tar -zxvf cacti-cactid-0.8.6i.tar.gz
# cd cacti-cactid-0.8.6i
# ./configure --with-mysql=/usr/local/mysql --with-snmp=/usr/local/net-snmp
# make
//这时你将在此目录下看到多出了cactid、cactid.conf两个文件
# mkdir /usr/local/cactid
# cp cactid cactid.conf /usr/local/cactid
# vi /usr/local/cactid/cactid.conf //修改cactid配置文件
DB_Host 127.0.0.1
DB_Database cacti
DB_User cacti
DB_Pass cacti
5.数据库配置
#mysql –uroot –p
Password:
mysql> create database cacti;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on cacti.* to cacti@localhost identified by “cacti”;
mysql> grant all on cacti.* to root;
mysql> grant all on cacti.* to root@localhost;
mysql> grant all on cacti.* to cacti@localhost;
Query OK, 1 row affected (0.00 sec)
mysql>exit
# cd /usr/local/apache/htdocs/cacti
# mysql –uroot –p cacti < cacti.sql
Password:
未完待续........