Members Login.
 

Please register HERE to be part of our Community
Contest of the Day.
 
Current Promotions.
 
Refer your friends to this forum and earn BRL per referred member.

Post a New Thread anywhere on Web Development Board to earn BRL$ 5 for every thread. Post a New Reply there and earn BRL$ 3 for every reply.

Post a New Thread anywhere on Search Engine Optimization Board and earn BRL$ 5 for every thread.
Earn By Posting
 
Participate in forum and Earn $$$.

Get Referrer Credit - BRL$ 20
Get Positive Rep Cr. - BRL$ 3
Get New Thread Cr.- BRL$ 3
Get Posting Cr. - BRL$ 2
Get Post size Credit

Full List of BRL$ Earnings
Sponsors.
 


mySQL Database Discussion related to mySQL database, mySQL queries, mySQL Commands, mySQL tutorials...

Expired Thread The thread "issue in creating database" has not received any replies for a month. It has been automatically closed as a result. You may start a new thread on the topic if the information in this thread is not sufficient.

Closed Thread
  #1 (permalink)  
Old 12-11-2007
New Foot Prints

Join Date: Aug 2007
Posts: 3
BRL$: -102.93
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
kalaid is on a distinguished road
Default issue in creating database

Hi,
When i create a database as a user i get the following error,
Access denied for user ''@'LocalHost' to database 'test'
what is the issue.
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-20-2008
Jr. Member

Join Date: Mar 2008
Posts: 263
BRL$: -140.73
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 38
mira is on a distinguished road
Default Re: issue in creating database

arer you using database on local machine or at the server? If on the server check username and password for it properly. There must be a problem. Plus check all the permissions too.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-21-2008
New Foot Prints

Join Date: Mar 2008
Posts: 14
BRL$: -7.90
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
superbike is on a distinguished road
Default Re: issue in creating database

Please check database mysql and check table user. I believe you mistakenly put a value either in Field 'User' or 'Password'. To be safe just leave both blank. That is the easiest way. If you have figure out what the problem is, just put real values in both field as a security measure
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-19-2008
Jr. Member

Join Date: Apr 2008
Location: California
Posts: 156
BRL$: 42.33
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 25
binary8383 is on a distinguished road
Default Re: issue in creating database

hi,

access denied normally has to deal with the dbconnect string where you will specify the username and password and which database to access to. make sure the username and password is the same as in your database user's accout (user that allow to use your mysql).

by default, you can use root as your user. To use it, username is root and password is blank.

have a nice try.

all the best.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-19-2008
Jr. Member

Join Date: Apr 2008
Posts: 807
BRL$: 253.33
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 90
sysax is on a distinguished roadsysax is on a distinguished roadsysax is on a distinguished roadsysax is on a distinguished road
Default Re: issue in creating database

You MUST use your login for your CPanel , and not from an admin in your SQL!
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-20-2008
Jr. Member

Join Date: Apr 2008
Location: California
Posts: 156
BRL$: 42.33
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 25
binary8383 is on a distinguished road
Default Re: issue in creating database

hi,

Quote:
You MUST use your login for your CPanel , and not from an admin in your SQL!
is this means that the username and password to connect a database must based on the Cpanel?

thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-20-2008
Jr. Member

Join Date: Apr 2008
Posts: 807
BRL$: 253.33
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 90
sysax is on a distinguished roadsysax is on a distinguished roadsysax is on a distinguished roadsysax is on a distinguished road
Default Re: issue in creating database

yes, I had the same problem, I used the admin details that are listen IN de MySQL database, but you need to use your Cpanel-login user & password to get access to your database.
I hope it's fixed now.
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Closed Thread
Expired Thread The thread "issue in creating database" has not received any replies for a month. It has been automatically closed as a result. You may start a new thread on the topic if the information in this thread is not sufficient.



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
setting up a mySQL database mr_atom mySQL Database 1 04-17-2008 10:07 AM
setting up a mySQL database mr_atom mySQL Database 0 09-25-2007 04:39 PM
Database access / Database MYSQL Rss_Feeds PHP 0 09-12-2007 11:52 AM
How to access database through ASP? brl_admin ASP / ASP.NET 0 09-04-2007 09:50 AM
Moving the Tempdb and Master Database in SQL Server mr_atom Microsoft SQL Server 0 07-14-2007 07:03 AM


 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105