[HOWTO] - Setup PHP & MySQL

[laron8]

This is what I am getting when trying to do mysql
Welcome to Darwin!
[localhost:~] nate% cd /usr/local/mysql
[localhost:/usr/local/mysql] nate% 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
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
[localhost:/usr/local/mysql] nate%

[metropol]

I followed your instructions and as soon as I enter the "sudo apachectl graceful" command I get the following response in Terminal:

/usr/sbin/apachectl graceful: httpd not running, trying to start
Syntax error on line 240 of /etc/httpd/httpd.conf:
API module structure `php4_module' in file /usr/libexec/httpd/libphp4.so is garbled - perhaps this is not an Apache module DSO?
/usr/sbin/apachectl graceful: httpd could not be started

I've downloaded the module and installed it a few times. Any suggestions?

metropol

[lcwid]

I ran into a little trouble. I had trouble starting MySQL. I thought it maybe something I screwed up while poking around. So I downloaded it again, installed and took the steps. I also installed the automatic start. However I went to "/usr/local" and found two different versions. I downloaded the newer one, 3.23.49. I tried to delete the 3.23.47 but it would not let me. This is the reply"rmdir: mysql-3.23.47: Directory not empty" I'm new to the command line. What should I do?

[yoshi]

sudo rm -r filename

[paradoxchild]

I got these installations to work without a hitch and "mysql test" worked fine that first time. However, I have restarted my computer and now I get this error message when I try to test or use mysql in any way:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I don't have a clue what might of happened. Any help would be appreciated.

Thanks!

[yoshi]

Okay buddy, here is whats up, MySQL by default doesn't startup at startup time so after you restart your MacOSX machine you need to enter a few command in the terminal to startup MySQL. The steps you need to follow are under this paragraph. Do them every time your restart!

Step 1) Start Terminal and type cd /usr/local/mysql

Step 2) type "sudo ./bin/safe_mysqld --user=mysql &

Step 3) Enter your Password

and thats it, you can close the terminal and mysql should be started.

Hope this helps
*Note*
The link for the package no longer works and I am putting up a mirror on my own server for you guys to download it at okay.
*/NOTE*

[laron8]

Or just download this package and it will load mysql on startup.
http://www2.entropy.ch/download/mysq...tem.pkg.tar.gz

[d-mac-d]

I cannot seem to download the MySQL package. I get this:


Not Found
The requested URL /download/mysql-3.23.47.pkg.tar.gz was not found on this server.


Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
------------------------------------------------------------------------
Apache/1.3.22 Server at www.www2.entropy.ch Port 80