I think that my file permissions are set OK. Heres a list of my MySQL
folder...
total 1652
drwx------ 6 mysql 27 4096 Mar 1 11:37 .
drwxr-xr-x 20 root root 4096 Feb 15 16:26 ..
-rw------- 1 mysql 27 244 Feb 26 16:56 .bash_history
drwx------ 2 mysql root 4096 Feb 26 15:48 .xauth
drwx------ 2 mysql mysql 4096 Feb 28 16:32 BEN
-rw-r--r-- 1 mysql mysql 1 Mar 1 10:28
chiefwigham.fubra.err
-rw-r--r-- 1 mysql mysql 8628 Feb 26 15:07
chiefwigham.fubra.err.old
-rw-rw---- 1 mysql mysql 3 Mar 1 10:06
chiefwigham.fubra.pid
-rw-rw---- 1 mysql mysql 322 Feb 26 14:15 chiefwigham.log
-rw------- 1 mysql mysql 0 Feb 26 16:12 columns_priv.MYD
-rw------- 1 mysql mysql 1024 Feb 26 16:12 columns_priv.MYI
-rw------- 1 mysql mysql 8778 Feb 26 16:12 columns_priv.frm
-rw------- 1 mysql mysql 302 Feb 26 16:12 db.MYD
-rw------- 1 mysql mysql 3072 Feb 26 16:12 db.MYI
-rw------- 1 mysql mysql 8982 Feb 26 16:12 db.frm
-rw------- 1 mysql mysql 0 Feb 26 16:12 func.MYD
-rw------- 1 mysql mysql 1024 Feb 26 16:12 func.MYI
-rw------- 1 mysql mysql 8641 Feb 26 16:12 func.frm
-rw------- 1 mysql mysql 0 Feb 26 16:12 host.MYD
-rw------- 1 mysql mysql 1024 Feb 26 16:12 host.MYI
-rw------- 1 mysql mysql 8958 Feb 26 16:12 host.frm
-rw-r--r-- 1 root root 0 Mar 1 11:37 list.txt
drwx------ 2 mysql mysql 4096 Feb 28 14:26 mysql
srwxrwxrwx 1 mysql mysql 0 Mar 1 10:06 mysql.sock
-rwxr-xr-x 1 mysql mysql 1524536 Feb 19 13:56 mysqld
-rw------- 1 mysql mysql 0 Feb 26 16:12 tables_priv.MYD
-rw------- 1 mysql mysql 1024 Feb 26 16:12 tables_priv.MYI
-rw------- 1 mysql mysql 8877 Feb 26 16:12 tables_priv.frm
drwx------ 2 mysql mysql 4096 Feb 28 16:13 test
-rw------- 1 mysql mysql 428 Feb 26 16:12 user.MYD
-rw------- 1 mysql mysql 2048 Feb 26 16:12 user.MYI
-rw------- 1 mysql mysql 9148 Feb 26 16:12 user.frm
Thanks
Ben K
Ireneusz Piasecki wrote:
>
> ----- Original Message -----
> From: "Ben Kennish" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 01, 2001 11:55 AM
> Subject: PHP and MySQL
>
> > Who would've thought it would take 3 days to install MySQL, PHP and get
> > them talking???!!
> >
> > I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
> >
> > I've also installed MySQL (latest ver) server and client versions from
> > www.mysql.com using RPMs.
> >
> > Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
> > gives me no trouble) and PHP seems to work fine <?php phpinfo(); ?>.
> >
> > I've installed the PHP-MySQL module from redhat.com (a single file -
> > mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
> >
> > But when I type ...
> >
> > mysql_connect('localhost', 'root', 'b');
>
> This can be that: mysql_connect('serwer_name','root','b' ); where
> serwer_name is serwer, that serve mysql databases
> or you can chmod file mysql.sock than other can it write (it could help)
>
> > into a PHP file, (I set b as my root SQL pwd) I get the following
> > error...
> >
> > "Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > through socket '/var/lib/mysql/mysql.sock' (111) in
> > /var/www/html/index.php on line 5"
> >
> > There seems to be nothing in the MySQL error log.
> >
> > Please help! Thanks,
> >
> > --
> > Ben Kennish
> >
> > Software Developer
> > Fubra Limited
> >
> > web | www.fubra.net
> > email | [EMAIL PROTECTED]
> > phone | +44 (0)870 1222 600
> > fax | +44 (0)870 1222 699
> >
> > ---------------------------------------------------------------------
> > 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
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
---------------------------------------------------------------------
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