• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Linux MySql ON LINUX

CrumDubh

New Member
Joined
Feb 10, 2009
Messages
41
Reaction score
0
How do I make a GM account or just modify ANYTHING in player files with Mysql.
There is about 1000 tutorials about it, but can't find one for Linux :S

Halp plx :)
 
How do I make a GM account or just modify ANYTHING in player files with Mysql.
There is about 1000 tutorials about it, but can't find one for Linux :S

Halp plx :)

lol like on windows in phpmyadmin ?
Code:
apt-get install phpmyadmin
then search for where is the phpmyadmind search for more files in a folder because idk where it is exacly installed then copy it to /var/www
 
lol like on windows in phpmyadmin ?
Code:
apt-get install phpmyadmin
then search for where is the phpmyadmind search for more files in a folder because idk where it is exacly installed then copy it to /var/www

copied (well I think, I've found 2 folders, and I copied both in there.. after, what am I suposed to do??

This site don't work :S
http://localhost/phpmyadmin
 
sudo cp /var/lib/phpmyadmin/* /var/www/
sudo cp /var/lib/phpmyadmin/* /var/www/

so.. if I do " dir /var/www ", it gives me this.
apache.conf
config.footer.inc.php
config.inc.php
index.html
blowfish_secret.inc.php
config.header.inc.php
htpasswd.setup
lighttpd.conf

help plx :)
 
aight, so this is what i got from the localhost/phpmyadmin

html {
font-size: 82%;
}

input, select, textarea {
font-size: 1em;
}

div.item label {
white-space: nowrap;
}

/* @deprecated */
.nowrap {
white-space: nowrap;
}
div.nowrap {
margin: 0;
padding: 0;
}

.syntax_comment {color: #808000;}
.syntax_comment_mysql {}
.syntax_comment_ansi {}
.syntax_comment_c {}
.syntax_digit {}
.syntax_digit_hex {color: teal;}
.syntax_digit_integer {color: teal;}
.syntax_digit_float {color: aqua;}
.syntax_punct {color: fuchsia;}
.syntax_alpha {}
.syntax_alpha_columnType {color: #FF9900;}
.syntax_alpha_columnAttrib {color: #0000FF;}
.syntax_alpha_reservedWord {color: #990099;}
.syntax_alpha_functionName {color: #FF0000;}
.syntax_alpha_identifier {color: black;}
.syntax_alpha_charset {color: #6495ed;}
.syntax_alpha_variable {color: #800000;}
.syntax_quote {color: #008000;}
.syntax_quote_double {}
.syntax_quote_single {}
.syntax_quote_backtick {}
.syntax_indent0 {margin-left: 0em;}
.syntax_indent1 {margin-left: 1em;}
.syntax_indent2 {margin-left: 2em;}
.syntax_indent3 {margin-left: 3em;}
.syntax_indent4 {margin-left: 4em;}
.syntax_indent5 {margin-left: 5em;}
.syntax_indent6 {margin-left: 6em;}
.syntax_indent7 {margin-left: 7em;}
/******************************************************************************/
/* general tags */
body {
font-family: sans-serif;
padding: 0;
margin: 0.5em;
color: #000000;
background: #F5F5F5;
}

textarea, tt, pre, code {
font-family: monospace;
}

h1 {
font-size: 140%;
font-weight: bold;
}

h2 {
font-size: 120%;
font-weight: bold;
}

h3 {
font-weight: bold;
}

a:link,
a:visited,
a:active {
text-decoration: none;
color: #0000FF;
}

a:hover {
text-decoration: underline;
color: #FF0000;
}

dfn {
font-style: normal;
}

dfn:hover {
font-style: normal;
cursor: help;
}

th {
font-weight: bold;
color: #000000;
background: #D3DCE3;
}

a img {
border: 0;
}

hr {
color: #000000;
background-color: #000000;
border: 0;
height: 1px;
}

form {
padding: 0;
margin: 0;
display: inline;
}

textarea {
overflow: visible;
}

fieldset {
margin-top: 1em;
border: #000000 solid 1px;
padding: 0.5em;
background: #E5E5E5;
}

fieldset fieldset {
margin: 0.8em;
}

fieldset legend {
font-weight: bold;
color: #444444;
background-color: transparent;
}

/* buttons in some browsers (eg. Konqueror) are block elements,
this breaks design */
button {
display: inline;
}

table caption,
table th,
table td {
padding: 0.1em 0.5em 0.1em 0.5em;
margin: 0.1em;
vertical-align: top;
}

img,
input,
select,
button {
vertical-align: middle;
}


/******************************************************************************/
/* classes */

fieldset.tblFooters {
margin-top: 0;
margin-bottom: 0.5em;
/* avoid a thick line since this should be used under another fieldset */
border-top: 0;
text-align: right;
float: none;
clear: both;
}

fieldset .formelement {
float: left;
margin-right: 0.5em;
/* IE */
white-space: nowrap;
}

/* revert for Gecko */
fieldset div[class=formelement] {
white-space: normal;
}

button.mult_submit {
border: none;
background-color: transparent;
}

/* odd items 1,3,5,7,... */
table tr.odd th,
.odd {
background: #E5E5E5;
}

/* even items 2,4,6,8,... */
table tr.even th,
.even {
background: #D5D5D5;
}

/* odd table rows 1,3,5,7,... */
table tr.odd th,
table tr.odd,
table tr.even th,
table tr.even {
text-align: left;
}

/* marked table rows */
table tr.marked th,
table tr.marked {
background: #FFCC99;
color: #000000;
}

/* hovered items */
.odd:hover,
.even:hover,
.hover {
background: #CCFFCC;
color: #000000;
}

/* hovered table rows */
table tr.odd:hover th,
table tr.even:hover th,
table tr.hover th {
background: #CCFFCC;
color: #000000;
}

/**
* marks table rows/cells if the db field is in a where condition
*/
tr.condition th,
tr.condition td,
td.condition,
th.condition {
border: 1px solid #FFCC99;
}

table .value {
text-align: right;
white-space: normal;
}
/* IE doesnt handles 'pre' right */
table [class=value] {
white-space: normal;
}


.value {
font-family: monospace;
}
.value .attention {
color: red;
font-weight: bold;
}
.value .allfine {
color: green;
}


img.lightbulb {
cursor: pointer;
}

.pdflayout {
overflow: hidden;
clip: inherit;
background-color: #FFFFFF;
display: none;
border: 1px solid #000000;
position: relative;
}

.pdflayout_table {
background: #D3DCE3;
color: #000000;
overflow: hidden;
clip: inherit;
z-index: 2;
display: inline;
visibility: inherit;
cursor: move;
position: absolute;
font-size: 80%;
border: 1px dashed #000000;
}

/* MySQL Parser */
.syntax {
font-size: 80%;
}

.syntax_comment {
padding-left: 4pt;
padding-right: 4pt;
}

.syntax_digit {
}

.syntax_digit_hex {
}

.syntax_digit_integer {
}

.syntax_digit_float {
}

.syntax_punct {
}

.syntax_alpha {
}

.syntax_alpha_columnType {
text-transform: uppercase;
}

.syntax_alpha_columnAttrib {
text-transform: uppercase;
}

.syntax_alpha_reservedWord {
text-transform: uppercase;
font-weight: bold;
}

.syntax_alpha_functionName {
text-transform: uppercase;
}

.syntax_alpha_identifier {
}

.syntax_alpha_charset {
}

.syntax_alpha_variable {
}

.syntax_quote {
white-space: pre;
}

.syntax_quote_backtick {
}

/* leave some space between icons and text */
.icon {
vertical-align: middle;
margin-right: 0.3em;
margin-left: 0.3em;
}
/* no extra space in table cells */
td .icon {
margin: 0;
}

.selectallarrow {
margin-right: 0.3em;
margin-left: 0.6em;
}

/* message boxes: warning, error, confirmation */
.notice {
color: #000000;
background-color: #FFFFDD;
}
h1.notice,
div.notice {
margin: 0.5em 0 0.5em 0;
border: 0.1em solid #FFD700;
background-image: url(./themes/original/img/s_notice.png);
background-repeat: no-repeat;
background-position: 10px 50%;
padding: 10px 10px 10px 36px;
}
.notice h1 {
border-bottom: 0.1em solid #FFD700;
font-weight: bold;
text-align: left;
margin: 0 0 0.2em 0;
}

.warning {
color: #CC0000;
background-color: #FFFFCC;
}
p.warning,
h1.warning,
div.warning {
margin: 0.5em 0 0.5em 0;
border: 0.1em solid #CC0000;
background-image: url(./themes/original/img/s_warn.png);
background-repeat: no-repeat;
background-position: 10px 50%;
padding: 10px 10px 10px 36px;
}
.warning h1 {
border-bottom: 0.1em solid #cc0000;
font-weight: bold;
text-align: left;
margin: 0 0 0.2em 0;
}

.error {
background-color: #FFFFCC;
color: #ff0000;
}

h1.error,
div.error {
margin: 0.5em 0 0.5em 0;
border: 0.1em solid #ff0000;
background-image: url(./themes/original/img/s_error.png);
background-repeat: no-repeat;
background-position: 10px 50%;
padding: 10px 10px 10px 36px;
}
div.error h1 {
border-bottom: 0.1em solid #ff0000;
font-weight: bold;
text-align: left;
margin: 0 0 0.2em 0;
}

.confirmation {
background-color: #FFFFCC;
}
fieldset.confirmation {
border: 0.1em solid #FF0000;
}
fieldset.confirmation legend {
border-left: 0.1em solid #FF0000;
border-right: 0.1em solid #FF0000;
font-weight: bold;
background-image: url(./themes/original/img/s_really.png);
background-repeat: no-repeat;
background-position: 5px 50%;
padding: 0.2em 0.2em 0.2em 25px;
}
/* end messageboxes */


.tblcomment {
font-size: 70%;
font-weight: normal;
color: #000099;
}

.tblHeaders {
font-weight: bold;
color: #000000;
background: #D3DCE3;
}

.tblFooters {
font-weight: normal;
color: #000000;
background: #D3DCE3;

}

.tblHeaders a:link,
.tblHeaders a:active,
.tblHeaders a:visited,
.tblFooters a:link,
.tblFooters a:active,
.tblFooters a:visited {
color: #0000FF;
}

.tblHeaders a:hover,
.tblFooters a:hover {
color: #FF0000;
}

/* forbidden, no privilegs */
.noPrivileges {
color: #FF0000;
font-weight: bold;
}

/* disabled text */
.disabled,
.disabled a:link,
.disabled a:active,
.disabled a:visited {
color: #666666;
}

.disabled a:hover {
color: #666666;
text-decoration: none;
}

tr.disabled td,
td.disabled {
background-color: #cccccc;
}

/**
* login form
*/
body.loginform h1,
body.loginform a.logo {
display: block;
text-align: center;
}

body.loginform {
text-align: center;
}

body.loginform div.container {
text-align: left;
width: 30em;
margin: 0 auto;
}

form.login label {
float: left;
width: 10em;
font-weight: bolder;
}


/******************************************************************************/
/* specific elements */

/* topmenu */
ul#topmenu {
font-weight: bold;
list-style-type: none;
margin: 0;
padding: 0;
}

ul#topmenu li {
float: left;
margin: 0;
padding: 0;
vertical-align: middle;
}

#topmenu img {
vertical-align: middle;
margin-right: 0.1em;
}

/* default tab styles */
.tab, .tabcaution, .tabactive {
display: block;
margin: 0.2em 0.2em 0 0.2em;
padding: 0.2em 0.2em 0 0.2em;
white-space: nowrap;
}

/* disabled tabs */
span.tab {
color: #666666;
}

/* disabled drop/empty tabs */
span.tabcaution {
color: #ff6666;
}

/* enabled drop/empty tabs */
a.tabcaution {
color: #FF0000;
}
a.tabcaution:hover {
color: #FFFFFF;
background-color: #FF0000;
}

#topmenu {
margin-top: 0.5em;
padding: 0.1em 0.3em 0.1em 0.3em;
}

ul#topmenu li {
border-bottom: 1pt solid black;
}

/* default tab styles */
.tab, .tabcaution, .tabactive {
background-color: #E5E5E5;
border: 1pt solid #D5D5D5;
border-bottom: 0;
border-top-left-radius: 0.4em;
border-top-right-radius: 0.4em;
}

/* enabled hover/active tabs */
a.tab:hover,
a.tabcaution:hover,
.tabactive,
.tabactive:hover {
margin: 0;
padding: 0.2em 0.4em 0.2em 0.4em;
text-decoration: none;
}

a.tab:hover,
.tabactive {
background-color: #F5F5F5;
}

/* to be able to cancel the bottom border, use <li class="active"> */
ul#topmenu li.active {
border-bottom: 1pt solid #F5F5F5;
}

/* disabled drop/empty tabs */
span.tab,
a.warning,
span.tabcaution {
cursor: url(./themes/original/img/error.ico), default;
}
/* end topmenu */


/* Calendar */
table.calendar {
width: 100%;
}
table.calendar td {
text-align: center;
}
table.calendar td a {
display: block;
}

table.calendar td a:hover {
background-color: #CCFFCC;
}

table.calendar th {
background-color: #D3DCE3;
}

table.calendar td.selected {
background-color: #FFCC99;
}

img.calendar {
border: none;
}
form.clock {
text-align: center;
}
/* end Calendar */


/* table stats */
div#tablestatistics {
border-bottom: 0.1em solid #669999;
margin-bottom: 0.5em;
padding-bottom: 0.5em;
}

div#tablestatistics table {
float: left;
margin-bottom: 0.5em;
margin-right: 0.5em;
}

div#tablestatistics table caption {
margin-right: 0.5em;
}
/* END table stats */


/* server privileges */
#tableuserrights td,
#tablespecificuserrights td,
#tabledatabases td {
vertical-align: middle;
}
/* END server privileges */



/* Heading */
#serverinfo {
font-weight: bold;
margin-bottom: 0.5em;
}

#serverinfo .item {
white-space: nowrap;
}

#span_table_comment {
font-weight: normal;
font-style: italic;
white-space: nowrap;
}

#serverinfo img {
margin: 0 0.1em 0 0.2em;
}


#textSQLDUMP {
width: 95%;
height: 95%;
font-family: "Courier New", Courier, mono;
font-size: 110%;
}

#TooltipContainer {
position: absolute;
z-index: 99;
width: 20em;
height: auto;
overflow: visible;
visibility: hidden;
background-color: #ffffcc;
color: #006600;
border: 0.1em solid #000000;
padding: 0.5em;
}

/* user privileges */
#fieldset_add_user_login div.item {
border-bottom: 1px solid silver;
padding-bottom: 0.3em;
margin-bottom: 0.3em;
}

#fieldset_add_user_login label {
float: left;
display: block;
width: 10em;
max-width: 100%;
text-align: right;
padding-right: 0.5em;
}

#fieldset_add_user_login span.options #select_pred_username,
#fieldset_add_user_login span.options #select_pred_hostname,
#fieldset_add_user_login span.options #select_pred_password {
width: 100%;
max-width: 100%;
}

#fieldset_add_user_login span.options {
float: left;
display: block;
width: 12em;
max-width: 100%;
padding-right: 0.5em;
}

#fieldset_add_user_login input {
width: 12em;
clear: right;
max-width: 100%;
}

#fieldset_add_user_login span.options input {
width: auto;
}

#fieldset_user_priv div.item {
float: left;
width: 9em;
max-width: 100%;
}

#fieldset_user_priv div.item div.item {
float: none;
}

#fieldset_user_priv div.item label {
white-space: nowrap;
}

#fieldset_user_priv div.item select {
width: 100%;
}

#fieldset_user_global_rights fieldset {
float: left;
}
/* END user privileges */


/* serverstatus */
div#serverstatus table caption a.top {
float: right;
}

div#serverstatus div#serverstatusqueriesdetails table,
div#serverstatus table#serverstatustraffic,
div#serverstatus table#serverstatusconnections {
float: left;
}

#serverstatussection,
.clearfloat {
clear: both;
}
div#serverstatussection table {
width: 100%;
margin-bottom: 1em;
}
div#serverstatussection table .name {
width: 18em;
}
div#serverstatussection table .value {
width: 6em;
}

div#serverstatus table tbody td.descr a,
div#serverstatus table .tblFooters a {
white-space: nowrap;
}
div#serverstatus div#statuslinks a:before,
div#serverstatus div#sectionlinks a:before,
div#serverstatus table tbody td.descr a:before,
div#serverstatus table .tblFooters a:before {
content: '[';
}
div#serverstatus div#statuslinks a:after,
div#serverstatus div#sectionlinks a:after,
div#serverstatus table tbody td.descr a:after,
div#serverstatus table .tblFooters a:after {
content: ']';
}
/* end serverstatus */

/* querywindow */
body#bodyquerywindow {
margin: 0;
padding: 0;
background-image: none;
background-color: #F5F5F5;
}

div#querywindowcontainer {
margin: 0;
padding: 0;
width: 100%;
}

div#querywindowcontainer fieldset {
margin-top: 0;
}
/* END querywindow */


/* querybox */

div#sqlquerycontainer {
float: left;
width: 69%;
/* height: 15em; */
}

div#tablefieldscontainer {
float: right;
width: 29%;
/* height: 15em; */
}

div#tablefieldscontainer select {
width: 100%;
/* height: 12em; */
}

textarea#sqlquery {
width: 100%;
/* height: 100%; */
}

div#queryboxcontainer div#bookmarkoptions {
margin-top: 0.5em;
}
/* end querybox */

/* main page */
#maincontainer {
background-image: url(./themes/original/img/logo_right.png);
background-position: right bottom;
background-repeat: no-repeat;
border-bottom: 1px solid silver;
}

#mysqlmaininformation,
#pmamaininformation {
float: left;
width: 49%;
}

#maincontainer ul {
list-style-image: url(./themes/original/img/item_ltr.png);
vertical-align: middle;
}

#maincontainer li {
margin-bottom: 0.3em;
}
/* END main page */


/* iconic view for ul items */
li#li_create_database {
list-style-image: url(./themes/original/img/b_newdb.png);
}

li#li_select_lang {
list-style-image: url(./themes/original/img/s_lang.png);
}

li#li_select_mysql_collation,
li#li_select_mysql_charset {
list-style-image: url(./themes/original/img/s_asci.png);
}

li#li_select_theme{
list-style-image: url(./themes/original/img/s_theme.png);
}

li#li_server_info{
list-style-image: url(./themes/original/img/s_host.png);
}

li#li_user_info{
/* list-style-image: url(./themes/original/img/s_rights.png); */
}

li#li_mysql_status{
list-style-image: url(./themes/original/img/s_status.png);
}

li#li_mysql_variables{
list-style-image: url(./themes/original/img/s_vars.png);
}

li#li_mysql_processes{
list-style-image: url(./themes/original/img/s_process.png);
}

li#li_mysql_collations{
list-style-image: url(./themes/original/img/s_asci.png);
}

li#li_mysql_engines{
list-style-image: url(./themes/original/img/b_engine.png);
}

li#li_mysql_binlogs {
list-style-image: url(./themes/original/img/s_tbl.png);
}

li#li_mysql_databases {
list-style-image: url(./themes/original/img/s_db.png);
}

li#li_export {
list-style-image: url(./themes/original/img/b_export.png);
}

li#li_import {
list-style-image: url(./themes/original/img/b_import.png);
}

li#li_change_password {
list-style-image: url(./themes/original/img/s_passwd.png);
}

li#li_log_out {
list-style-image: url(./themes/original/img/s_loggoff.png);
}

li#li_pma_docs {
list-style-image: url(./themes/original/img/b_docs.png);
}

li#li_phpinfo {
list-style-image: url(./themes/original/img/php_sym.png);
}

li#li_pma_homepage {
list-style-image: url(./themes/original/img/b_home.png);
}

li#li_mysql_privilegs{
list-style-image: url(./themes/original/img/s_rights.png);
}

li#li_switch_dbstats {
list-style-image: url(./themes/original/img/b_dbstatistics.png);
}

li#li_flush_privileges {
list-style-image: url(./themes/original/img/s_reload.png);
}
/* END iconic view for ul items */


#body_browse_foreigners {
background: #D0DCE0;
margin: 0.5em 0.5em 0 0.5em;
}

#bodyquerywindow {
background: #D0DCE0;
}

#bodythemes {
width: 500px;
margin: auto;
text-align: center;
}

#bodythemes img {
border: 0.1em solid black;
}

#bodythemes a:hover img {
border: 0.1em solid red;
}

#fieldset_select_fields {
float: left;
}

#selflink {
clear: both;
display: block;
margin-top: 1em;
margin-bottom: 1em;
width: 100%;
border-top: 0.1em solid silver;
text-align: right;
}

#table_innodb_bufferpool_usage,
#table_innodb_bufferpool_activity {
float: left;
}

#div_mysql_charset_collations table {
float: left;
}

#div_table_order {
min-width: 48%;
float: left;
}

#div_table_rename {
min-width: 48%;
float: left;
}

#div_table_copy {
min-width: 48%;
float: left;
}

#div_table_options {
clear: both;
min-width: 48%;
float: left;
}

#qbe_div_table_list {
float: left;
}

#qbe_div_sql_query {
float: left;
}

label.desc {
width: 30em;
float: left;
}

Is it good? :s if yes, what I'm suposeed to do :S:S
 
Can someone post an Linux server? I have search for a Linux server in soon 1 week and I havent found one. Please. post I want 8.40 - 8.42
 
Back
Top