List:General Discussion« Previous MessageNext Message »
From:Chris L. White Date:January 9 2004 4:23pm
Subject:New INstall of MySQL
View as plain text  
Ok I have a question.   This is the first time any of us here in our office
have installed MySQL or for that fact worked with MySQL.  So I got stuck
with trying to figure it out.  Ok here is the problem.  I completely removed
the previous MYSQL installation attempt.  I started new to install MYSQL.  I
go to setup and run the setup and the status bar does not move much and the
installation takes about 5 seconds and then it is done.  I get to the
finished installing screen, but there are no options to choose from like the
test in the screen says there should.  Also I have a my.cnf and ny.ini file
in the proper places and I still have nothing going.  I am confused and the
manual I am finding is not clear enough on this.  I included what the my.cnf
and my.ini file looks like.  And also included the error I am getting after
installation.  Also after MYSQL is installed should there not be some icons
for things related to it, because I don't even have them.  I am trying to
install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP
installed.  Please help.

 

[mysqld]

# set basedir to your installation path

# basedir=C:/mysql

# set datadir to the location of your data directory

#datadir=C:/SQLData

 

# Example mysql config file.

# Copy this file to c:\my.cnf to set global options

# 

# One can use all long options that the program supports.

# Run the program with --help to get a list of available options

 

# This will be passed to all mysql clients

[client]

#password=my_password

port=3306

#socket=MySQL

 

# Here is entries for some specific programs

# The following values assume you have at least 32M ram

 

# The MySQL server

[mysqld]

port=3306

#socket=MySQL

skip-locking

set-variable      = key_buffer=16M

set-variable      = max_allowed_packet=1M

set-variable      = table_cache=64

set-variable      = sort_buffer=512K

set-variable      = net_buffer_length=8K

set-variable      = myisam_sort_buffer_size=8M

server-id   = 1

 

# Uncomment the following if you want to log updates

log-bin

 

# Uncomment the following rows if you move the MySQL distribution to another

# location

basedir = c:/mysql/

datadir = c:/SQLData

 

 

# Uncomment the following if you are NOT using BDB tables

skip-bdb

 

# Uncomment the following if you are using BDB tables

#set-variable     = bdb_cache_size=4M

#set-variable     = bdb_max_lock=10000

 

# Uncomment the following if you are using Innobase tables

#innodb_data_file_path = ibdata1:400M

#innodb_data_home_dir = c:\ibdata

#innodb_log_group_home_dir = c:\iblogs

#innodb_log_arch_dir = c:\iblogs

#set-variable = innodb_mirrored_log_groups=1

#set-variable = innodb_log_files_in_group=3

#set-variable = innodb_log_file_size=5M

#set-variable = innodb_log_buffer_size=8M

#innodb_flush_log_at_trx_commit=1

#innodb_log_archive=0

#set-variable = innodb_buffer_pool_size=16M

#set-variable = innodb_additional_mem_pool_size=2M

#set-variable = innodb_file_io_threads=4

#set-variable = innodb_lock_wait_timeout=50

 

[mysqldump]

quick

set-variable      = max_allowed_packet=16M

 

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

 

[isamchk]

set-variable      = key_buffer=20M

set-variable      = sort_buffer=20M

set-variable      = read_buffer=2M

set-variable      = write_buffer=2M

 

[myisamchk]

set-variable      = key_buffer=20M

set-variable      = sort_buffer=20M

set-variable      = read_buffer=2M

set-variable      = write_buffer=2M

 

[mysqlhotcopy]

interactive-timeout

 

 

C:\MySQL\bin>mysqld --console

040109  9:53:02  InnoDB: Started

040109  9:53:02  Fatal error: Can't open privilege tables: Table
'mysql.host' d

esn't exist

040109  9:53:02  Aborting

 

040109  9:53:02  InnoDB: Starting shutdown...

040109  9:53:04  InnoDB: Shutdown completed

040109  9:53:04  mysqld: Shutdown Complete

 

Chris L. White
Network Administrator 
Coe-Truman Technologies, Inc.
Email: cwhite@stripped

 


Thread
New INstall of MySQLChris L. White9 Jan
  • Re: New INstall of MySQLVictor Medina9 Jan
    • RE: New INstall of MySQLChris L. White9 Jan
  • Re: New INstall of MySQLrobert_rowe9 Jan
  • Re: New INstall of MySQLAmanullah10 Jan
    • Certification QuestionArjun Subramanian10 Jan
      • Re: Certification QuestionAmanullah10 Jan
        • Re: Certification QuestionBernard Clement10 Jan
          • Re: Certification QuestionCarsten Pedersen13 Jan
      • Re: Certification QuestionAmanullah12 Jan
      • Re: Certification QuestionMike12 Jan