Can not enter data to MySQL using PHP web page.

[yu xintian]

Hi,all ! I have just upgraded my old CentOS system,but something goes wrong(1) I can not enter database to MySQL from web page,and I had a "add new contact info" available there before .(2) I want to install SugarCRM to my web page,but SugarCRM can't create database with the right username and password . Other thing is OK, I can get data from MySQL from web page. Here is the package I have : php-5.1.6-3.el4s1.10 mysql-5.0.82sp1-1.el4_8

Does it because that these two packages don't match each other? Thank you in advance!

[dmyersturnbull]

Hey, Yu Xintian.

It sounds like a permissions issue. Make sure that the MySQL user your web application is using can UPDATE, INSERT, and DELETE.

GRANT UPDATE, INSERT, DELETE ON your_db TO your_user@'your_domain' IDENTIFIED BY 'your_password';