Article:
  Apache Web-Serving with Mac OS X: Part 1
Subject:   Accessing MySQL in OS X
Date:   2002-09-21 21:17:54
From:   fakeout
Everytime I try to access MySQL in terminal using the command
cd /usr/local/mysql/
sudo ./scripts/mysql_install_db
sudo chown -R mysql /usr/local/mysql
sudo ./bin/safe_mysqld --user=mysql &


I get the following response in Terminal:


Installing all prepared tables
020922 0:10:05 ./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 dsl-216-227-33-233.telocity.com -p password 'new-password'
See the manual for more instructions.


NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!


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


[dsl-216-227-33-233:/usr/local/mysql] danwoote% sudo ./bin/safe_mysqld --user=mysql &


I don't understand. Please help.

Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Accessing MySQL in OS X
    2002-09-25 06:12:50  philocon [View]

    I think I can help you using MySQL. -
    I can't see where exactly the problem is. Let's identify it! -
    1.Just after the installation you cd to /usr/local/mysql/
    2.You type "sudo ./scripts/mysql_install_db"

    STOP!
    Now you see the output you don't understand. It's identical to the output I see on my screen , except for the last line which mustn't be there.[Is it possible that you took the whole instruction for one single command?]
    There is not much to understand: After step 2 you have MySQL's databases installed. And that's it.

    Here is how I connect to mysql:

    mysql -uroot -p<password>

    Good luck!