Re: [Phpwebsite-developers] remote mysql connections

[Jeremy A. <ja...@tu...>]

There are still a loot i don't know about your setup but hope this helps.

Do you have a firewall or hosts.allow/deny in place? --probable not this
since you get a connection.

Can you do local query's on the sql server?

Do you have the port(3306) defined in the my.cnf file(both servers)
--Usually in /etc, The mysql.sock is for local stuff.

Do you have the mysql info in you services file.  --Usually in /etc/services

Do you have the host(webserver) defined in the mysql user you are using? 
phpMyAdmin has a verry nice "user" admin on the opening page.

This probable isn't it but remember when working on user info in mysql you
need to reload the server.  phpMyAdmin has a link to do this at the bottom
when doing user edits.

> I have a desire (for cpu reasons) to have phpwebsite(s) on one box and
> the  MySql server running locally on another box -
>
> I have it setup and what I believe are the necessary permissions for the
>  remote box to connect to the MySql box- but when it does, mysql remits
> this  error:
> mysql> /usr/bin/safe_mysqld: line 278:  4715 Segmentation fault
> $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
> --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking
>>>$err_log 2>&1
>
> Number of processes running now: 1
> mysqld process hanging, pid 4725 - killed
> 030205 20:32:21  mysqld restarted
>
> THe script, db_look.php, reports back this:
>
> X-Powered-By: PHP/4.1.2
> Content-type: text/html
>
> <pre>mysqldump: Got error: 2013: Lost connection to MySQL server during
> query  when trying to connect
>
> Any idea?
>
> I have looked all over for info on this and can not find it.
>
> TIA,
>
> --
>  Robert Brandtjen
>  ------------------------------------
> Web Site Creation and Hosting Services
>  Hos...@pr...
>       www.prometheusmedia.com
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld
> http://www.vasoftware.com
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers


-- 
Jeremy Agee
phpWebSite Development Team (http://phpwebsite.appstate.edu)
Appalachian State University
SF.net id: jagee or 94756