安装MYSQL出错.............帮忙解决下 先谢了!

第六弦

安装MYSQL 5.0 时, ./configure  make    make install  都通过了

cd /usr/local/bin
./mysql_install_db(安装mysql的基本数据库)

到这一步不行了,出错信息如下!!   老鸟帮忙解决下!1

我的内核2.4.20-8


...............................................................................................................
WARNING: The host 'start-net0' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h start-net0 password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com

cgc837

在/etc/hosts文件中将主机名start-net0加进去试试
格式：
IP       域          主机名

下载二进制文件安装很方便的，就几个步骤，没编译安装那个必要。

第六弦

太感谢了  问题解决了!!

  可是   问题又来了  

  我输入 :/opt/mysql/bin/mysqld_safe &
  提示: Starting mysqld daemon with databases from /opt/mysql/var
       STOPPING server from pid file /opt/mysql/var/start-net0.pid
       061215 09:53:50  mysqld ended
  查错: cd /opt/myql/var
  提示:
061215 09:48:35  mysqld started
/opt/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
061215  9:48:35 [ERROR] Aborting

061215  9:48:35 [Note] /opt/mysql/libexec/mysqld: Shutdown complete

061215 09:48:35  mysqld ended

我把mysql-bin.index添加到 /opt/mysql/libexec/  路径 还是不行!!!

   cgc837 兄 ,多谢你了!!

   路过继续帮下了!!!!!!................在线等!!

cgc837

/opt/mysql/var/应该是放数据库文件的目录，用二进制文件安装一般是data文件夹。
里面有mysql-bin.000001~mysql-bin.000008的文件和mysql-bin.index文件。
在我这，mysql-bin.index内容是
<CODE>./mysql-bin.000001
./mysql-bin.000002
./mysql-bin.000003
./mysql-bin.000004
./mysql-bin.000005
./mysql-bin.000006
./mysql-bin.000007
./mysql-bin.000008
</CODE>
你看看你的/opt/mysql/var/文件夹内有没有这些文件，还有mysql-bin.index文件的内容是否相符。
另外，在编译好之后还要拷一个文件到/etc/目录下。
cp /opt/mysql/share/mysql/my-medium.cnf /etc/my.cnf
是将配置文件拷贝到/etc目录下成为my.cnf,大家可以根据自己的需要选择配置文件(配置文件在/opt/mysql/share/mysql/目录下,有my-huge.cnf my-medium.cnf my-large.cnf my-small.cnf这些).目录不一定是/opt/mysql/shere/mysql,反正你要在mysql安装目录下找到这些文件拷一个进去，并改名为my.cnf。
你最好看看http://blog.chinaunix.net/u/10869/showart_185695.html这篇文章，这里也是编译安装mysql的。

cgc837

你最好看看http://blog.chinaunix.net/u/10869/showart_185695.html这篇文章，这里也是编译安装mysql的。

第六弦

啊 !!  哭亚!!

    我重新安装了一便  前面的问题没了!!现在查错提示::

061215 10:59:01  mysqld started
061215 10:59:01 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

061215 10:59:01 [ERROR] Aborting

061215 10:59:01 [Note] /opt/mysql/libexec/mysqld: Shutdown complete

061215 10:59:01  mysqld ended

  怎么改变用户名呀!!!!!!!!  一点操作都不会  只能在这苦求了  嗨!!...................................

第六弦

谢谢 gcg 兄了  你真热心


   我再整整!!!!

第六弦

哈哈   解决了!!!!   太感谢GCG兄了..........

大家看文章一定要子细呀.........其实南北兄都已经是很详细了.不过我还是漏了点
http://www.linuxsir.cn/bbs/showthread.php?t=77079

还有  怎么结贴呀!!!呵呵