SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Member
    Join Date
    Jun 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mySQL installed but won't run

    I can install MySQL server just fine as a service(mysqld-nt --install), but when I run it (net start mysql) I get a "starting" message, followed by "The MySql service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly."


    Mmysql.err is full of "MySql: Table 'mysql.host' doesn't exist" errors. How do I fix this?

    Tim

  2. #2
    web daemon jorasmi's Avatar
    Join Date
    Nov 2001
    Location
    Philippines
    Posts
    296
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try typing on your shell "service httpd start"

  3. #3
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    do you have MySQL installed somewhere other than C:\mysql? if so, i think you'll get this error if you don't have a C:\my.cnf or Windows\my.ini (WINNT\my.ini on NT). if you don't have either of those, create a file called my.ini in your Windows folder and put this in it:

    Code:
    [mysqld]
    # Uncomment and change the next line if you installed
    # MySQL somewhere other than the default C:/mysql
    #basedir=C:/mysql
    port=3306
    skip-locking
    set-variable = table_cache=512
    set-variable = thread_cache_size=8
    set-variable = wait_timeout=3600
    
    [client]
    port=3306
    # Here you can put your username and password
    # if you want so that you don't have to manually
    # enter them when using mysql, mysqldump, etc.
    # Uncomment the lines if you do!
    #user=<username>
    #password=<password>
    
    [mysql]
    no-auto-rehash
    
    [mysqldump]
    quick
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  4. #4
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by jorasmi
    try typing on your shell "service httpd start"
    just to point out: that command would actually start Apache server (if it's installed), not the MySQL server...

  5. #5
    SitePoint Member
    Join Date
    Jun 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the help, but I still have the problem. MySQL can't find "mysql.host", and I can't find any documentation on what that means.

  6. #6
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    `host' is a table in the `mysql' database that is installed by default. if it's not there, the only thing i can say is run the install again. hopefully that will put it there.


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
  •