PHP doesn´t show errors / MySQL User and Host not set

Hi there,

I´m just getting started with Macs and actually I´m a bit desperate trying to get PHP and MySQL working. I´ve already done this on a PC many times without any problems. But on a Mac???

I installed PHP and MySQL like entropy.ch says.

First problem:
Even though I have put ALL error-reporting functions ON in the php.ini, I don´t get any error reports at all. The only thing I get when running a php-file is blank pages, that´s so annoying. PHP seems to be working alright, at least I have no problem running phpinfo.

Second problem:
When I run phpinfo I get the information (in the mysql section) that MySQL didn´t set any user nor host. But I need these to connect to a db. When you install MySQL on a PC these things (User, Host) are set automatically.

I have really tried hard: installed everything again twice, done all the installation-manuals available on the web...

If it is any help to you: I have checked with NetInfoManager that there is an mysql user. I don´t know ANY Unix, but I´m following the installation guides. I understood that I´m supposed to change the password for the mysql user. If I try, I get this:

[MIS-Computer:/usr/local/mysql] inti% sudo chown -R mysql:mysql data
[MIS-Computer:/usr/local/mysql] inti% sudo ./bin/safe_mysqld --user-mysql &
[1] 613
[MIS-Computer:/usr/local/mysql] inti% Starting mysqld daemon with databases from /usr/local/mysql/data
030806 11:52:29 mysqld ended

/usr/local/mysql/bin/mysqladmin -u root password XXXX
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[1] + Done sudo ./bin/safe_mysqld --user-mysql
[Maria-Inti-Metzendorfs-Computer:/usr/local/mysql] inti%

Hope anybody has any hints for me!

Check out mysql.com for complete info on how to set up privileges. Out of the box, I believe mysql can usually be accessed as root with no password. Of course you'll want to set up a web user with a password and limited permissions. Info on how to do all of this is available at mysql.com.

If phpinfo runs fine but you're getting blank pages on other code, I'm guessing it's a code issue. We'd have to know what these blank pages are supposed to do in order to provide any meaningful feedback.

Thank you for replying.

I really don´t think it´s a code issue, because all I want are the error reportings. If I write something like this on a PC

<?
echo "Hallo!"
?>

I would normaly get something like
"; missing in your syntax"

But here I get nothing. Just blank pages. As soon as something in the code is wrong, he gulps down everything. This way I can´t figure out if I´ve got a PHP or a MySQL problem, because alle error reportings are omitted (even though I changed php.ini to ON!)

I solved the PHP problem by installing it all over again... Unfortunately this didn´t work with MySQL. I keep getting this error:

[127:/usr/local/mysql] inti% sudo echo

[127:/usr/local/mysql] inti% sudo ./bin/mysqld_safe &
[1] 1311
[127:/usr/local/mysql] inti% Starting mysqld daemon with databases from /usr/local/mysql/data
030806 17:26:27 mysqld ended

/usr/local/mysql/bin/mysql test
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[1] + Done sudo ./bin/mysqld_safe
[127:/usr/local/mysql] inti%

What am I to do now?

(I´ve already used the CLEANUP Script from entropy.ch and started all over again...)

I'm getting the exact same problem with mac os 10.2.5

try to start mysql, gives this response:

Starting mysqld daemon with databases from /usr/local/mysql/data
030901 05:02:15 mysqld ended

I'm very new to this and I don't have a clue what I'm doing wrong.

ok, i figured it out.

Open a terminal window and type in the following commands (without the double quotes):

type

cd /usr/local/mysql

type

sudo chown -R mysql data/

enter your Mac OS X account password when asked for it.

To start the server, issue (type)

sudo echo

first, then type

sudo ./bin/mysqld_safe &

Use it with

/usr/local/mysql/bin/mysql test

If you do not want to have to type

/usr/local/mysql/bin

in front of every command, you have to add the

/usr/local/mysql/bin

directory to your PATH environment variable in your login script. For the default tcsh shell, you can do this by running this command once:

echo 'setenv PATH /usr/local/mysql/bin:$PATH' >> ~/.tcshrc


I got this off from:

URL

hope this works for you.

hey there,

im having the same problem with php, there is an error in my script somewhere and I cant debug it because all php gives me is a blank screen! how do i fix this, as it is really annoying! phpinfo() is executed ok, as are any normal php pages, but just not any that have an error, it stops output of errored pages! how do i fix this?! or how do i re install php? am using mac os x 10.3.7. help!!! please!!!!

You might get better results in a new thread.
in the meantime, try adding an or die(); statement to the end of your mysql_query statements... [all your mysql statements would give you better debugging]... I find this is a common problem, and it should give you a better idea of where the problem lies.

Does PHP not output *at all*... or only on scripts with MySQL connections?