Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 9 of 9
  1. #1
    New Coder
    Join Date
    Mar 2006
    Posts
    51
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Unhappy Cannot start MySQL. Please help..

    Hi..

    I have configure Apache and PHP successfully.
    Then I try to configure MySQL. I have install it as Windows service and run it.
    But when I type 'mysql' it says 'Access denied for user ODBC@localhost'.
    Where exactly should I fix it?

    Thank you so much for help.

    Best regards.

  • #2
    New Coder
    Join Date
    Jan 2007
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Not enough information.

  • #3
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    yes it is enough information. It is telling you that you don't have access for that user.

    are you starting from a command prompt/shell? or are you using a GUI to start mysql?

    Did you create a regular user when you installed mysql or only the root user? you should create a user and not rely on the root user. to test if the root user can connect, by default you only need to name the root user but no password.

  • #4
    New Coder
    Join Date
    Mar 2006
    Posts
    51
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I install and run it from command prompt only, not by any GUI.

    These are commands I have done:

    Code:
    - mysqld-nt --console
    - mysqladmin -u root shutdown
    - mysqld-nt --install
    - net start mysql
    then when I type 'mysql' it says the error message.
    what is command I should use to make it clear?

    Thank you very much.

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    you can have mysql start as a service if that would be easier for you (I personally find that it is).

    when you get to the point that you need to connect to the mysql client, instead of doing this:
    Code:
    mysql
    do this:
    Code:
    mysql -uroot
    and of course it would help if you answered whether or not you installed a regular user and whether or not you included a password for your root user.

  • #6
    New Coder
    Join Date
    Mar 2006
    Posts
    51
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Yes, I run mysql -uroot and success. Thank you..
    I've attached the error message when I type mysql.

    What is command to add user so I don't need to add -uroot parameter?

    Thank you..
    Attached Thumbnails Attached Thumbnails Cannot start MySQL. Please help..-mysql_user.jpg  

  • #7
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    GRANT syntax from the manual.

  • #8
    Senior Coder CFMaBiSmAd's Avatar
    Join Date
    Oct 2006
    Location
    Denver, Colorado USA
    Posts
    3,092
    Thanks
    2
    Thanked 322 Times in 314 Posts
    If you are using Windows, I seriously recommend that you obtain the Windows Essentials .msi version of mysql to install and configure the instance of the mysql server. Also, the mysql administrator (part of the GUI tool box) should be used to create users and databases.
    If you are learning PHP, developing PHP code, or debugging PHP code, do yourself a favor and check your web server log for errors and/or turn on full PHP error reporting in php.ini or in a .htaccess file to get PHP to help you.

  • #9
    New Coder
    Join Date
    Mar 2006
    Posts
    51
    Thanks
    1
    Thanked 0 Times in 0 Posts
    All right. I'll try to.
    Thank you so much for all of helps.

    I realy realy appreciate it.
    Thank you..

    Best regards.


  •  

    Posting Permissions

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