Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-26 Thread Thomas Spahni

On Wed, 21 Feb 2001, Hagen Hoepfner wrote:

 I can normaly use mysql 
 if I am root. But if i'm logged in as normal user or try to connect to mysql 
 via php i got the following error message:
 
 MySQL Connection Failed: Can't connect to local MySQL server through socket 
 '/var/lib/mysql/mysql.sock' (13) in 
 /usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19
 
 What can I do?

Hagen, 
please read the very fine Manual chapter 4 about the "The MySQL Access
Privilege System". This will solve your problem.

Thomas


-
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: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-26 Thread Florian G. Pflug

On Mon, Feb 26, 2001 at 04:45:50PM +0100, Thomas Spahni wrote:
 On Wed, 21 Feb 2001, Hagen Hoepfner wrote:
 
  I can normaly use mysql 
  if I am root. But if i'm logged in as normal user or try to connect to mysql 
  via php i got the following error message:
  
  MySQL Connection Failed: Can't connect to local MySQL server through socket 
  '/var/lib/mysql/mysql.sock' (13) in 
  /usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19
  
  What can I do?
 
 Hagen, 
 please read the very fine Manual chapter 4 about the "The MySQL Access
 Privilege System". This will solve your problem.

I guess it won't

This look more like mysql-client (or php) not finding the mysqld.sock
socket, or the socket having the wrong unix permissions.

Check for the permissions of the socket, and check if the client look for it
at the same place as the server creates it.

mfg, Florian Pflug

-
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




MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-21 Thread Hagen Hoepfner

Hello,

I use SuSE Linux 7.1 with a 2.4 kernel. I have installed the normal 
SuSE-MySQL packages and creates the default tables. I can normaly use mysql 
if I am root. But if i'm logged in as normal user or try to connect to mysql 
via php i got the following error message:

MySQL Connection Failed: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (13) in 
/usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19

What can I do?

Hagen

-- 
Hagen Hoepfner Uni MD / FIN / ITI / AG DB
-
eMail:   [EMAIL PROTECTED]
Homepage: http://wwwiti.cs.uni-magdeburg.de/~hoepfner

-
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