MySQL Bugs: #55252: MY SQL don't start!!!!

Bug #55252	MY SQL don't start!!!!
Submitted:	14 Jul 2010 9:48	Modified:	14 Jul 2010 15:07
Reporter:	Giorgio La Rosa	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.1.48	OS:	MacOS (Leopard)
Assigned to:		CPU Architecture:	Any
Tags:	mysqld don't start

Description:
Hi guys,
I have a serious problem.mysqld don't start but i don't understand it.
let my report error log...help me!!!
i try to use MAMP, but i obtain the same one.
thank you...

How to repeat:
100714 11:19:36 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:19:36 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:19:36 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:19:36 [ERROR] Abor

Please, send your my.cnf file content. Use

find / -name my.cnf 2>/dev/null

to find it if in doubts.

macbook-di-la-rosa:etc larosa$ find / -name my.cnf 2>/dev/null
/Applications/MAMP/tmp/mysql/my.cnf 
/private/etc/my.cnf                   

******/Applications/MAMP/tmp/mysql/my.cnf **************
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /Applications/MAMP/db/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
#port		= 9999
socket		= /Applications/MAMP/tmp/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
#port		= 9999
socket		= /Applications/MAMP/tmp/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
bind-address = 127.0.0.1

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
skip-networking

# Replication Master Server (default)
# binary logging is required for replication
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
 server-id	= 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#   CHANGE MASTER TO MASTER_HOST=127.0.0.1, MASTER_PORT=3306,
#    MASTER_USER='root', MASTER_PASSWORD='root' ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Point the following paths to different dedicated disks
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /Applications/MAMP/db/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /Applications/MAMP/db/mysql/
#innodb_log_arch_dir = /Applications/MAMP/db/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

# DONT REMOVE: MAMP PRO my.cnf template compatibility version: 2

*****************/private/etc/my.cnf **************************
!include include/default_mysqld.cnf
!include include/default_ndbd.cnf

[cluster_config.1]
NoOfReplicas=                  2
ndbd=,
ndb_mgmd=
mysqld=,

[cluster_config.slave]
NoOfReplicas=                  1
ndbd=
ndb_mgmd=
mysqld=

[mysqld]
# Make all mysqlds use cluster
ndbcluster
log-bin=mysql-bin
server-id=1
# Turn on bin logging
log-bin=                       master-bin
# Cluster only supports row format
binlog-format=                 row

# Append <testname>-slave.opt file to the list of argument used when
# starting the mysqld
#!use-slave-opt

# Connect mysqld in the second cluster as save to  first mysqld
# Hardcode the host to 127.0.0.1 until running on more
# than one host and it probably need to be masked anyway
# master-host=                @mysqld.1.#host
master-host=                  127.0.0.1
master-port=                  @mysqld.1.1.port
master-password=              @mysqld.1.1.#password
master-user=                  @mysqld.1.1.#user
master-connect-retry=         1

log-bin=                      slave-bin
relay-log=                    slave-relay-bin
# Cluster only supports row format
binlog-format=                 row

init-rpl-role=                slave
log-slave-updates
master-retry-count=           10

# Values reported by slave when it connect to master
# and shows up in SHOW SLAVE STATUS;
report-host=                  127.0.0.1
report-port=                  @mysqld.1.slave.port
report-user=                  root

loose-skip-innodb
skip-slave-start

# Directory where slaves find the dumps generated by "load data"
# on the server. The path need to have constant length otherwise
# test results will vary, thus a relative path is used.
slave-load-tmpdir=            ../../../tmp

rpl-recovery-rank=            @mysqld.1.slave.server-id

[ENV]
NDB_CONNECTSTRING=            @mysql_cluster.1.ndb_connectstring
MASTER_MYPORT=                @mysqld.1.1.port
MASTER_MYPORT1=               @mysqld.2.1.port

NDB_CONNECTSTRING_SLAVE=      @mysql_cluster.slave.ndb_connectstring
SLAVE_MYPORT=                 @mysqld.1.slave.port
SLAVE_MYSOCK=                 @mysqld.1.slave.socket

NDB_BACKUP_DIR=               @cluster_config.ndbd.1.1.BackupDataDir

I'm waiting a your help!!!!thank you very much!!!!

I wonder why do you have that /private/etc/my.cnf at all and do you really need it? 

Please, try to rename that file to, say, /private/etc/my.bak and try to start server again.

i try to make that you writed it, but it isn't happened nothing.Sorry for my english not very well.

sh-3.2# mv /private/etc/my.cnf /private/etc/my.bak
sh-3.2# cd ./Applications/MAMP/bin/startMysql.sh 
sh-3.2# 100714 16:02:06 mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error_log.err'.
100714 16:02:06 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 16:02:06 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

i tried to make the same thing with my.cnf of the other path(/Applications/MAMP/etc/mysql)....the result was the same.

Please, upload content of that /Applications/MAMP/logs/mysql_error_log.err file.

Note also that we do not directly support MAMP in any way. Before considering anything a bug I'd like to see a repeatable test case with 5.1.48 binaries from MySQL site, and, if possible, --no-defaults option added to mysqld_safe command line. For now we are mostly trying to debug your setup, and this can be considered free support, something I am not allowed to provide.

/Applications/MAMP/logs/mysql_error_log.err file:
100714 11:19:36 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:19:36 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:19:36 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:19:36 [ERROR] Aborting

100714 11:19:36 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:19:39 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:19:39 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:19:39 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:19:39 [ERROR] Aborting

100714 11:19:39 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:20:19 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:20:19 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:20:19 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:20:19 [ERROR] Aborting

100714 11:20:19 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:20:20 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:20:20 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:20:20 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:20:20 [ERROR] Aborting

100714 11:20:20 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:20:49 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:20:49 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:20:49 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:20:49 [ERROR] Aborting

100714 11:20:49 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:20:49 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:20:49 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:20:49 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:20:49 [ERROR] Aborting

100714 11:20:49 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:22:40 mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql
100714 11:22:40 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
100714 11:22:40 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql/ is case insensitive
100714 11:22:40 [Note] Plugin 'FEDERATED' is disabled.
100714 11:22:40 [Note] Plugin 'ndbcluster' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100714 11:22:40  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100714 11:22:41  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100714 11:22:41  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100714 11:22:41  InnoDB: Started; log sequence number 0 0
100714 11:22:41 [Note] Event Scheduler: Loaded 0 events
100714 11:22:41 [Note] /Applications/MAMP/Library/libexec/mysqld: ready for connections.
Version: '5.1.44'  socket: '/Applications/MAMP/tmp/mysql/mysql.sock'  port: 3306  Source distribution
100714 11:36:07 [Note] /Applications/MAMP/Library/libexec/mysqld: Normal shutdown

100714 11:36:07 [Note] Event Scheduler: Purging the queue. 0 events
100714 11:36:07  InnoDB: Starting shutdown...
100714 11:36:11  InnoDB: Shutdown completed; log sequence number 0 44233
100714 11:36:11 [Note] /Applications/MAMP/Library/libexec/mysqld: Shutdown complete

100714 11:36:11 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:57:30 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:57:30 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:57:30 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:57:30 [ERROR] Aborting

100714 11:57:30 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:57:40 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:57:40 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:57:40 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:57:40 [ERROR] Aborting

100714 11:57:40 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:58:10 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:58:10 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:58:10 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:58:10 [ERROR] Aborting

100714 11:58:10 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 11:58:20 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 11:58:20 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 11:58:20 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 11:58:20 [ERROR] Aborting

100714 11:58:20 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:07:46 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:07:47 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:07:47 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:07:47 [ERROR] Aborting

00714 12:07:47 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:35:06 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:35:06 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:35:06 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:35:06 [ERROR] Aborting

100714 12:35:06 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:35:21 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:35:21 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:35:21 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:35:21 [ERROR] Aborting

100714 12:35:21 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:35:24 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:35:24 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:35:24 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:35:24 [ERROR] Aborting

100714 12:35:24 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:35:38 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:35:38 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:35:38 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:35:38 [ERROR] Aborting

100714 12:35:38 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:35:40 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:35:40 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:35:40 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:35:40 [ERROR] Aborting

100714 12:35:40 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 12:35:40 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 12:35:40 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER' instead.
Unknown suffix '@' used for variable 'master-port' (value '@mysqld.1.1.port')
100714 12:35:40 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Error while setting value '@mysqld.1.1.port' to 'master-port'
100714 12:35:40 [ERROR] Aborting

100714 12:35:40 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 16:02:06 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 16:02:06 [Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system '/Applications/MAMP/db/mysql/' is case insensitive.  This means that you can corrupt a MyISAM table by accessing it with different cases. You should consider changing lower_case_table_names to 1 or 2
100714 16:02:06 [Note] Plugin 'FEDERATED' is disabled.
100714 16:02:06 [Note] Plugin 'ndbcluster' is disabled.
/Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100714 16:02:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100714 16:02:06  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
100714 16:02:06 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
100714 16:14:54 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
100714 16:14:54 [Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system '/Applications/MAMP/db/mysql/' is case insensitive.  This means that you can corrupt a MyISAM table by accessing it with different cases. You should consider changing lower_case_table_names to 1 or 2
100714 16:14:54 [Note] Plugin 'FEDERATED' is disabled.
100714 16:14:54 [Note] Plugin 'ndbcluster' is disabled.
/Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100714 16:14:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100714 16:14:54  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
100714 16:14:54 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

i'm installing MySql-5.1.48....i do it!!!

i can't install install MySql-5.1.48  why i already have a previous version of MySql....what a mess!!! 
how can i remove previous installation? how can i remove associated files?
thank you

As for error 13 in the logs, it is permission problem:

77-52-227-51:5.1 openxs$ bin/perror 13
OS error code  13:  Permission denied

Maybe you have to use "sudo command" instead of "command" to start server properly, or fix permission problem somehow else?

As for installing 5.1.48 over older version, there should be no problem (other than permissions maybe). Do you use .dmg binaries or .tar.gz ones?

i used the dmg!

how can i pass  Permission denied's problem?

i installed MySQL-5.5.3-m3.....!!!

i solved the problem installing the version 5.5.3-m3....now MySQl server is running THANK YOU VERY MUCH!!!!!!

OK, it is .dmg. Had you followed these instructions then, http://dev.mysql.com/doc/refman/5.1/en/mysql-installation-macosx-pkg.html?

For me it just works (even without startup item and preference pane, with manual startup, as soon as I use sudo to start the server):

valeriy-kravchuks-macbook-pro:mysql openxs$ sudo bin/mysqld_safe
Password:
100714 17:58:47 mysqld_safe Logging to '/usr/local/mysql-5.1.48-osx10.5-x86_64/data/macbook-pro.err'.
100714 17:58:47 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.1.48-osx10.5-x86_64/data
^Z
[1]+ Stopped sudo bin/mysqld_safe
valeriy-kravchuks-macbook-pro:mysql openxs$ bg 1
[1]+ sudo bin/mysqld_safe &
valeriy-kravchuks-macbook-pro:mysql openxs$ bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.48 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
Bye
valeriy-kravchuks-macbook-pro:mysql openxs$ uname -a
Darwin macbook-pro 9.6.0 Darwin Kernel Version 9.6.0: Mon Nov 24 17:37:00 PST 2008; root:xnu-1228.9.59~1/RELEASE_I386 i386