I've run all of the installation procedures and database initialization steps in entropy.ch and still get a number of errors such as no access to the /data directory in order to view the error log.
I get this error on attempting to initialize the database: Kevins-Computer:/usr/local/mysql kevinbarry$ sudo ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./bin/mysqld: ERROR: unknown variable 'innodb_buffer_pool_size = 70M' Installation of grant tables failed! This is the error I get when attempting to change the owner of /tmp Kevins-Computer:~ kevinbarry$ cd /tmp Kevins-Computer:/tmp kevinbarry$ ls -l total 16 drwx------ 3 kevinbar wheel 102 25 Jan 16:44 501 -rw-r--r-- 1 kevinbar wheel 818 25 Jan 16:36 VPC_DI_log.txt -rw-r--r-- 1 root wheel 656 25 Jan 16:17 mcx_compositor srwxrw-rw- 1 root wheel 0 25 Jan 16:18 slp_ipc Kevins-Computer:/tmp kevinbarry$ cd /usr/local/mysql/data -bash: cd: /usr/local/mysql/data: Permission denied Kevins-Computer:/tmp kevinbarry$ sudo chown -R mysql tmp/ chown: tmp/: No such file or directory Kevins-Computer:/tmp kevinbarry$ sudo chown -R mysql /tmp Kevins-Computer:/tmp kevinbarry$ ls -l total 16 drwx------ 3 kevinbar wheel 102 25 Jan 16:44 501 -rw-r--r-- 1 kevinbar wheel 818 25 Jan 16:36 VPC_DI_log.txt -rw-r--r-- 1 root wheel 656 25 Jan 16:17 mcx_compositor srwxrw-rw- 1 root wheel 0 25 Jan 16:18 slp_ipc drwxr-xr-x 61 root wheel 2074 20 Dec 20:40 sbin lrwxr-xr-x 1 root admin 11 12 Dec 18:51 tmp -> private/tmp drwxr-xr-x 11 root wheel 374 12 Sep 16:42 usr What is the meaning of the "private/tmp" on the directory listing above. The errror below are given when I attempt to change to the /data directory to check the logs: drwxr-x--- 4 mysql wheel 136 25 Jan 20:34 data drwxr-xr-x 7 root wheel 238 25 Jan 13:39 docs drwxr-xr-x 51 root wheel 1734 25 Jan 13:39 include drwxr-xr-x 9 root wheel 306 25 Jan 13:39 lib drwxr-xr-x 3 root wheel 102 25 Jan 13:39 man drwxr-xr-x 9 root wheel 306 25 Jan 13:39 mysql-test drwxr-xr-x 3 root wheel 102 25 Jan 13:39 scripts drwxr-xr-x 3 root wheel 102 25 Jan 13:39 share drwxr-xr-x 31 root wheel 1054 25 Jan 13:39 sql-bench drwxr-xr-x 12 root wheel 408 25 Jan 13:39 support-files drwxr-xr-x 21 root wheel 714 25 Jan 13:39 tests Kevins-Computer:/usr/local/mysql kevinbarry$ cd data -bash: cd: data: Permission denied Kevins-Computer:/usr/local/mysql kevinbarry$ cd /data -bash: cd: /data: No such file or directory -----Original Message----- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 4:45 PM To: Kev Cc: [EMAIL PROTECTED] Subject: Re: Initial running of MySql on OS X 10.3 Kev wrote: > I installed mysql on my Mac Powerbook 10.3 and cannot access the server even > though it seems to be running. I get the socket error as seen below. I used > the disk img package from the mysql website. > > Kevins-Computer:~ kevinbarry$ sudo /Library/StartupItems/MySql/MySql start > > Password: > > Starting MySQL database server > > Kevins-Computer:~ kevinbarry$ /usr/local/mysql/bin/mysql > > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > Kevins-Computer:~ kevinbarry$ ps auxw | grep mysqld > > kevinbar 497 0.0 0.0 18644 96 std R+ 1:44PM 0:00.01 grep > mysqld > That only shows your `grep mysql`, which implies the server isn't running. If the server were running, you should see another line for mysqld. > Could part of the problem be that the id for the running server is not mysql > and how do I change it to mysql? Look in /usr/local/mysql/data/ for the log file hostname.err (replace 'hostname' with the name of your mac) to see why mysqld didn't start. My first guess would be a permissions problem with either /tmp or /usr/local/mysql/data. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]