Women in Technology

Article:		Apache Web-Serving With Mac OS X, Part 5
Subject:		Permission Denied
Date:		2002-06-11 01:23:10
From:		macette
Am probable loser, but nonetheless... After installing MySQL 3.23.49, I enter this jazz in Terminal, as suggested: cd /usr/local/mysql/ sudo ./scripts/mysql_install_db sudo chown -R mysql /usr/local/mysql sudo ./bin/safe_mysqld --user=mysql & but rather than getting " Starting mysqld daemon with databases from /usr/local/var" or words to that effect, I get: "To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h localhost -p password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com" So I follow the instruction to "start the MySQLDaemon by entering cd . ; ./bin/safe_mysqld & " and then I get: "[localhost:/usr/local/mysql] virginia% touch: /usr/local/mysql/data/localhost.err: Permission denied chown: /usr/local/mysql/data/localhost.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: permission denied: /usr/local/mysql/data/localhost.err [229] ./bin/safe_mysqld: permission denied: /usr/local/mysql/data/localhost.err [235] tee: /usr/local/mysql/data/localhost.err: Permission denied 020611 18:11:51 mysqld ended tee: /usr/local/mysql/data/localhost.err: Permission denied" What now?? I'd be most grateful for some help here... this is my first time in Terminal, and I'm floundering thinking of ways to help myself. Virginia (virg@alphalink.com.au)

Showing messages 1 through 4 of 4.

• allmost same problem
  2002-06-23 09:19:18  bluesy [View]
  
  
  I got all of the other server stuff running from these good articels, unfortunally this one is teasing me :-(
  
  I cant get passed the chown command, i used the packed version to install mysql nd not the source, but it just goes wrong :-(
  
  [localhost:/usr/local/mysql] bluesy% sudo ./scripts/mysql_install_db
  Password:
  Preparing db table
  Preparing host table
  Preparing user table
  Preparing func table
  Preparing tables_priv table
  Preparing columns_priv table
  Installing all prepared tables
  ERROR: 1062 Duplicate entry 'localhost-root' for key 1
  ERROR: 1062 Duplicate entry 'localhost-root' for key 1
  020623 17:41:33 ./bin/mysqld: Shutdown Complete
  
  
  To start mysqld at boot time you have to copy support-files/mysql.server
  to the right place for your system
  
  PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  This is done with:
  ./bin/mysqladmin -u root -p password 'new-password'
  ./bin/mysqladmin -u root -h localhost -p password 'new-password'
  See the manual for more instructions.
  
  You can start the MySQL daemon with:
  cd . ; ./bin/safe_mysqld &
  
  You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
  cd sql-bench ; run-all-tests
  
  Please report any problems with the ./bin/mysqlbug script!
  
  The latest information about MySQL is available on the web at
  http://www.mysql.com
  Support MySQL by buying support/licenses at https://order.mysql.com
  [localhost:/usr/local/mysql] bluesy% sudo chown -R mysql /usr/local/mysql
  chown: mysql: invalid user name
  [localhost:/usr/local/mysql] bluesy% sudo ./bin/safe_mysqlid --user=mysql &
  [1] 461
  [localhost:/usr/local/mysql] bluesy% sudo: ./bin/safe_mysqlid: command not found
• allmost same problem
  2002-08-21 19:17:51  hembeck [View]
  
  
  Does anyone know what is causing this error and how to correct the problem? I've followed the steps out lined here VERY CAREFULLY as well as Marc Marc Liyanage's instructions which accompany his installer .pkg.
  
  I've removed the installation several times and have deleted and created the MySQL User several times as well, but I keep getting this error, which just craps out everything.
  
  Please advise. I've spent three days on this thing and have read documentation from all over the place. I lost and very tired of this.
  
  Thanks,
  Fernando
• allmost same problem
  2002-11-22 14:02:40  cesareborgia [View]
  
  
  
  hi there - i had the same frustration for two days but solved the problem by updating the developer's tools on my mac os 10.2 computer completely - you need to install the August 2002 update especially. Then I compiled the source for mysql and followed the instructions at Apple's Developer site on MySQL installation.
• allmost same problem
  2002-06-25 06:16:02  bluesy [View]
  
  
  i got my prob solved http://www.entropy.ch/software/macosx/mysql/ there is allso a way to uninstall mysql i used.
  
  Dennis