Accessing MySQL Linux from another computer

[Joveice]

So I'm trying to connect to the database from my main computer but I just get promted with error could not connect, so I Googled this found how to enable remote access. Did this and yet still not working.

How do I do this? I'm still local just from another computer.

[Guest]

PuTTY into the computer.

 

(As long as you are on the amd network, it should be easy)

[Joveice]

Just now, MagnesiumPC said:

PuTTY into the computer.

 

(As long as you are on the amd network, it should be easy)

I have a program to fill inn the tables easyer which need access.

[Guest]

1 minute ago, Joveice said:

I have a program to fill inn the tables easyer which need access.

Oh. 

 

http://www.gotomypc.com/remote-access/

[Joveice]

1 minute ago, MagnesiumPC said:

Oh. 

 

http://www.gotomypc.com/remote-access/

No... I have a Program on my Computer that needs access to my server's Database.

My Computer is 30 Cm away from me, the server is 7 M away from me.

[Guest]

Just now, Joveice said:

No... I have a Program on my Computer that needs access to my server's Database.

My Computer is 30 Cm away from me, the server is 7 M away from me.

Just setup a network share then. 

[Joveice]

1 minute ago, MagnesiumPC said:

Just setup a network share then. 

The program connects to MySQL and edit Tables using a user.

I need access to login with a user.

[Guest]

Just now, Joveice said:

The program connects to MySQL and edit Tables using a user.

I need access to login with a user.

Setup a network share.

 

your program should be able to access it through the share.

[Joveice]

Just now, MagnesiumPC said:

Setup a network share.

 

your program should be able to access it through the share.

Isent there a way to access the database other ways? I might move some of my other servers to use it but they are outside my network.

And I would like to be able to use my Program when I'm at school in the freetime

[Guest]

1 minute ago, Joveice said:

Isent there a way to access the database other ways? I might move some of my other servers to use it but they are outside my network.

And I would like to be able to use my Program when I'm at school in the freetime

What program are you using?

[Joveice]

5 minutes ago, MagnesiumPC said:

What program are you using?

Custom program that basicly just connects to it and uses a GUI (kinda like phpmyadmin)

https://rocketmod.net/viewtopic.php?f=39&t=862

Tryed to do this tut http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

[Guest]

5 minutes ago, Joveice said:

Custom program that basicly just connects to it and uses a GUI (kinda like phpmyadmin)

https://rocketmod.net/viewtopic.php?f=39&t=862

So why won't a network share work then?

[Joveice]

1 minute ago, MagnesiumPC said:

So why won't a network share work then?

I'm not trying to share a folder

[colonel_mortis]

Open /etc/mysql/my.cnf and find the line that says

bind-address           = 127.0.0.1

Change 127.0.0.1 to the internal IP address (192.168.*) of that server, or 0.0.0.0, and restart mysql (sudo service mysql reload). Make sure you have a password set, because anyone on the network will be able to access it.

[Guest]

2 minutes ago, Joveice said:

I'm not trying to share a folder

You are trying to access a database.....

 

And from what I can tell, the .sql file is what you want to changes.

[colonel_mortis]

Just now, MagnesiumPC said:

You are trying to access a database.....

 

And from what I can tell, the .sql file is what you want to changes.

Databases aren't stored in .sql files, and they can't just be edited remotely. You have to connect to the mysql daemon and run the SQL commands through there.

[Guest]

2 minutes ago, colonel_mortis said:

Databases aren't stored in .sql files, and they can't just be edited remotely. You have to connect to the mysql daemon and run the SQL commands through there.

Yeah I generally never use SQL...

 

oops.

[Joveice]

Actually this dident work compleatly, I could connect to it no problems there, Tho now when i whent to phpmyadmin i couldent log in

so I reverted the changes restarted and I still cannot log in

[colonel_mortis]

5 minutes ago, Joveice said:

Actually this dident work compleatly, I could connect to it no problems there, Tho now when i whent to phpmyadmin i couldent log in

so I reverted the changes restarted and I still cannot log in

What did you set it to? 0.0.0.0 should work, though it's possible that the actual IP address might not (it does for me though).

You did remember to restart mysql, right?

[Joveice]

Just now, colonel_mortis said:

What did you set it to? 0.0.0.0 should work, though it's possible that the actual IP address might not (it does for me though).

You did remember to restart mysql, right?

Yea I set it to 0.0.0.0 and then restarted. found out that I couldent log in with phpmyadmin so I set it back to 127.0.0.1 and restarted and still cannot cannot log in

Tho the program worked with 0.0.0.0 but phpmyadmin stopped working