Hello, I have a problem to start to create database. Can someone please give me some help?
I installed the mysql 4.0 pkg on Mac OS 10.2, then I followed the installation instruction. It works fine. I then tried to create database, but is says"Access denied". I checked "Show database" , there is only one database in, which is 'test'. There suppose to have "mysql" in. I checked the manual, and find I should run "scripts/mysql_install_db" , I runed but then it show me ************************************* [Snow:/usr/local/mysql] richardb% chown: /usr/local/mysql/data/Snow.local..err: Operation not permitted Starting mysqld daemon with databases from /usr/local/mysql/data rm: /tmp/mysql.sock: Operation not permitted 030616 11:24:52 mysqld ended ************************************* UW PICO(tm) 2.5 File: Snow.local..err 030613 10:04:21 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 030613 10:04:21 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030613 10:04:22 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... 030613 10:04:22 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 030613 10:04:23 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.13-debug-debug' socket: '/tmp/mysql.sock' port: 3306 Fatal error: Can't remove the pid file: /usr/local/mysql/data/Snow.local..pid at Fri Jun 13 16:18:56 EDT 2003 Fatal error: Can't remove the pid file: /usr/local/mysql/data/Snow.local..pid at Fri Jun 13 16:20:45 EDT 2003 Fatal error: Can't remove the pid file: /usr/local/mysql/data/Snow.local..pid at Fri Jun 13 16:30:01 EDT 2003 Fatal error: Can't remove the pid file: /usr/local/mysql/data/Snow.local..pid at Mon Jun 16 10:16:09 EDT 2003 Fatal error: Can't remove the pid file: /usr/local/mysql/data/Snow.local..pid at Mon Jun 16 10:25:45 EDT 2003 A mysqld process already exists at Mon Jun 16 11:01:56 EDT 2003 Fatal error: Can't remove the pid file: /usr/local/mysql/data/Snow.local..pid at Mon Jun 16 11:23:41 EDT 2003 030616 11:24:51 mysqld started 030616 11:24:51 Can't start server: Bind on TCP/IP port: Address already in use 030616 11:24:51 Do you already have another mysqld server running on port: 3306 ? 030616 11:24:51 Aborting 030616 11:24:51 /usr/local/mysql/bin/mysqld: Shutdown Complete 030616 11:24:52 mysqld ended 030616 11:44:26 mysqld started 030616 11:44:26 Can't start server: Bind on TCP/IP port: Address already in use 030616 11:44:26 Do you already have another mysqld server running on port: 3306 ? 030616 11:44:26 Aborting 030616 11:44:26 /usr/local/mysql/bin/mysqld: Shutdown Complete **************************************** What is mean Bind on TCP/IP port: Address already in use? thanks Julia --------------------------------------------- This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]