安装MySQL5.0成功，启动出现问题，请达人指教（已解决）

mig-ling

Jack:~ root# /usr/local/mysql/bin/mysqld      
060131 21:09:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-max-5.0.18-osx10.4-powerpc/data/ is case insensitive
060131 21:09:03 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

060131 21:09:03 [ERROR] Aborting

060131 21:09:03 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

[ 本帖最后由 mig-ling 于 2006-2-1 21:19 编辑 ]

dreammaker

try to use mysqld_safe

mig-ling

问题解决了，谢谢楼上。

Jack:/usr/local/mysql/bin root# ./safe_mysqld
Starting mysqld daemon with databases from /usr/local/mysql/data


Jack:~ root# netstat -na|grep 3306     
tcp4       0      0  *.3306                 *.*                    LISTEN


Jack:~ root# /usr/local/bin/nmap 127.0.0.1 -p 3306

Starting Nmap 3.9999 ( http://www.insecure.org/nmap/ ) at 2006-02-01 21:07 GMT-8
Interesting ports on localhost (127.0.0.1):
PORT     STATE SERVICE
3306/tcp open  mysql

Nmap finished: 1 IP address (1 host up) scanned in 0.035 seconds

[ 本帖最后由 mig-ling 于 2006-2-1 21:17 编辑 ]

mig-ling

Jack:~ root# /usr/local/mysql/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.18-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>