Re: New Problem with LAMP (CORRECTION)
Correction!
Look for the line socket in the [mysqld] section!
EG
Hi!
Check your my.cnf file for the line :
socket = path to sock
Then change the path to /tmp/mysql.sock or create a symbolic link
/tmp/mysql.sock to the path that was inthere.
Restart mysql and that should get you going.
EG
- Original Message -
From: Dennis Peyerl [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 12:30 PM
Subject: New Problem with LAMP
Hi there
The database is now running, i've created my tables and put the data
inside. This is fine.
Next step is to create a PHP-Website which communicates with the
database, but i am not able to connect over my apache (this is what it
seems to me).
to log into the database I use
mysql -p dkv
(password is ppp
user is dcp)
anything is ok.
my php-script looks like this:
?php
$host = localhost;
$user = dcp;
$pass = ppp;
$conex = mysql_connect($host, $user, $pass);
if($conex)
{
echo Connection established.br\n;
mysql_close();
}
else
{
echo No Connectionbr;
echo mysql_errno() . : . mysql_error . br;
}
?
If I put this into a file on the server and access it with my browser,
I get this error:
Warning: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) in /eshop/apache/share/htdocs/sql/ connect.php on
line 5
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)
in /eshop/apache/ share/htdocs/sql/connect.php on line 5
No Connection
2002:mysql_error
What am I doing wrong? Could it be, that i don't have the necessary
modules loaded into my apache? I am new to this, please be kind with me
:-
Thanks in advance
dcp
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Problem with LAMP (CORRECTION)
Thank you very much it workes now. Could you tell me, how come, that the search-path points to /tmp/mysql.sock? I've just created a link, but isn't it possibly to change the apache of trying to connect to /tmp/mysql.sock? thnax dcp Me wrote: Correction! Look for the line socket in the [mysqld] section! EG Hi! Check your my.cnf file for the line : socket = path to sock Then change the path to /tmp/mysql.sock or create a symbolic link /tmp/mysql.sock to the path that was inthere. Restart mysql and that should get you going. EG - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Problem with LAMP (CORRECTION)
Hi! I'm not very used to php but its in php.ini : mysql.default_socket EG - Original Message - From: Dennis Peyerl [EMAIL PROTECTED] To: Me [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 1:00 PM Subject: Re: New Problem with LAMP (CORRECTION) Thank you very much it workes now. Could you tell me, how come, that the search-path points to /tmp/mysql.sock? I've just created a link, but isn't it possibly to change the apache of trying to connect to /tmp/mysql.sock? thnax dcp Me wrote: Correction! Look for the line socket in the [mysqld] section! EG Hi! Check your my.cnf file for the line : socket = path to sock Then change the path to /tmp/mysql.sock or create a symbolic link /tmp/mysql.sock to the path that was inthere. Restart mysql and that should get you going. EG - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
