#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    13
    Rep Power
    0
    Hi, I'm a newbie so pardon this question. I can't get to my newly created database. At the mysql prompt I type in "use dbname;" and I get "access denied for user: '@localhost' to database 'dbname'" (dbname is a not the real name.). I'm following the instructions from right here at devshed, so I've got no idea what to do now.

    P.S. I didn't create the database, my ISP's system administrator did. So a second question would be, how do I find out if the database is really there?
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,646
    Rep Power
    4492
    show databases;

    See if your database is there. If it is and you still can't use

    use your_db;

    then they messed something up when they created your permissions.

    ---JH
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    13
    Rep Power
    0
    Thanks SepodatiCreations. The database is there along with 7 others but I still can't access it. Hopefully the system administrator will fix the permissions tomorrow.

    --john

Similar Threads

  1. MySQL Error Access denied for user error
    By krishna_seshayy in forum MySQL Help
    Replies: 0
    Last Post: February 12th, 2004, 12:06 AM
  2. php: access database
    By theodore in forum PHP Development
    Replies: 3
    Last Post: February 11th, 2004, 05:23 PM
  3. Can't access the database info!
    By Axsuul in forum PHP Development
    Replies: 5
    Last Post: February 11th, 2004, 01:22 AM
  4. database access using thread
    By padmini in forum Visual Basic Programming
    Replies: 3
    Last Post: February 6th, 2004, 01:38 AM
  5. How to restrict access to database
    By xyfix in forum Database Management
    Replies: 0
    Last Post: January 16th, 2004, 05:34 AM

IMN logo majestic logo threadwatch logo seochat tools logo