SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Nov 2005
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP/MySQL... can't write to db?

    I have been using the SP book Database Drive Website and everything was going along swimingly until this evening. I was able to design, debug and get working a number of web pages to view all of my date (in 7 tables) and I though I had it made.

    Then I went to work on the first of the update programs. It pulls the data fine, I got it displayed but as soon as I tried to write it back to the database I got the error: "Access denied for user 'ODBC'@'localhost' (using password: NO)".

    Searching the net I found the following note on this problem.

    Folks,

    The solution to this is NOT to set a root password during installation.
    Redo your installation... and toggle off the option that allows you to set a root password.

    Then you will get in.

    - cheers


    Well, needless to say I did set a root password as recommended on pg 14ff. Can someone confirm that this is indeed the problem here? Isn't there some way of fixing this besides taking MySQL off of my computer and re-installing it?

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    you're not logging in to the database properly. when you call msql_connect(), you should be passing a username and a password. since you're getting an error with a user of odbc@localhost, that means you're not passing a username and password.

  3. #3
    Web development Company chrisranjana's Avatar
    Join Date
    Jan 2001
    Location
    chennai , tamil nadu , India
    Posts
    706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It pulls the data fine
    So the user has read permissions ?

    How are you reading the database ? are you logging into it as a specific user ?
    Chris, Programmer/Developer, Chrisranjana.com
    Chennai, Tamil Nadu, India.
    Php Developers


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •