Topic: Remote access to MySQL on SME 5.6

[rishi]

Hi All,

I have had a search through the forums on this topic but haven't uncovered a solution that works for me. I am running:
SME server 5.6
phpMyAdmin 2.4.0
MySQL 3.23.29

I can administer my database with phpMyAdmin and can use the database with PHP pages I have written. But, I want to be able to use a database GUI (like Aqua Data Studio http://www.aquafold.com ) to connect to the database from other machines on the local network or remotely, while I am developing my web application. I have tried the suggestion on this thread:

http://forums.contribs.org/index.php?topic=20457.msg83524#msg83524

particularly:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/rc7.d/S90mysqld restart

but still no luck. I can't even connect with the MySQL Control Center software from a machine on the local network.

Can anyone help me out or point me in the right direction?

Thanks in advance,
Rishi.

[gbaird]

Hello

I have had the same problem and used the

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/rc7.d/S90mysqld restart

I had to run all of the commands twice before I got it to work then I can use mysqlcc to do whatever I need to and it always works make sure you add a user
with phpmyadmin that has access from % that is all addresses and has all permissions

hope this helps

[rishi]

Thanks for that, but still no luck. I tried running those commands through twice, but still can't connect.

I have checked with phpMyAdmin and I definitely have a user added, with access from host % and global privaleges (to select, insert and update). Any other ideas?!

 

[Anonymous]

hello

in your mysqlcc program use

the ip address of the server you want to connect to
enter your username & password leave all the rest as is
then test the connection

what is the message you get ie:

connect to host
bad user or password

I have used it alot with no problems but always
just use the ip address of the mysql server
windows & linux both work with mysqlcc

[rishi]

Hi.

I've just tried to connect from my windows machine to MySQL on the SME server through our local network using mysqlcc, using the servers direct IP. Here is the error message I get:

ERROR 2013: Lost connection to MySQL server during query

This seemed strange, not like an authentication error, more like a MySQL server drop out. I decided to check the logs...

Looking in /var/log/mysqld.log I found the following message:

Number of processes running now: 1
mysqld process hanging, pid 947 - killed
040331 16:07:05  mysqld restarted
/usr/libexec/mysqld: ready for connections

Is this supposed to happen? This looks bad... is there something wrong with my MySQL setup? It seems to work fine using phpMyAdmin, phpBB and webmail... which are using MySQL. Any ideas?

 

[gbaird]

Hello

I have seen the same thing before it was caused by mysqlcc
what I found was that my login was not accepted

Using phpmyadmin can be a little tricky I have noticed that
not all of the time adding users works that well

I have had to add the user then go back through the user
edit and reset all permissions and password make sure
to check that the user has access to the databases you want them to

Greg

[Anonymous]

Try turning off your windows firewall and give it a try.

Then of course turn the firewall on again.

[allun]

Hey Guys,

did you ever fix this problem?

I had the same thing - the solution was to remove the "skip-networking" line from /etc/my.cnf

If the line is there, mysql will only accept connections from localhost!

HTH

Allun

[bpao]

hello,

i try(as you) to connect , on local lan, with mysql (sme5.6).

after 3 months of test, check ... no thinks

i try with the last sme version .. it's work !

result , 2 solutions :

- upgrade of mysql
- upgrade of SME
 
 

[seabro]

guys,

i had this problem for ages and i am not alone. i wanted to connect remotely to do a mysqldump everyday.

anyway, after trying some suggestions from this forum that didnt work i poked around on the net and found MY answer which may work for you.

i added the ip and hostname of my remote windows box to /etc/hosts and then it worked.

now i know because of the e-smith templates thing my entry will probably disappear when i reboot but all i need to do now is find out how to make it permanent which is a smaller job!

good luck

seabro
sb@@networkdataDOTcoDOTuk