Women in Technology

Hear us Roar



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)

Full Threads Oldest First

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