re-send :
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+os&hl=fr&lr=&start=30&sa=N
Mathias
>
>
> Selon Michael Stassen <[EMAIL PROTECTED]>:
>
> > You haven't gi
sorry for trying to help, but if it was my problem, i would have found something
in the second url.
mathias
Selon [EMAIL PROTECTED]:
> This is very old, several years, info you've been passing along.
> Mysql switches are on by default now. Mac OSX (Server for me) is not
> 10.4 Tiger, you've po
[EMAIL PROTECTED] wrote:
Remember guys, I went through this on the phpmyadmin list before
turning here.
That doesn't help us much, as we haven't seen that conversation.
I was told to run the command 'mysqladmin variables' to find out where
the socket was; I did that successfully and it sho
This is very old, several years, info you've been passing along.
Mysql switches are on by default now. Mac OSX (Server for me) is not
10.4 Tiger, you've posted 10.2 Jaguar info, one version prior to 10.3
Panther which was itself released over a 18 months ago.
Thanks anyway. :)
Gil
On M
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+os&hl=fr&lr=&start=30&sa=N
Mathias
Selon Michael Stassen <[EMAIL PROTECTED]>:
> You haven't given us much to go on, ot
Ok, afraid I'm having to ask: how do access the mysql log file? Or,
how to enable logging... I gather this will cause a verbose mode from
the CLI?
Not sure what I should be doing here.
Thanks in advance.
As for the 3 elements listed below --wouldn't those be present in the
mysql db alread
Gil,
THREE elements need to be match what is stored inside MYSQL DB.
1) username
2) password
3) hostname
You need to enable MYSQL logging, restart the DB, & try to login from PHP.
Then, take a look at what MYSQL shows in its logfile & post the results here!
YMMV
On 5/29/05, Peter <[EMAIL PROTEC
Hi,
here is a workaround that might help you.
I guess you have a Network card. So instead of using 'localhost' as host
use your ip e.g '192.168.0.1;. That will force MySQl use TCP/IP instead
of socket.
Just have in mind that:
1. In /etc/my.cnf You should comment "skip-networking" if presene
Remember guys, I went through this on the phpmyadmin list before
turning here.
I was told to run the command 'mysqladmin variables' to find out
where the the socket was; I did that successfully and it showed up
at /var/mysql/mysql.sock.
And viola, now with mysqld running, it does show up
Yes, now-a-days php is enabled by default... well on OSX Server it is
and Mysql support is built-in and turned on.
You do have to start Mysql on OSX Server.
Gil
On May 29, 2005, at 3:35 PM, [EMAIL PROTECTED] wrote:
re-submitted
re-send :
hi,
php has to be configured with mysql suppor
mysql.sock is created by mysqld when it starts, and destroyed when it
stops.
haha. you're absolutely right. that doesn't make any sense. i wasn't
thinking about the nature of socket files when i wrote that.
now that i go back and read the post i was referring to, i think the
poster was ac
re-submitted
re-send :
hi,
php has to be configured with mysql support. see
http://www.whoopis.com/howtos/php-mysql-osx.html
and a general google search :
http://www.google.fr/search?q=mysql+php+mac+os&hl=fr&lr=&start=30&sa=N
Mathias
> >
> >
> > Selon Michael Stassen <[EMAIL PROTEC
Philip George wrote:
one of the posts at the bottom of one of those pages mentions that the
permissions on the sock file might not be right.
mine is:
srwxrwxrwx 1 mysqlwheel0 29 May 06:41 mysql.sock
you probably already know all this, but just in case... to get those
permissions se
mysqld won't start if it can't create the socket, so if mysqld is
running, you've got a socket somewhere. Once you find out where, you
can fix your connection problem by setting the appropriate path in your
php script.
I don't think you need a fresh install.
Michael
[EMAIL PROTECTED] wrote:
On May 29, 2005, at 11:13 AM, [EMAIL PROTECTED] wrote:
I get these:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/mysql/mysql.sock' (13) in
/Library/WebServer/testpad/test.php on line 3
Warning: mysql_select_db(): Can't connect to local MySQL server
th
Ok, thanks all.
I believe I need a fresh installation.
What I do get is why running 'mysqladmin -variables' reports the
location of mysql.sock and there seems to be no mysql.sock anywhere
on this machine! Not in /tmp not /var/mysql (where it says it is).
Gil
On May 29, 2005, at 1:59 PM,
I don't see anything I haven't tried there, i.e., defining the sock
in the connection.
Thanks.
On May 29, 2005, at 1:33 PM, Philip George wrote:
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.h
one of the posts at the bottom of one of those pages mentions that the
permissions on the sock file might not be right.
mine is:
srwxrwxrwx 1 mysqlwheel0 29 May 06:41 mysql.sock
you probably already know all this, but just in case... to get those
permissions set up:
chown
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html
search them both for '2002' (multiple instances on one of the pages).
there a couple suggestions for things to try.
hth.
- philip
--
MySQL Gen
I have the php app Gallery, a php web based based photo gallery
running and that works fine.
mysqld is running and I can login through the CLI and use the db
'mysql' with root or with my superuser, so that's OK. All that seems
to have transfered over from upgrading the OS without a hitch. A
You haven't given us much to go on, other than "it doesn't work," which
isn't really helpful. We can't give you "specific ideas where to look"
until you give us specific details of what's wrong. Please describe
what happens. Do you get an error message? What is it? While you're
at it, show
From your first message below, are you suggesting a setting in
Apache needs to be ticked?
I can do it if I know where to look. I am no expert, just one who
uses tis setup, i.e., "it just works." I have used the previous
version for years and it "just worked." That's why I have no idea
wh
If you follow the instructions properly, you can get the ISAPI version
of PHP to run and it it runs pretty well once installed.
Curtis
Don Stefani wrote:
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev bo
Hi!
Am Mit, 2004-12-29 um 18.09 schrieb [EMAIL PROTECTED]:
> [[...]]
> Of course, the WAMP alternative is always there, Apache is FREE and comes
> with PHP. I have both IIS and Apache set up on my Win2K laptop (I usually
> only run them one at a time to conserve resources), So instead of IIS/AS
I thought you were building a local application, not a web-based app??
I believe you can still use PHP through WSH (instead of IIS) but you will
need to do some research, though. I know that Perl is supported by both
WSH and IIS (I have seen it working before) so I think that PHP and Python
and
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev box, it may not be that big of a deal.
PHP using IIS is a bit easier to install than Apache since PHP5 does not
have an installer that auto-configs Apache,
I am using IIS :(
On Wed, 29 Dec 2004 10:03:11 -0600, Josh Trutwin
<[EMAIL PROTECTED]> wrote:
> On Wed, 29 Dec 2004 10:42:45 -0500
> GH <[EMAIL PROTECTED]> wrote:
>
> > On Windows... Which do i install first? PHP or MySQL?
>
> Apache. :)
>
> It doesn't really matter but I'd suggest MySQL fir
On Wed, 29 Dec 2004 10:42:45 -0500
GH <[EMAIL PROTECTED]> wrote:
> On Windows... Which do i install first? PHP or MySQL?
Apache. :)
It doesn't really matter but I'd suggest MySQL first as I think there
is one file you need to copy from the MySQL installation to the
C:\Windows (or whatever syste
[snip]
On Windows... Which do i install first? PHP or MySQL?
[/snip]
It should not matter as you will have to tell PHP to load the proper
libraries. Install both (in any order) then configure PHP, then start
MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Jay Blanchard wrote:
This is probably a better question for a PHP list.
Do you know of one? ;)
If you're running a rpm based distro (RedHat, Fedora, etc.), and you
have php installed by rpm, you should just need to install the php-mysql
rpm, and restart Apache.
--
John C. Nichel
ÜberGeek
KegWor
[snip]
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some extension
You didn't say which Linux you were using and I am not sure about the rest,
but if you are using RedHat, you probably need to install php-mysql which
is "A module for PHP applications that use MySQL databases." If you can
use up2date, you can type in up2date php-mysql and that will let you run
On Thu, 16 Sep 2004 09:27:08 -0400, "John Nichel" <[EMAIL PROTECTED]>
said:
> nestor(earth) wrote:
> > People,
> >
> > This more of a php mysql question. I have installed PHP ( 5.01) with
> > Apache(1.31) and it runs.
> > I have install Mysql (the latest as of last night) and it runs. My
>
nestor(earth) wrote:
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation 4 or 5 times but th elast t
MAIL PROTECTED]
Sent: Wednesday, September 15, 2004 11:10 AM
To: nestor(earth)
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
<[EMAIL PROTECTED]> wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and
CTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
<[EMAIL PROTECTED]> wrote:
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
&g
From: andy thomas [mailto:[EMAIL PROTECTED]
> Sent: 15 September 2004 16:22
> To: Greg Donald
> Cc: [EMAIL PROTECTED]
> Subject: Re: Mysql and PHP
>
> On Wed, 15 Sep 2004, Greg Donald wrote:
>
> > On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]>
16:22
To: Greg Donald
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004, Greg Donald wrote:
> On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]>
wrote:
> > Did you build both php and apache with MySQL support?
>
> I wasn't aware y
You have to rebuild PHP against the new MySQL libraries.
Curtis
Greg Donald said:
> On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
> <[EMAIL PROTECTED]> wrote:
>> This more of a php mysql question. I have installed PHP ( 5.01) with
>> Apache(1.31) and it runs.
>> I have install Mysql (the l
On Wed, 15 Sep 2004, Greg Donald wrote:
> On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote:
> > Did you build both php and apache with MySQL support?
>
> I wasn't aware you could build Apache with MySQL support. How is that done?
Apologies - I should have said just
2004 11:03 AM
To: nestor(earth)
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004, nestor(earth) wrote:
> People,
>
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last
> People,
>
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
> problem is that PHP does not see
> Mysql. Now I have done this installation 4 or 5 times but th elast time
> was
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote:
> Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL support. How is that done?
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
<[EMAIL PROTECTED]> wrote:
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
> problem is that PHP does not see
> Mysql. Now I
On Wed, 15 Sep 2004, nestor(earth) wrote:
> People,
>
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
> problem is that PHP does not see
> Mysql. Now I have done this instal
OS is W2K.
-Original Message-
From: "nestor(earth)" <[EMAIL PROTECTED]>
Sent: Sep 15, 2004 8:04 AM
To:
Cc: [EMAIL PROTECTED]
Subject: Mysql and PHP
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest
Pvt ) Ltd
To: Eve Atley
Sent: Tuesday, February 24, 2004 2:15 AM
Subject: Re: MySql and php
thanx alot for ur reply , i think better to send my script to u .In third
collom , there is two different status . I want to highlight those with two
different colors.There is to be satisfied some simple co
There are some excellent tutorials for PHP at www.codewalkers.com under the
tutorials/basics section. You can sort the fields with SQL or with PHP (see
"Sorting Database Results with PHP") and in the Display section of the
tutorials are "Alternating row colors with PHP and MySQL" and "Multicolumn
Hello Guys (gals?) and the list,
Thank you very much for the tips. Your help put me on the correct path,
and I was able to install the products you suggested, and it seems
that my "dummy" database demo is now working. Thank you for the help.
I am a "smarter" newbie now!
eric
[EMAIL PROTE
Yes, you can download the package or install from RH CD:
php-mysql
http://rpmfind.net/linux/rpm2html/search.php?query=php_mysql&submit=Search+...&system=&arch=
This is required so PHP will have support for mysql functions. You
apache should be ok without changes.
Sincerely,
Szymon Machaj
You need to install the client side of mysql on the linux box (libmysql.*)
then compile php with the mysql modules (I think they exist in RPMs)
P
-"Eric W. Holzapfel" <[EMAIL PROTECTED]> wrote: -
To: [EMAIL PROTECTED]
From: "Eric W. Holzapfel" <[EMAIL PROTECTED]>
Date: 02/10/2004 02:55
Hi Caspar
Also try phpbuilder.com, and zend.com. Alternatively, try googling PHP
tutorials.
Regards
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand binary and those who don't" (Unknown)
- Original Message
Goto www.devshed.com some nice resources there, from introductions to
advance topics.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Casper Matthee [mailto:[EMAIL PROTECTED]
-->Sent: Th
"MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, December 18, 2002 1:32 AM
Subject: Re: MySQL and PHP question
> On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote:
> >while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
> >$num1 = $line['number
On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote:
>while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
>$num1 = $line['number'];
>}
Loop through the result and return the value from the last row?
Did you want "select sum(number) as SubTotal1 from table1 where
userid=$user1
ge -
From: "Steve Yates" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 5:12 PM
Subject: Re: MySQL and PHP question
> On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote:
>
> >I can not use two mysql queries
I can...
Hard to know why without more info but a starting point would be to turn on
the query log in MySQL and see what queries it is receiving.
_
Fraser Stuart
Logistics IT
77-85Phone: +61 2 9335 1235
Roberts Rd
On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote:
>I can not use two mysql queries in the same PHP file
Please post code snippets, this is possible.
- Steve Yates
- Burger Borg: We do it our way; yours is irrelevant.
~ Taglines by Taglinator - www.srtware.com ~
--
> Why is it that I can not use two mysql queries in the same PHP file.
You can, I assure you.
> Any info is appreciated.
Perhaps if you could provide your code? W/o it there is no way we can
determine where the problem might be coming from.
Chris
Thank you Daniel,
You remided me that I once had a page with the following instead mysql_error()
and that gave me the verbosity that I needed to get things working. Looks like my
wife changed some fields in the database without thinking how they might affect the
script. Can't believe I didn't c
Why not change your error message display so it's more informative?
Instead of
die("Error in input query");
try this:
or die ("Error in input query: " . mysql_error() . "($query)");
That way, you can see exactly what MySQL says the error was, and exactly
how the query came out. It's really
Error in input query
start of php database code *
$connection = mysql_connect("localhost", "hostbyk1_admin",
"") or
die("Invalid
server or user");
mysql_select_db("hostbyk1_order",$connection);
/ ***
Make sure you repla
this is a vague one , would be good to copy and paste the php debug message
>= Original Message From Jerry M. Howell II <[EMAIL PROTECTED]> =
>Hello all,
>
> We are leasing a dedicated server and seem to pe having problems getting
our
>php script working with mysql. The script was workin
On Fri, Jan 18, 2002 at 01:11:09AM -0500, James Riordon wrote:
> We have a RaQ4i 400MHz server with 512MB of RAM running
> PHP4.03p1 and MySQL 3.23.43 if memory serves correctly.
>
> We are looking at bringing on a client who uses 1 MySQL
> database and PHP to host a news site simila
869.4566
Email: [EMAIL PROTECTED]
-Original Message-
From: Nicholas Ritter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 3:55 PM
To: MySQL
Subject: Re: MySql and PHP
Speaking of Mysql and PHP, has anyone had a problem compiling PHP 4.0.6 (as
a DSO) with MySQL 3.23.40 in use wit
Speaking of Mysql and PHP, has anyone had a problem compiling PHP 4.0.6 (as
a DSO) with MySQL 3.23.40 in use with Apache 1.3.14 on a redhat 7.0 box?
The error I get occurs when I run apache, during startup it says that it can
load the php module because the libmysqlclient.so.10 file cannot be fou
On 07 Aug 2001 13:51:01 +0100, Matt Gaskin wrote:
> Currently I have rented space on a Web Server that has MySql installed and
> PHP, They have created a database directory for myself. Do I need to install
> Mysql and PHP locally to take advantage of this. If so where do I start. I
> have had no
Dear Matt,
> have had no experience of the above two products
just some useful links:
www.phpmyadmin.com
www.php.net/documentation
www.mysql.com/documentation
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gu
Matt:
MySQL and PHP are both 'server-side' components, so there is no need to
instal them locally (unless, of course, you want to do your development and
testing off-line).
If you are doing any significant level of PHP work, I would suggest
installing a local version of both MySQL and PHP. I hav
No need to install locally. You could write everything locally, upload it
to the server, and see if what you wrote works.
Tyler
On Tue, 7 Aug 2001 13:51:01 +0100
"Matt Gaskin" <[EMAIL PROTECTED]> wrote:
> Hi All
>
> Currently I have rented space on a Web Server that has MySql installed
> and
I know this sounds bizarre, but I believe that error means the your SQL
statement did not return any rows and you don't have any error checking in
place to cater for this. I know this, because I did the same thing. ;)
Regards,
Kevin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[
You may want to have a look at PHPLIB. They have a really fine
security module with all kinds of grants and privileges for
purposes like you need. Also, those guys know what security
means. They would never use root to operate a system.
Sie schrieben am Mittwoch, 11. Juli 2001, 14:37:23:
> Is it
[EMAIL PROTECTED] wrote:
> I have Mysql 3.22 and PHP4 installed with RedHat 7.0 linux distribution.I created a
>script connecting my html page with mysql database(function
>mysql_pconnect).Everything was working just fine one day but on the next day I saw a
>message on my screen "Call to undef
I wouldn't advise accessing databases using the root user through the web.
Pieter
Channon Quillen wrote:
> Is it better to let mysql handle logins or to create a table with this
> info?
> I'm setting up a db that has faculty and students. Currently, all access
> to the db is through user root
Hi
Well if you are using PHP, what we do is have one user e.g. 'PHPLOGON' that
conects to the DB.
Then when the user logis on thay enter a user name and password, php looks
this up in a table on MySQL (useing user PHPLOGON) and looks in table
faculty (username,password).
This way users do not
Is it 'exactly' once every 10 times ??
You should check to make sure it's not an 'external' issue.
- Do you have a 'series' of DNS servers (like 10) that you use to lookup
system names (and 1 of them isn't working properly ?)
Try some other service (like 'pinging' the MySQL server from the P
On 11 Apr 2001, at 18:59, David wrote:
> I tried posting this in the PHP newsgroup but received no
> response so thought I would try here since issue involves
> MySQL
>
The easiest solution is to use lists, eg:
Admin
Networking
ping
traceroute
echo
rather than table da
I want to be able to change menu items on the fly instead of having to modify
the html code manually. Some of the menu item links change a lot or I need to
add additional menus. Keeping the menus in a database allows me to edit/change
the menu items easily from the web page
Thanks
Rolf Hopkins
This doesn't look easy and I don't have time to sit down and think about it
but I'll give a couple of suggestions.
1. An ORDER BY clause may help. When you go through the list, you will then
need to detect a change in "menu level".
2. Why do the menu items need to be in a database anyway? Just
Adrian D'Costa wrote:
> Hi,
>
> I have two tables city and country
> +---+-+--+-+-++
> | Field | Type| Null | Key | Default | Extra |
> +---+-+--+-+-++
> | id
This is really a JavaScript problem if you don't want to use the submit
button.
Use PHP to load the values of both tables into a JavaScript array. Then
write JS code that will change the contents of the City control based on
what is selected in the country control. Not terribly difficult.
Cal
81 matches
Mail list logo
