General error: MYSQL

[indhu88]

I have the following setup.

Linux 7.1 with squid/apache/mysql etc.
Sql database is there on Linux server. When i access DB and modify the table/database from client PC (win98SE) i get the error: " GENERAL ERROR: INSERT COMMAND DENIED TO USER AT ip address/port of the server. "
I am using default user account to access the SQL DB. Kindly help me to resolve the issue.

M.Kasi, India.

 

[piti]

looks like you don't have access rights to insert into the db

to see what rights you have issue:
SHOW GRANTS FOR username@winmachineip;

to add you insert rights log on to mysql with the user who has grant rights (e.g. root) and issue:
GRANT INSERT ON yourdbname.* TO username@winmachineip;

hope that helps