Kev wrote:
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!
Don't run ./bin/mysqld. Instead, run
sudo -v sudo bin/mysqld_safe &
but wait till after you've fixed /tmp (see below).
This is the error I get when attempting to change the owner of /tmp
You don't want to do that! You just want to give mysql (and any other user) write permission. Do this:
cd /tmp sudo chmod 1777 .
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
The user kevinbarry (you) doesn't have permission to enter mysql's data directory.
Kevins-Computer:/tmp kevinbarry$ sudo chown -R mysql tmp/ chown: tmp/: No such file or directory
As I said, you really don't want to change the ownership of /tmp. Fortunately, you failed due to a typo. /tmp is the tmp directory under the root directory (/). tmp/ (or just tmp) is the directory named tmp in your current working directory. Effectively, you tried to chown /tmp/tmp, which, fortunately, doesn't exist.
Kevins-Computer:/tmp kevinbarry$ sudo chown -R mysql /tmp
Ah. Here you succeeded. You need to fix this.
sudo chown root:wheel /tmp
Kevins-Computer:/tmp kevinbarry$ ls -l total 16
You need `ls -al` to see the current directory (.) listed.
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
I hope this is two different listings. The files above should be in /tmp, but the rest (those below) should be in /
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.
Mac OS X has a /private directory where it keeps what usually goes in /etc, /tmp, and /var. There are symbolic links (like Mac aliases) in the root directory to keep things working. So
/etc -> /private/etc /tmp -> /private/tmp /var -> /private/var
where "->" means "points to". When you `cd /tmp`, you really end up in /private/tmp.
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
Apparently, user kevinbarry is not a member of the wheel group. Try the command
groups
to see a list of the groups to which you belong. In any case, permissions look OK here.
Kevins-Computer:/usr/local/mysql kevinbarry$ cd /data -bash: cd: /data: No such file or directory
Right. /data would be a subdirectory of the root directory (/). It most likely doesn't exist.
To sum up, you need to fix /tmp then launch mysqld. So, in order, you need to:
cd /tmp sudo chown root:wheel . sudo chmod 1777 . cd /usr/local/mysql sudo bin/mysqld_safe &
Then you should continue with the instructions to set the root password using mysqladmin.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]