a mySQL problem.. a big one

Status
Not open for further replies.

delon

Banned
Messages
397
Reaction score
0
Points
0
i got a php form script made from VPmase, he tried to install it on my server with a mySQL database involved.
i had to manually configure the .php files to connect to the database, i entered the correct database name, user and password, but the form didn't work. i asked VPmase to install it and he/she told me that the user is not getting any priveleges to the database whereas he had create a new user for the access to the database and told me to forward this problem to the forums..

now what should i do.
 

bugfinder

Retired
Messages
2,260
Reaction score
0
Points
0
If the db is made under your account, you would be able to modify the rights any user has to the db, so I dont truely understand.
 

delon

Banned
Messages
397
Reaction score
0
Points
0
No what i mean is i create a db for eg. delon_xyz and assigned user delon_xyz to the db and gave it all the privileges.

then i configured the php files where i had to enter all the data regarding my db, i had entered all the data correctly ,so the form could access the database to store the data. but the form was not working. i then asked the creator of the script VPmase to install it for me, he/she told me that the script is not working since the user is not getting the privileges to access the databse. for verification he even created a new user delon_abcd for the database delon_xyz, but still no luck and asked me to post this question in the forums.
 

bugfinder

Retired
Messages
2,260
Reaction score
0
Points
0
Well it looks like all your db users have all privilages, so what command is the script trying to run on the DB thats failing?
 

delon

Banned
Messages
397
Reaction score
0
Points
0
i dont know exactly, can i PM you the scripts
Edit:
please can anybody help me
 
Last edited:

delon

Banned
Messages
397
Reaction score
0
Points
0
the link to the scripts are :

delon.in/register/cap_get_ajax.php
delon.in/register/cap_send_ajax.php
delon.in/register/name_ajax.php
delon.in/register/regjs.js
delon.in/register/delon.php
 

bugfinder

Retired
Messages
2,260
Reaction score
0
Points
0
The only thing I notied was that the register button didnt go enabled.
Other than that, everything else seemed to be working
 

delon

Banned
Messages
397
Reaction score
0
Points
0
that is the main problem, the creator of the script told me that the user of the database is not getting any privileges of accessing the database.
 

Chris73

New Member
Messages
5,356
Reaction score
1
Points
0
You will need to allow permissions so that the "user" can access the DB. This would be done via PHPmyAdmin.
 
Status
Not open for further replies.
Top