[Help] how to access another database?

[Devon]

months now i wonder how a developer is sure that the admin wont dismiss him from the staff if they have an argument. anyway thats not my question.

 

i wanna know how can i access a servers database without accessing the servers machine. im not talking about hacking. i can access the servers machine at the moment and i can do whatever i want in it. i just want always to control the server.

 

anyway my question is simple: how can the admin give me permissions to access his servers database from my pc?

[Horus]

months now i wonder how a developer is sure that the admin wont dismiss him from the staff if they have an argument. anyway thats not my question.

 

i wanna know how can i access a servers database without accessing the servers machine. im not talking about hacking. i can access the servers machine at the moment and i can do whatever i want in it. i just want always to control the server.

 

anyway my question is simple: how can the admin give me permissions to access his servers database from my pc?

Just tell him to create a user for you and allowing external connections in the MySQL Config. Thats it

[Devon]

yes and what should he write in the username, user password etc.?

[Hax0r]

You can also create another account(ID/PW) using the navicat.

 

 

 

 

Keep in mind that the server's 3306 port both tcp and udp must be opened.

[ChaOtiC*]

To access in other DB u must know MySql User, Psw and Port 3306 must be opened i Guess...

[Devon]

so in username and password i write whatever i want. right?

[Hax0r]

Yes

[Devon]

though i dont understand how it will contact with my computer, i will try it and i will tell you if it worked or not. thank you man

[Hax0r]

Duh, you just have to connect using Navicat/phpmyadmin/php.

 

"USERNAME"@"MYSQL_SERVER_HOST" using "PASSWORD"

 

PHP Example:

 

<?php
$con = mysql_connect("localhost","peter","abc123");//localhost=MYSQL_SERVER_HOST peter=USERNAME abc123="PASSWORD"
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }

// some code

?>

 

 

For more info: http://w3schools.com/php/php_mysql_intro.asp

 

Take it as a comment: You're supposed to be a dev?

[Devon]

Duh, you just have to connect using Navicat/phpmyadmin/php.

 

"USERNAME"@"MYSQL_SERVER_HOST" using "PASSWORD"

 

PHP Example:

 

<?php
$con = mysql_connect("localhost","peter","abc123");//localhost=MYSQL_SERVER_HOST peter=USERNAME abc123="PASSWORD"
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

?>

 

 

For more info: http://w3schools.com/php/php_mysql_intro.asp

 

Take it as a comment: You're supposed to be a dev?

i wouldnt say that. its just that the admin hasn't any idea about servers so i am better than him so i am his developer