SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question "Kevin Yank's Database driven website..." MySQL connection issue

    I'm reading the 4th edition of Database driven...with MySQL and PHP. I've had most of my issues with the other components sorted with info from this site, however, after reaching

    Post-Installation Set-up Tasks

    trying to check MySQL status query mysqladmin -u root status in the command prompt I get the following message:

    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)


    I've installed the MySQL community server 5.5.14 using the Windows (x86, 32-bit), MSI Installer and mysqld.exe is running in processes. If anyone could shed some light on the matter, it would be great.

    I've been bogged down on just installing the components for the last 2 days. Since the book says it's better to do it separately, i.e. learn more i'm trying to stick to it, but i'd really just get started on the coding and other aspects of the languages.

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried that and the option to set password from the book. However my MySQL installation dir only has one .ini and two .bak files and nothing else. Maybe I have downloaded the wrong version?

  4. #4
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I don't understand your response. You should have only one .ini file (my.ini in Windows, my.cnf in Linux). How is this related to changing your password?

  5. #5
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry I meant that the directory MySQL was installed to had only 'my.ini' and two .bak files and there were no bin directories or anything else. I've reinstalled it and everything seems to be in order and i've just successfully reset and connected to MySQL. Thank you so much for your help.

    Cheers.


Tags for this Thread

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
  •