Ejemplo n.º 1
0
 function createDefaultDatabase()
 {
     $dbname = fix_nname_to_be_variable($this->nname);
     $dbname = substr($dbname, 0, 15);
     $mysql = new Mysqldb(null, null, $dbname);
     $rl['primarydb'] = 'on';
     $rl['dbname'] = $dbname;
     $rl['dbpassword'] = $this->realpass;
     $rl['username'] = $dbname;
     $rl['dbtype'] = 'mysql';
     $rl['syncserver'] = $this->mysqldbsyncserver;
     $rl['parent_clname'] = $this->getClName();
     $mysql->create($rl);
     $this->addToList('mysqldb', $mysql);
     return $mysql;
 }
Ejemplo n.º 2
0
<?php

include_once "lib/include.php";
error_reporting(E_ALL);
initProgram('admin');
$sq = new Sqlite(null, 'mysqldb');
$res = $sq->getTable();
if ($res) {
    foreach ($res as $r) {
        $db = new Mysqldb(null, $r['syncserver'], "aaa");
        $db->dbtype = 'mysql';
        $dbadmin = $db->getDbAdminPass();
        mysql_connect($r['syncserver'], $dbadmin['dbadmin'], $dbadmin['dbpassword']);
        mysql_query("grant all on {$r['dbname']}.* to {$r['username']}@localhost");
        mysql_query("grant all on {$r['dbname']}.* to {$r['username']}@'%'");
    }
}