tayhaithian Posted January 23, 2009 Share Posted January 23, 2009 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' Quote Link to comment https://forums.phpfreaks.com/topic/142074-solved-ftp-site-problem-after-upload-php-and-mysql-base-lang/ Share on other sites More sharing options...
Philip Posted January 23, 2009 Share Posted January 23, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/142074-solved-ftp-site-problem-after-upload-php-and-mysql-base-lang/#findComment-744073 Share on other sites More sharing options...
tayhaithian Posted January 24, 2009 Author Share Posted January 24, 2009 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 . Quote Link to comment https://forums.phpfreaks.com/topic/142074-solved-ftp-site-problem-after-upload-php-and-mysql-base-lang/#findComment-745167 Share on other sites More sharing options...
.josh Posted January 24, 2009 Share Posted January 24, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/142074-solved-ftp-site-problem-after-upload-php-and-mysql-base-lang/#findComment-745242 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.