[SOLVED] FTP site problem after upload. [ PHP and MYSQL base lang ]

[tayhaithian]

hi again . i have a FTP site which is byethost.com and uploaded all the file.php and databases to the site . It shows up error when i was trying to insert into database while localhost doesnt have any problem at all .

Weird case is it can be login which mean it detects the database and compare the logical from usernam and password . But couldn't insert new data.

Any idea ??

Sry if i have posted into wrong category.

 

Erors below:

INSERT command denied to user 'b31_2847909'@'209.190.85.202' for table 'cusorder'

[Philip]

Make sure that mysql user has the correct privileges (permissions). You can check this with your hosting account's site admin typically, or via command line... see here about it:

http://www.iis-aid.com/articles/how_to_guides/assigning_mysql_privileges_via_the_command_line

 

[tayhaithian]

solved . coz whenever i create database on web hosting the proper name of database example abc will become "b1234_abc" so i have to edit all over again haizz ....

 

well anyway thx KingPhilip .

[.josh]

Right.  As you have figured out, shared hosts usually attach prefixes to database names and usually even database user names.  Prefix is usually some part of your hosting account username or domain name, like the first 8 chars of it.