Windows server 2008 上部署开源CRM系统(3)

图3使用phpMyAdmin创建MySQL数据库

2 使用命令行工具51CTO.com独家特稿

通常笔者更加喜欢命令行的方式，进入mysql的bin目录执行如下命令：

G:\wamp\mysql\bin> mysql -u root -p

mysql> create database vtigercrm;

mysql> grant all privileges on vtigercrm.* to vtiger@localhost identified by 'password';

mysql> flush privileges;

mysql> exit

Bye

测试一下刚刚建立的数据库

G:\wamp\mysql\bin>mysql -u root -p

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 9 to server version: 5.0.21-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> connect vtigercrm ;

Connection id:    10

Current database: vtigercrm

mysql> show databases;

+--------------+
| Database     |
+--------------+
| mysql        |
| vtigercrm    |
+--------------+

2 rows in set (0.00 sec)

mysql>quit

Bye

打开vTigerCRM根目录下的config.php,修改里面的变量，使之和上面创建的数据库用户和密码以及mysql通信端口一致。

    $mysql_username = ' vtigercrm ';

    $mysql_password = ' vtigercrm ';

    $mysql_port = '3306';