[Nep2ne]

Hi Everyone,

I'm hoping there might be someone able to help me with this dilemma. I've posted in a previous forum, but have received no responses.

I've got OS X 10.2 Server on a B&W/450. I know that it comes with a version of MySQL, but I wanted to try compiling and installing the binaries, so I've rm-ed the previous MySQL folder (which, by the way, was not placed in usr/local but instead in usr/shared --??). I've followed the instructions as per http://developer.apple.com/internet/macosx/osdb.html and at this point I've installed everything but the configuration file, and once I try to ./configure the information, this is what I get:

Sorry, the host 'GrotzHost' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

I'm not sure what to do next. When I do a ./install_test_db from within the /usr/local/mysql/mysql-test/ director, I get the following:

mysqld is missing - looked in ../sql

If anyone is available to help or point me in the right direction, I am on via iChat -- my "handle" is tulsadrone. I am on pretty much all the time. I'd really appreciate it! Thanks very much.

What I'm trying to do, ultimately, is get movabletype to work on this box via static IP. Hopefully, I'll get there!


Erik

[Nep2ne]

Okay, I've found the solution to my localhost dilemma, but now I cannot get mysqld to install. Might be a permission problem:

<quote>

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
mkdir: ./data/test: Permission denied
chmod: ./data/test: Permission denied
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: Can't change dir to '/usr/local/mysql/./data/' (Errcode: 13)
030126 12:57:48 Aborting

</quote>

...anyone know my solution here? Thanks in advance!

Erik
AIM: tulsadrone

[MacMonster]

First of all, add a user called "mysql" in the Users preferences panel.

In the terminal, login as mysql:

% login mysql

Then, goto the mysql root directory:

% cd /usr/local/mysql

Chnage the owner of the data folder to the user, mysql:

% chown -R mysql.staff data

Execute the shell script:

% ./scripts/mysql_install_db

Run the mysql server:

% ./bin/safe_mysqld &

Start mysql client:

% ./bin/mysql

Please note that different version and distribution of mysql may have different installation method.

[Nep2ne]

I'd already added and deleted the user several times. I did manage to get MySQL working late last night.

Stupid me, but it turns out that in printing the entropy.ch pages out at 80% I couldn't even see the commands correctly. I mistyped "mysqld" for "mysql" in one line, and that's what did it.

Thanks!
('')