Topic: MYSQL Rwmote Connection

[Craig]

Hi all,

I have searched the forums for answer to to getting access to MYSQL in SME v5.6 as I believe it has been locked. I have a server that has been upgraded from v5.5 to v5.6 and now no longer have access to the database that was being used from windows PC's.

I noticed in one of the replies on the forums from Mitel is that there is a possability of a DB configuration that can be done to allow access to MYSQL....has anybody done this yet or do I need to upgrade mysql?

Thanks in advance.

Regards
Craig

[Warren Blackbeard]

Craig ,

The following rpms are needed  in order to allow remote connections to mysql;
glibc-2.2.5-43.i386.rpm
glibc-common-2.2.5-43.i386.rpm


regards

Warren

[Rod]

Try http://forums.contribs.org/index.php?topic=18070.msg70825#msg70825

Network access now defaults to disabled since 5.6(?) so you need to enable it.

[James Douglas]

im running 5.5 update6 and cannot seem to connect either...can someone provide some info on how to remotely connect/userpass to use/and maybe a tool to test with?

[Paul T.C.Fung]

Can you tell us how to setup the user in the 5.5 box, I have some application running without problem, and I guess it may be cause by some wrong setting when you setup the use in MySQL......  I have the same problem when I first play with some applications.

Try to set up a new use and change the application setting like :
mysql> GRANT ALL PRIVILEGES On DB-name.* to DB-user@192.168.1.123 IDENTIFIED BY "password";
mysql> CREATE DATABASE DB-name;

??

See if this help ?

Best Regards,

Paul T.C.Fung