JIVE用MYSQL数据库的问题(菜鸟级)

03-07-02 drgoo
JIVE的安装步骤:
1.数据库安装,database目录中选择对应数据库如jive_mysql.sql
在你数据库服务器上建立数据库名Jive 导入jive_mysql.sql

请问该怎样将jive_mysql.sql导入到我的MYSQL中呢~~
我在DOS下进入mysql命令行模式用什么命令才能实现呢

bmw008
2003-07-02 20:32
有\.这个命令
mysql>use jive;//进入jive库
mysql>\. c:\Jive_mysql.sql//假设你的sql文件在c盘
但我在windows下试总说执行文件出错,我就把源代码拷进去执行
如:
mysql>use jive;
mysql>create table……;回车,一样可以建表!
在linux下就不会报那个错,但我在jive安装设置界面,到测试数据库连接
时,报错:数据库连接不能建立。打开日志文件"jiveHome\logs\
DefaultConnectionProvider.log" 查看错误信息然后返回修正错误。
DefaultConnectionProvider.log内容如下:
Starting ConnectionPool:
dbDriver = org.gjt.mm.mysql.Driver
dbServer = jdbc:mysql://localhost/jive
dbLogin = root
log file = /opt/tomcat/webapps/jive/WEB-INF/jiveHome/logs/DefaultConnectionProvider.log
minconnections = 3
maxconnections = 10
Total refresh interval = 0.5 days
-----------------------------------------
--->Attempt (1 of 5) failed to create new connections set at startup:
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)
Will try again in 10 seconds...
--->Attempt (2 of 5) failed to create new connections set at startup:
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)
Will try again in 10 seconds...
--->Attempt (3 of 5) failed to create new connections set at startup:
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)
Will try again in 10 seconds...
--->Attempt (4 of 5) failed to create new connections set at startup:
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)
Will try again in 10 seconds...

All attempts at connecting to Database exhausted
还请高手指点!!!!感谢!!!

lodi
2003-07-02 21:24
C:\mysql\bin\>mysql
mysql>create database jive
mysql>exit

修改jive_mysql.sql,加入在第一行
use jive
......
......

c:\mysql\bin\>mysql < jive_mysql.sql

C:\mysql\bin\>mysql
mysql>use jive
mysql>show tables

可以看到所有的表了

drgoo
2003-07-04 10:31
行了,太感谢两位了~~

楚天一笑
2003-07-06 20:56
我按照楼上大侠的方法,在Jive_mysql.sql中增加了一行
use Jive;
然后打开mysql.exe
mysql>Jive_mysql.sql
mysql>\g
却提示说第一行出错
请问这是怎么回事(菜菜的问)

wusanfeng
2003-07-23 23:20
在mysql下还要对jive数据库创建一个用户,并授权。
我创建完后没有立即生效,重启后才连接正常。

fengchen
2003-07-24 18:33
去下载MySQL Control Center,图形界面管理mysql,很方便!偶就是用这个的!