I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up.
In the console I get these messages:


The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok
creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok


 Success. You can now start the database server using:

/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data
or
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start


LOG: database system was shut down at 2005-01-19 12:36:29 PST
LOG: checkpoint record is at 0/71524
LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 1744; next oid: 16766
LOG: database system is ready
ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON "pg_shadow" FROM PUBLIC'.



MySQL seems to be running:

649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data


When I run MySQLManager, I get this error message:

2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option.
ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????????????????????????????????????????????????????????????????????' at line 1
050119 12:37:34 Aborting
050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete



When I type "mysql" at the command line, I get:

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

...yet the file exists:

 srwxrwxrwx   1 mysql   wheel    0 19 Jan 12:35 mysql.sock


Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things.


Thanks!
Alex



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to