What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.



mysql_change_user — Changes the user for an active MySQL connection.


bool mysql_change_user(user, password[, database][, connection]);
string user: Username to log in with
string password: Password to use
string database (optional): Default database to use for queries
mysql link connection (optional): Connection handle returned by mysql_connect() or mysql_pconnect()


TRUE on success; FALSE otherwise


mysql_change_user() allows the user for any active MySQL connection to be changed as desired.

The user and password arguments are required. The optional database argument is used to set the default database to use with calls to mysql_query() for the MySQL connection given in connection . If no connection handle is specified in the connection argument, the last connection opened is used by default.


PHP 3.0.13+, MySQL 3.23.3+

See also

To connect to a MySQL server:




Example 787. Connect to a database and change the active user for the connection

// Connect to the default MySQL server
$mysql_link = mysql_connect ()
   or die ("Could not connect to the default MySQL server.");

$user = 'bill';

// Attempt to change the user on the MySQL connection
if (mysql_change_user ($user, 'chupachups')) {
    echo "User changed to <b>$user</b>.";
} else {
    echo "User could not be changed to <b>$user</b>.";

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at The authors of this book have elected not to choose any options under the OPL. This online book was obtained from and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2005, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.