Sql help: not able to change

[WapAdda]

mysql_query($query);
$query="CREATE TABLE `tusers` (`id` int(10) NOT NULL auto_increment,`name` varchar(30) NOT NULL default '',`pass` varchar(60) NOT NULL default '',`email` varchar(200) NOT NULL default '',`admin` int(5) NOT NULL default '0',`banned` int(5) NOT NULL default '0',PRIMARY KEY  (`id`),UNIQUE KEY `name` (`name`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;";
$r=mysql_query($query);
if (!$r) {echo("Error!! CREATE TABLE \"tusers\"<br/>\r\n");}
$query="INSERT INTO `tusers` VALUES (1, 'metal', '86094b61cb9f63b77f982ceae03e95f0', 'metal', 1, 0);";
mysql_query($query); 

i can't change tusers metal name and metal password. And don't know what's this ( 86094b61cb9f63b77f982ceae03e95f0 ) please help me.

[something else]

mysql_query($query);
$query="CREATE TABLE `tusers` (`id` int(10) NOT NULL auto_increment,`name` varchar(30) NOT NULL default '',`pass` varchar(60) NOT NULL default '',`email` varchar(200) NOT NULL default '',`admin` int(5) NOT NULL default '0',`banned` int(5) NOT NULL default '0',PRIMARY KEY  (`id`),UNIQUE KEY `name` (`name`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;";
$r=mysql_query($query);
if (!$r) {echo("Error!! CREATE TABLE \"tusers\"<br/>\r\n");}
$query="INSERT INTO `tusers` VALUES (1, 'metal', '86094b61cb9f63b77f982ceae03e95f0', 'metal', 1, 0);";
mysql_query($query); 

i can't change tusers metal name and metal password. And don't know what's this ( 86094b61cb9f63b77f982ceae03e95f0 ) please help me.

just change the name metal to your name?
86094b61cb9f63b77f982ceae03e95f0 is md5 password "metal"

[WapAdda]

just change the name metal to your name?
86094b61cb9f63b77f982ceae03e95f0 is md5 password "metal"

ok, i change the name metal to my name. But how change password? What's the md5? Please tell me.

[something else]

mysql_query($query); 
$query="CREATE TABLE `tusers` (`id` int(10) NOT NULL auto_increment,`name` varchar(30) NOT NULL default '',`pass` varchar(60) NOT NULL default '',`email` varchar(200) NOT NULL default '',`admin` int(5) NOT NULL default '0',`banned` int(5) NOT NULL default '0',PRIMARY KEY  (`id`),UNIQUE KEY `name` (`name`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;"; 
$r=mysql_query($query); 
if (!$r) {echo("Error!! CREATE TABLE \"tusers\"<br/>\r\n");} 
$query="INSERT INTO `tusers` VALUES (1, 'metal', '".md5('your pass')."', 'metal', 1, 0);"; 
mysql_query($query); 

[WapAdda]

Thank you sir. Now im done. But you tell me what's md5?

[something else]

md5 is a 1 way encryption method that turns a string or integer/float into a 32 digit string
MD5 - Wikipedia, the free encyclopedia

[KingofKingZ]

how to delete tables and rows? i don't know how to say that i used zedge script. i asked my friend to install it for me but later i deleted the whole public_html folder. i also deleted database user and database password. i can still see files related in phpmyadmin ! how can i reset or delete previously uploaded sql file ??????????

[something else]

login to your database .... select the table(s) you want to delete and then select DROP table