Koozali.org: home of the SME Server

Acces Mysql

roberto

Acces Mysql
« on: October 21, 2003, 02:09:08 AM »
I can access Mysql from any windows computer inside my network, but connection is refused from my home computer...
How can i manage to do it?, I have SME 6.0b3

Arno

Re: Acces Mysql
« Reply #1 on: October 21, 2003, 11:03:25 AM »
how u wanna acces it?
with phpmyadmin?

Did u tried

https://mydomain/phpmyadmin/

roberto

Re: Acces Mysql
« Reply #2 on: October 21, 2003, 01:10:26 PM »
upps sorry maybe i didn't explain it...
What i need is giving MySql access to a partner website allocated outside my local intranet... inside our network we can access from one server to the e-smith mysql but if i put the server at the other office it fails

Arno

Re: Acces Mysql
« Reply #3 on: October 21, 2003, 06:11:39 PM »
when u connectr 2 the mysql dbase
do u use the ip adres of ur server or ur domain?

roberto

Re: Acces Mysql
« Reply #4 on: October 21, 2003, 06:48:13 PM »
it doesn't work neither with the ip nor the domain name. in the same network i connect using both local name or local ip

roberto

Re: Acces Mysql
« Reply #5 on: October 21, 2003, 06:48:56 PM »
by the way arno, thanks for your help ;)

Arno

Re: Acces Mysql
« Reply #6 on: October 21, 2003, 07:49:48 PM »
erm it still dont work right?

roberto

Re: Acces Mysql
« Reply #7 on: October 21, 2003, 08:34:59 PM »
no, it doesn't work

Ray Mitchell

Re: Acces Mysql
« Reply #8 on: October 22, 2003, 12:51:35 PM »
When you instal phpmyadmin (e-smith-phpmyadmin-2.5.0-5dmc.noarch.rpm from contribs.org) it quite clearly says

"To access the MySQL functions via a web interface
you will have to access it via SSL in your web browser.

For example: https://192.168.1.1/phpmyadmin"

I just did it and connected using https://mydomain/phpmyadmin

I also tried establishing a VPN connection, and then in a browser entered an IP style URL (as above) https://192.168.1.1/phpmyadmin

Then
Enter your admin username and password
Voila, you have phpmyadmin

Regs
Ray

roberto

Re: Acces Mysql
« Reply #9 on: October 22, 2003, 01:40:49 PM »
Emm... I can Acess By PhpMyAdmin. But i need to connect a remote php server to my mysql server in e-smith
I really want to thank you for your help, but we are getting misunderstood...

andrej

Re: Acces Mysql
« Reply #10 on: October 22, 2003, 04:05:51 PM »
Connect those two server using VPN. Remote server will threaten as local one.