Watch out here I come again ;)
yu_music at hotmail.com
Thu Dec 20 23:25:34 PST 2001
Thnx a lot for your help guys. I got it working. I had no clue what was
wrong but i emptied the table and plug in the same info and it worked. Go
figure. Once again thnx a lot guys.
>From: "B. Koeller" <bkoeller at u.washington.edu>
>Reply-To: linux at u.washington.edu
>To: UW Linux Group <linux at u.washington.edu>
>Subject: Re: Watch out here I come again ;)
>Date: Thu, 20 Dec 2001 22:28:48 -0800 (PST)
>|Warning: Host 'boca02.u.washington.edu' is not allowed to connect to this
>|MySQL server in /nfs/guido06/dw01/d82/dejann/install/newtables.php on line
>|Warning: MySQL Connection Failed: Host 'boca02.u.washington.edu' is not
>|allowed to connect to this MySQL server in
>|/nfs/guido06/dw01/d82/dejann/install/newtables.php on line 2
>This is indeed most likely an issue with the permission tables in mysql.
>boca## or veron## are the actual web servers (I think) that are making the
>query to the msyql database running on ovid or vergil. I usually make a
>couple of user accounts like admin and user and set their hostnames to be
>veron%.u.washington.edu (or boca%) and grant them privileges accordingly.
>Good luck! Thanks.
>brandon at koellers.org
>On Thu, 20 Dec 2001, Dejan Nikic wrote:
>|Who else but my buddy Trevor :) Thnx a lot for all the help last time.
>|Ok now I got rid of the previous problem, but now I have another one.
>|I get this error:
>|so what I did is i went and did this in mysql db:
>|GRANT ALL PRIVILEGES on *.* to username@*.u.washington.edu;
>|I know that this is insecure, but I was intending on keeping it like this
>|just till i found a problem. But even after this I'm still getting the
>|error even apparently user username has access to any db from any host at
>|>From: Trevor Leffler <tleffler at u.washington.edu>
>|>Reply-To: linux at u.washington.edu
>|>To: UW Linux Group <linux at u.washington.edu>
>|>Subject: Re: Watch out here I come again ;)
>|>Date: Thu, 20 Dec 2001 14:56:44 -0800
>|> You're .my.cnf doesn't really matter in this case, because your php
>|>script can't even see it--the web servers can't see your home directory.
>|> Your script should make a connection to your DB via tcp, not a file
>|>socket. You might write something analogous to:
>|>$dbh = DBI->connect("DBI:mysql:$table:$host:$port", $user, $password);
>|> Sorry I don't know how PHP would do that.
>|>Dejan Nikic wrote:
>|>>Well guys here i'm again with my PHP and MySQL installations. Now here
>|>>is the deal. I deleted my previous installations and decided to go
>|>>fresh. Now what I have problems with is that when i try to connect to
>|>>mysql trough php i get this error:
>|>>Warning: Can't connect to local MySQL server through socket
>|>>'/tmp/mysql.sock' (2) in
>|>>/nfs/guido06/dw01/d82/dejann/install/newtables.php on line 2
>|>>now I have no idea why is trying to use /tmp/mysql.sock because in
>|>>.my.cnf i put in a full path to my mysql.sock which is in the root of my
>|>>is there a way to change this /tmp/mysql.sock to a working socket inside
>|>>php? I made a file with phpinfo() in it and there it tells me that
>|>>mysql socket is /tmp/mysql so I would like to have it changed.
>|>>Sorry I'm bothering you guys with all this, but I've been trying to find
>|>>something on this since 3 last night and nothing yet. All help is
>|>>Join the world's largest e-mail service with MSN Hotmail.
>|webmaster at peoplehangout.com
>|Join the worlds largest e-mail service with MSN Hotmail.
webmaster at peoplehangout.com
Join the worlds largest e-mail service with MSN Hotmail.
More information about the Linux