To modify the MySQL remote root password



#ifdef _WIN32
#define SNPRINTF _snprintf
#endif

BOOL Changeremoterootpwd (const char* szhost,const char* Szroot,
Const char* Szrootpwd,const char* szdb,
Const char* Szuser,const char* szpwd)
{
MySQL MySQL;
Mysql_init (&mysql);

    if (!mysql_real_connect (&mysql,szhost,szroot,szrootpwd,szdb,0,null,0))
     {
        printf ("%s\n", Mysql_error (&mysql));
        mysql_close (&mysql);
        return false;
   }
   
    char szsql[512] = {0};
   
   /*
    snprintf (szsql,sizeof (szSQL)-1, "Call Pr_change_ User (\ '%s\ ') ", szpwd);
   
    if (mysql_query (&mysql,szsql)! = 0)
    {
        printf ("%s\n", Mysql_error (&mysql));
        mysql_close (&mysql);
        return false;
   }
    */

snprintf (szsql,sizeof (szSQL)-1, "Update mysql.user set Password=password (\ '%s\ ') where user = \ ' root\ ' and host = \ '%%\ '", SZPWD);
if (mysql_query (&mysql,szsql)! = 0)
{
printf ("%s\n", Mysql_error (&mysql));
Mysql_close (&mysql);
return false;
}

strcpy (szSQL, "flush privileges");
if (mysql_query (&mysql,szsql)! = 0)
{
printf ("%s\n", Mysql_error (&mysql));
Mysql_close (&mysql);
return false;
}
Mysql_close (&mysql);
return true;
}

Modify the MySQL remote root password