MySQL database set up and TIQAM
3 views
Skip to first unread message
Sri
Mar 6, 2009, 1:13:35 AM3/6/09
to TIQAM
Hello all
Let me apologise in advance if this is a silly well covered question.
I am new to TIQAM and just recently tried to install it. I just
installed mysql 5.0 however it gives me an error message when I am
trying to set up the database for TIQAM.
I am not able to use the intitialize.sql as it says:
Error 1064 <42000> at line 2 you have an error in you SQL syntax check
the manual that corresponds to your MYSQL server version for the right
syntax to use near '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
TRANSITIONAL//EN" "HTTP://WWW.W3.OR' AT LINE 1
Whn I try to do the same by manually typing the commands given on the
TIQAM qiki site, i go well until I reach the step
mysql> grant all privileges on trans.\* to 'm'@'localhost' identified
by 'mmm' with grant option;
where it gives the error 1064 and asks to check syntax near the '\* to
'm'@'local host........
Any ideas how I can fix this? Am I using the right version? I tried
the latest version of mySQL (5.1) and it did not work so I thought I
should go back to the version mentioned in the Wiki 5.0. I have a
windows vista ultimate 32 bit system. Mysql installation went smoothly
according to what was mentioned in in the WIKI.
Any help would eb greatly appreciated.
Cheers
Sri
Let me apologise in advance if this is a silly well covered question.
I am new to TIQAM and just recently tried to install it. I just
installed mysql 5.0 however it gives me an error message when I am
trying to set up the database for TIQAM.
I am not able to use the intitialize.sql as it says:
Error 1064 <42000> at line 2 you have an error in you SQL syntax check
the manual that corresponds to your MYSQL server version for the right
syntax to use near '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
TRANSITIONAL//EN" "HTTP://WWW.W3.OR' AT LINE 1
Whn I try to do the same by manually typing the commands given on the
TIQAM qiki site, i go well until I reach the step
mysql> grant all privileges on trans.\* to 'm'@'localhost' identified
by 'mmm' with grant option;
where it gives the error 1064 and asks to check syntax near the '\* to
'm'@'local host........
Any ideas how I can fix this? Am I using the right version? I tried
the latest version of mySQL (5.1) and it did not work so I thought I
should go back to the version mentioned in the Wiki 5.0. I have a
windows vista ultimate 32 bit system. Mysql installation went smoothly
according to what was mentioned in in the WIKI.
Any help would eb greatly appreciated.
Cheers
Sri
Vinz
Mar 6, 2009, 2:48:26 AM3/6/09
to TIQAM
Hi Sri,
sorry for the trouble.
The initialize.sql file should be text containing the following:
create database trans;
create database mrm;
use mysql;
grant all privileges on trans.* to 'm'@'localhost' identified by 'mmm'
with grant option;
grant all privileges on mrm.* to 'm'@'localhost' identified by 'mmm'
with grant option;
grant all privileges on mrm.* to 'm'@'%' identified by 'mmm' with
grant option;
FLUSH PRIVILEGES;
You need to follow the link on the Wiki and then download the file.
You have saved the link instead. I agree, it is a bit misleading. Open
the file in text editor to make sure you have the right thing
downloaded.
Enjoy,
Vinz
sorry for the trouble.
The initialize.sql file should be text containing the following:
create database trans;
create database mrm;
use mysql;
grant all privileges on trans.* to 'm'@'localhost' identified by 'mmm'
with grant option;
grant all privileges on mrm.* to 'm'@'localhost' identified by 'mmm'
with grant option;
grant all privileges on mrm.* to 'm'@'%' identified by 'mmm' with
grant option;
FLUSH PRIVILEGES;
You need to follow the link on the Wiki and then download the file.
You have saved the link instead. I agree, it is a bit misleading. Open
the file in text editor to make sure you have the right thing
downloaded.
Enjoy,
Vinz
Sri
Mar 17, 2009, 3:47:46 AM3/17/09
to TIQAM
Thanks Vinz
changing the initialize.sql to what you mentioned in the message
helped me fix the error. One more small point that I came to know was
that I was not able to get into MYSQL by using the commands given on
the WIKI. I had to type in
.....bin>mysql -u root -p
Is it because of some setting I changed or because of vista?
Nevertheless, TIQAM is working on my PC now, so very happy!
Thanks again for the help!
Cheers
Sri
changing the initialize.sql to what you mentioned in the message
helped me fix the error. One more small point that I came to know was
that I was not able to get into MYSQL by using the commands given on
the WIKI. I had to type in
.....bin>mysql -u root -p
Is it because of some setting I changed or because of vista?
Nevertheless, TIQAM is working on my PC now, so very happy!
Thanks again for the help!
Cheers
Sri
Reply all
Reply to author
Forward
0 new messages