Re: Certification Question

[Amanullah]

I'm also interested to take up the certification exam on Mysql,
pl. guide me how to proceed to get certification on the same,
I'm in India (chennai).
-aman.

Arjun Subramanian wrote:

I took the MySQL core certification exam on the 2nd of January and
Passed. I was just wondering when MySQL actually sends out the
Certificate and other stuff they said they would send out? Does anyone
here have any experience with this ?
Thanks in advance.

Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell: +404.429.5513
http://www.arjunweb.com
-----Original Message-----
From: Amanullah [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 10:03 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: New INstall of MySQL

Hi,

make sure the existing directories has been removed fully, then continue

with
new installation, after installation is over, pl. restart the system, if
mysql daemon
has not started, pl. go to ..\mysql\bin\ directory & run
winmysqladmin.exe.
mysql service will be strated to work..

-Aman.

Chris L. White wrote:

 

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: [EMAIL PROTECTED]