[PHP] PHP and MySQL problem, please help
hi folks, A query in mysql become with STATE set to STATISTICS and all queries after this query are LOCKED. What is the decision please. Best Regards Bogomil -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP and MySQL problem, please help
[snip] A query in mysql become with STATE set to STATISTICS and all queries after this query are LOCKED.What is the decision please. [/snip] The decision is to ask for a better description if possible, along with some of the suspected code. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP or MySQL problem?
Hi all, I'm uploading a new web site and when doing some testing, I find this error: Access denied for user: 'httpd@localhost' (Using password: NO) in /home/sites/site33/web/cm/proveedores.php on line 47 when trying to save some data into a remote DB... I really don't know if this is a PHP issue or a MySQL issue but I'm sure I havn't seen this before. The error line 47 represents a mysql_query(); instruction. Any advice? Thanks in advance, --- Cesar Aracena [EMAIL PROTECTED] http://www.icaam.com.ar Cel: +54.299.635-6688 Tel/Fax: +54.299.477-4532 Cipolletti, Rio Negro R8324BEG Argentina --- Soluciones profesionales en Internet y Comunicaciones http://www.icaam.com.ar -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP or MySQL problem?
Your answer is in the error message. You have been denied access to the database. Are you connecting to the db before you run your query? If not, php is going to try to connect with the default user/password. César Aracena wrote: Hi all, I'm uploading a new web site and when doing some testing, I find this error: Access denied for user: 'httpd@localhost' (Using password: NO) in /home/sites/site33/web/cm/proveedores.php on line 47 when trying to save some data into a remote DB... I really don't know if this is a PHP issue or a MySQL issue but I'm sure I havn't seen this before. The error line 47 represents a mysql_query(); instruction. Any advice? Thanks in advance, --- Cesar Aracena [EMAIL PROTECTED] http://www.icaam.com.ar Cel: +54.299.635-6688 Tel/Fax: +54.299.477-4532 Cipolletti, Rio Negro R8324BEG Argentina --- Soluciones profesionales en Internet y Comunicaciones http://www.icaam.com.ar -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP or MySQL problem?
Cesar, The error you are receiving is from MYSQL. It is telling you you need a password to access the database with the username you are using. See http://www.php.net/manual/en/function.mysql-connect.php for more information regarding connection to a mysql database and how to add in a password. Jonathan Pitcher Capitol Federal Savings Webmaster On Wednesday, February 5, 2003, at 03:55 PM, César Aracena wrote: Hi all, I'm uploading a new web site and when doing some testing, I find this error: Access denied for user: 'httpd@localhost' (Using password: NO) in /home/sites/site33/web/cm/proveedores.php on line 47 when trying to save some data into a remote DB... I really don't know if this is a PHP issue or a MySQL issue but I'm sure I havn't seen this before. The error line 47 represents a mysql_query(); instruction. Any advice? Thanks in advance, --- Cesar Aracena [EMAIL PROTECTED] http://www.icaam.com.ar Cel: +54.299.635-6688 Tel/Fax: +54.299.477-4532 Cipolletti, Rio Negro R8324BEG Argentina --- Soluciones profesionales en Internet y Comunicaciones http://www.icaam.com.ar -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php