Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Craig on September 03, 2003, 09:47:12 PM

Title: MYSQL Rwmote Connection
Post by: Craig on September 03, 2003, 09:47:12 PM

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

Title: Re: MYSQL Rwmote Connection
Post by: Warren Blackbeard on September 03, 2003, 10:21:28 PM

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

Title: Re: MYSQL Rwmote Connection
Post by: Rod on September 04, 2003, 11:07:37 AM

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.

Title: Re: MYSQL Rwmote Connection
Post by: James Douglas on September 06, 2003, 08:31:11 PM

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?

Title: Re: MYSQL Rwmote Connection
Post by: Paul T.C.Fung on September 08, 2003, 11:41:50 PM

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