[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

[Michael Stassen]

The short answer is, download the php source and add
  --with-mysql=/your/path/to/mysql
to your build options.  The long answer is in the directions in the php 
manual .

Michael
GH wrote:
I am still new to the PHP scene could you tell me how I "rebuild" the
PHP with the client library...
On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message says, doesn't support the new, more
secure authentication protocol.  Your choices are to tell mysql to use the
older, less-secure protocol, or build a copy of php using your current mysql
client library.  See the manual for more
.
Michael
GH wrote:

I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10  [Build Date  Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error  when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
//## ERROR RECIEVED //
Welcome to phpMyAdmin 2.6.1
phpMyAdmin tried to connect to the MySQL server, and the server
rejected the connection. You should check the host, username and
password in config.inc.php and make sure that they correspond to the
information given by the administrator of the MySQL server.
Error
MySQL said:
#1251 - Client does not support authentication protocol requested by server


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

[GH]

I am still new to the PHP scene could you tell me how I "rebuild" the
PHP with the client library...


On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
> 
> You have mysql 4.1.8, but your php was built with the library for an earlier
> version, which, as the error message says, doesn't support the new, more
> secure authentication protocol.  Your choices are to tell mysql to use the
> older, less-secure protocol, or build a copy of php using your current mysql
> client library.  See the manual for more
> .
> 
> Michael
> 
> GH wrote:
> 
> > I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
> > Version 4.3.10  [Build Date  Dec 14 2004 17:46:48] and mySql 4.1.8
> >
> > I am receiving the enclosed error  when I attempt to go into
> > phpMyAdmin and do not know how to solve the issue...
> >
> > Any assistance would be greatful.
> >
> > Thank you
> > Gary
> >
> >
> > //## ERROR RECIEVED //
> >
> > Welcome to phpMyAdmin 2.6.1
> >
> > phpMyAdmin tried to connect to the MySQL server, and the server
> > rejected the connection. You should check the host, username and
> > password in config.inc.php and make sure that they correspond to the
> > information given by the administrator of the MySQL server.
> >
> > Error
> > MySQL said:
> >
> > #1251 - Client does not support authentication protocol requested by server
> >
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

[Michael Stassen]

You have mysql 4.1.8, but your php was built with the library for an earlier 
version, which, as the error message says, doesn't support the new, more 
secure authentication protocol.  Your choices are to tell mysql to use the 
older, less-secure protocol, or build a copy of php using your current mysql 
client library.  See the manual for more 
.

Michael
GH wrote:
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10  [Build Date  Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error  when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
//## ERROR RECIEVED //
Welcome to phpMyAdmin 2.6.1
phpMyAdmin tried to connect to the MySQL server, and the server
rejected the connection. You should check the host, username and
password in config.inc.php and make sure that they correspond to the
information given by the administrator of the MySQL server.
Error 
MySQL said:  

#1251 - Client does not support authentication protocol requested by server
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: mysql error and resource ID:

[Eric McGrane]

A snippet of the source code would help.

E

"Stuart Felenstein" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> First time setting something like this up. So probably
> making some major mistakes.
> Anyway I get this message : "mysql_error(Resource id
> #2)"
>
> I know it's pointing me to something but not sure what
> .
>
> My suspicion since I'm driving blind :) is that I'm
> attempting an insert using invalid or incorrectly
> stated variables.
>
> Code:
>
> function begin()
> {
> @mysql_query("BEGIN");
> }
> function commit()
> {
> @mysql_query("COMMIT");
> }
> function rollback()
> {
> @mysql_query("ROLLBACK", $link);
> }
> @mysql_connect("myserver","myusername", "mypassword")
> or die(mysql_error());
>
> @mysql_select_db("mydatabase") or die(mysql_error());
> $link = mysql_connect("myserver", "myusername",
> "mypassword");
>
> $query = "INSERT INTO MyTable (RecordID,UserID,Field3,
> Field4, ., )
> values
> // these are all the session variables that I'm trying
> // to use to insert value , is that wrong
>
>
(null,null,$f1a,$f2a,$f2c,$f2d,$f2e,$f2g,$f5b,$f3m,$f3n,$f3e,$f3f,$f3g,$f3h,
$f3i,$f3j,
> $f3k,$f3l)";
> begin(); // transaction begins
> $result = @mysql_query($query, $link);
>
> if(!$result)
> {
> rollback(); // transaction rolls back
> echo "you rolled back";
> echo " . mysql_error($link)";
> exit;
> }
> else
> {
> commit(); // transaction is committed
> echo "your insertion was successful";
> }
> ?>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL error message...

[Shivanischal A]

hi,

mysql_query("$command",$mysqlHandle);

should actually be

mysql_query($command,$mysqlHandle);

it works for me. i did not understand rest ur code. but i think should do
it.
try this and get back if still facing problems.

regards,
-shiva


"Keith Spiller" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> Does anyone know what would cause this message?
>
> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
> resource in c:\program files\easyphp\www\bod-rse\bod\menu.php3 on line
49...
>
> Here is the code:
>
>   $command = "SELECT * FROM central_fakepaths WHERE menu != '0' ORDER BY
menu
> ASC";
>  $result  = mysql_query("$command",$mysqlHandle);
>  $path_directory=explode("/", $HTTP_SERVER_VARS["REQUEST_URI"]);
>
>  while ($myrow = mysql_fetch_row($result))
>  {
>$count++;
>
>If   ($path_directory[1]=="$devsite")  { $path = $myrow[9];  $target =
> $myrow[10]; }
>else   { $path = $myrow[7];  $target =
> $myrow[3];  }
>
>If ($myrow[5] != $count)
>{ echo " height=\"7\">\n";
>  $count++;
>}
>
>   // IF MENU VALUE == COMMITTEES
>if ($myrow[2] == "Committees")
>{
>
>echo " width=139 height=7>
>    Committees
>  ";
>
>   $currdate = date("Y-m",time());
>   $cdate= explode("-" , $currdate);
>   $cyear= $cdate[0];
>   $cmonth   = $cdate[1];
>
>   if ($cmonth >=7 AND $cmonth <=12) $fyear  = $cyear + 1;
>   else  $fyear  = $cyear;
> $fyear2 = $fyear - 1;
> $syear  = "$fyear2 - $fyear";
>
> $commandw = "SELECT menuname, type, active, name FROM bod_board_boards
> WHERE type='committee' AND active='1' ORDER BY name ASC";
> $resultw  = mysql_query("$commandw",$mysqlHandle);
> while ($myroww = mysql_fetch_row($resultw))
>  {
>if ($myroww[0] !="")
> {
>echo "   target='_top'>$myroww[0]";
> }
>  }
>
>//echo "  What They
Do";
>}
>
>else
>{
>  echo "  $myrow[2]\n";
>}
>  }
>
> ?>
>
>
> Any help would be unendingly appreciated...
>
>
> Keith
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Error

[Johannes Janson]

Hi,

> Dear Experts
>
> When ever i try to run MySQL under linux it gives me following error
>
> ERROR 2002 : can't connect to local MYSQL server through socket
'/var/lib/mysql.sock' (111)

this is with PHP isn't it? can you log in the monitor and then type SHOW
VARIABLES. A long list
will be displayed where the socket is listed aswell. Then check if the file
mysql.sock is in the
specified directory. You can also check in the "my.cnf" what the socket is.
I don't know the exact
path where my.cnf is located but I think on my SuSE box it was /etc Usually
it is in /tmp I think.

hope it helped
Johannes



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: MySQL Error

[Jonathan Hilgeman]

Are you running as the admin setting it up or are you a user on the system
getting the error?

"Vivek Misra" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Dear Experts
>
> When ever i try to run MySQL under linux it gives me following error
>
> ERROR 2002 : can't connect to local MYSQL server through socket
'/var/lib/mysql.sock' (111)
>
> what could be possible remedy/rectification of the above ?
>
> million thx in advance
>
> Vivek Misra



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]