Scripting/Squirrel/Functions/mysql change user

Changes the current MySQL session authentication.

Syntax

mysql_change_user ( MySQLConnection handler, string new_username, string new_password )

Arguments

• MySQLConnection handler - A valid MySQL link/handler
• String new_username - The new username
• String new_password - The password for the new username

Return value

true on success and/or false on failure

Example

handler <- mysql_connect("localhost","writer","password","database");
if( handler ) print("Successfully connected.");
else
    mysql_change_user(handler,"reader","password"),
    print("Successfully connected to read-only mode");

By KAKAN