Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
im DeBoer [EMAIL PROTECTED] wrote:
Hi everyone,
I've recently tried installing webcalander http://www.k5n.us/webcalendar.php on
my FBSD box.
I'm using version 5.1.1 of PHP, version 5.0.17 of MySQL, and
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
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+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED]:
You haven't given us much
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 us
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.
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
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:
stop
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
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,
On May 29, 2005, at 11:13 AM, [EMAIL PROTECTED] wrote:
?php
$server = localhost:/var/mysql/mysql.sock;
$user=mysuperuser;
$password=mypassword;
$db = mysql;
mysql_connect($server, $user, $password);
mysql_select_db($db);
echo mysql_error();
phpinfo();
?
I get these:
Warning: mysql_connect():
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]
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
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+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED]:
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
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
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
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 presenet
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
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
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+oshl=frlr=start=30sa=N
Mathias
Selon Michael Stassen [EMAIL PROTECTED]:
You haven't given us much to go on, other
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
[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
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
what
[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
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
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 first as I
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
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
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/ASP,
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
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
[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
Jay Blanchard wrote:
snip
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
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
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
problem is
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 as
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 installation
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 have
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
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 over a
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 night) and it runs. My
problem
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 php.
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 latest as
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 you could build Apache with MySQL
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]
wrote:
Did you build both php and apache with MySQL support?
I wasn't
]
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
problem is that PHP does
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 it runs.
I have
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 condition , plz help
thanx
curlys
?php
/* Connecting, selecting
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
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:55PM
Yes, you can download the package or install from RH CD:
php-mysql
http://rpmfind.net/linux/rpm2html/search.php?query=php_mysqlsubmit=Search+...system=arch=
This is required so PHP will have support for mysql functions. You
apache should be ok without changes.
Sincerely,
Szymon
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
Zsombor Papp wrote:
Hi,
I would like to have MySQL 4.0.17, Apache, and PHP
with access to MySQL, all this on a Linux server. So
far I have RedHat 8.0 and MySQL 4.0.17 installed. I
would like to know if there are any Apache and PHP RPM
packages that I could install on top of this. I did
try
I did try to install php-mysql-4.3.4-1 (I just noticed
that I mistyped the PHP version numbers below, I tried
4.2.x and 4.3.4-1), and everything else the RPM
dependency checks were complaining about. I gave up
when it looked like I would have to install two
conflicting versions of openssl to avoid
Zsombor Papp wrote:
I did try to install php-mysql-4.3.4-1 (I just noticed
that I mistyped the PHP version numbers below, I tried
4.2.x and 4.3.4-1), and everything else the RPM
dependency checks were complaining about. I gave up
when it looked like I would have to install two
conflicting
--- John Nichel [EMAIL PROTECTED] wrote:
Zsombor Papp wrote:
I did try to install php-mysql-4.3.4-1 (I just
noticed
that I mistyped the PHP version numbers below, I
tried
4.2.x and 4.3.4-1), and everything else the RPM
dependency checks were complaining about. I gave
up
when it
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:
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'];
}
Loop through the result and return the value from the last row
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
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 ~
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
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 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
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?
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 working fine
Error in input query
start of php database code *
$connection = mysql_connect(localhost, hostbyk1_admin,
mypassword) or
die(Invalid
server or user);
mysql_select_db(hostbyk1_order,$connection);
/ ***
Make sure you
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)/p);
That way, you can see exactly what MySQL says the error was, and exactly
how the query came out. It's really
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
On Thursday 29 November 2001 02:01, Auri Net SAC wrote:
Hi
please who knows a package that install apache + php + mysql in linux,
i know phptriad but its for windows
Thanks for your answer
rvj
ApacheToolBox http://www.apachetoolbox.com
--
Jason Wong - Gremlins Associates -
Foxserv at sourceforge.net
- Original Message -
From: Auri Net SAC [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 2:01 AM
Subject: Mysql apache php
Hi
please who knows a package that install apache + php + mysql in linux,
i know phptriad but its for
Auri Net SAC wrote:
Hi
please who knows a package that install apache + php + mysql in linux,
i know phptriad but its for windows
Thanks for your answer
rvj
Hello,
If your system is Linux...
You need install Apache , php and MySQL !
Edward.
: [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 with Apache
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
PHP,
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
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
#
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
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
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:
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
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.
[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
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
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
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
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:
ul
liAdmin/li
ul
liNetworking/li
ul
liping
litraceroute
liecho
/ul
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
Adrian D'Costa wrote:
Hi,
I have two tables city and country
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| id|
87 matches
Mail list logo
