 Permission Problem With Mysql Database Creation, Please Help! |
|
|
|
|
  |
 Feb 5 2007, 06:39 PM
Post
#1
|
|
|
Member [ Level 1 ]  Group: Members Posts: 42 Joined: 2-January 07 Member No.: 19,036  |
I seem to have a problem with accessing my database with proper permissions. I have set the my database correctly giving my db username all priviliges yet i seem to be unable to even log on with this username with a denied access error. Any ideas on resolving this?
|
 |
 
|
|
Feb 6 2007, 02:18 PM
Post
#2
|
|
|
Nenad Bozidarevic  Group: [MODERATOR] Posts: 993 Joined: 7-November 05 From: Belgrade, Serbia Member No.: 9,500 |
What is the exact error? It would be great if you could copy it here, since without it we can't really help you
|
|
|
|
|
Feb 7 2007, 04:50 AM
Post
#3
|
|
|
Guilty Until Proven Innocent Group: Members Posts: 372 Joined: 13-April 05 Member No.: 3,937 |
QUOTE(FoRsAkEn @ Feb 6 2007, 02:39 AM)  I seem to have a problem with accessing my database with proper permissions. I have set the my database correctly giving my db username all priviliges yet i seem to be unable to even log on with this username with a denied access error. Any ideas on resolving this? you need to grant the user access to the database system. there are many ways the error can be triggered but it all drops down on the grant of permission. one of the most common error that was done here is that the user you have created have a full access on a database but are connecting to a different one which it has no access at all. Giving a full access on a user must be done separately on each database in which you want to grant it access. Unless of course you are using a root account.. =) --------- |
|
|
|
|
Feb 8 2007, 03:37 PM
Post
#4
|
|
|
Advanced Member Group: Members Posts: 179 Joined: 15-November 05 From: Inland from the Left Coast of Canada Member No.: 9,627 |
Cpanel adds the user-name prefix. Are you allowing for that?
|
|
|
|
|
Feb 9 2007, 04:34 AM
Post
#5
|
|
|
Super Member  Group: [HOSTED] Posts: 582 Joined: 12-July 06 From: Ontario, Canada Member No.: 14,464 |
As your title implies, you have trouble CREATING MySQL databases. As for that, please do it via cPanel, SQL queries and phpMyAdmin doesn't grant you permission to create databases.
If you are having trouble accessing databases, please DELETE the user and recreate it. Any further problems will cause you to have to delete the entire database possibly. If that is NOT an option, I'm afraid I can't help you. 
|
|
|
|
|
Feb 10 2007, 04:56 PM
Post
#6
|
|
|
Advanced Member Group: Members Posts: 101 Joined: 10-February 07 Member No.: 20,324 |
QUOTE(FoRsAkEn @ Feb 5 2007, 12:39 PM) I seem to have a problem with accessing my database with proper permissions. I have set the my database correctly giving my db username all priviliges yet i seem to be unable to even log on with this username with a denied access error. Any ideas on resolving this? I know this has happened to me before and is very annoying I still never found out y. |
|
|
|
|
Feb 10 2007, 06:49 PM
Post
#7
|
|
|
Member [ Level 1 ] Group: Members Posts: 42 Joined: 2-January 07 Member No.: 19,036 |
Thanks for the feedback and comments everyone, but my real problem is im using a program to create a whole database for me which goes through a prompt asking questions about my webserver/database stuff etc. The same error keeps occurring though where it says the user specified doesn't have permission access. I am well aware of prefixes and did everything right but the problem is still persisting
but thanks for trying to help everyone, ill let you all know if the problem is solved.
|
|
|
|
|
Feb 12 2007, 04:08 PM
Post
#8
|
|
|
Guilty Until Proven Innocent Group: Members Posts: 372 Joined: 13-April 05 Member No.: 3,937 |
QUOTE(FoRsAkEn @ Feb 11 2007, 02:49 AM) Thanks for the feedback and comments everyone, but my real problem is im using a program to create a whole database for me which goes through a prompt asking questions about my webserver/database stuff etc. The same error keeps occurring though where it says the user specified doesn't have permission access. I am well aware of prefixes and did everything right but the problem is still persisting but thanks for trying to help everyone, ill let you all know if the problem is solved.what this software that you are installing on the first place? i can assist you here on how to do it. though i was lazy to check the forum now that often as I use to [already a paid member and just browsing here], a private message wont do but you can freely email me at vhortex at gmail dot com =) cya mate.. PS. in case you will email me.. put on the subject, astahost help so my spam filter wont accidentaly put your email in the spam box. |
|
|
|
|
Apr 24 2008, 04:36 PM
Post
#9
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 0 Joined: 1-November 07 Member No.: 25,869 |
I am a beginner. I have a golf web page. How do I create a database so members can sign up for a tee reservation and their name would appear on a page right away. Thank you in advance.
|
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 4th July 2008 - 04:34 PM |