Hi,
I am trying use MySQL on RedHat 9 Linux box. I
installed the following rpms for this.
mysql-3.23.54a-11.i386.rpm
mysql-server-3.23.54a-11.i386.rpm
mysql-devel-3.23.54a-11.i386.rpm
After installing I executed the mysql_install_db
script, which executed without giving any error. I
restarted MySQL Server(through service mysqld restart
command). But when I tried to use mysqladmin command,
I am always getting this error.
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)'
When I execute 'mysqladmin version' or 'mysqladmin
ping', that time also I am getting the same error. My
machine have an entry for the localhost in /etc/hosts
file ( I can ping to localhost and 127.0.0.1)/At the
same time I can telnet to localhost on port 3306 which
gives the following output
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
(
3.23.543V8T~>W{,
Connection closed by foreign host
I am doing all these things in super user mode. Also I
noted that my
/var/log/mysqld.log has the following lines.
031203 11:13:26 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is
not set.
If you do not want to use transactional InnoDB tables,
add a line
skip-innodb to the [mysqld] section of init parameters
in your my.cnf or my.ini.
If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your
hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections
I went through MySQL Installation docs, but could not
fix this problem. Any body can help me to fix this
problem?
Thanks in advance
Sudheer
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
