Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Andrej Fercic on July 31, 2002, 03:04:37 PM

Title: mySQL
Post by: Andrej Fercic on July 31, 2002, 03:04:37 PM

1. Can I make connection to mySQL server from LAN or is disabled by default?
2. How can I change - alow connection for ROOT for specified IP address ???

Tx,

ANdrej

Title: Re: mySQL
Post by: Jan on July 31, 2002, 06:52:30 PM

Andrej,

I think I can answer your first question. You can access it by means of Putty but first you need to enable ssh access with the server-manager.

The second question I have no answer for you ... :-(
Maybe someone else has one... you might search the devinfo mailinglist.

Hope this helps.

regards,

Jan

Title: Re: mySQL
Post by: Andrej Fercic on July 31, 2002, 07:05:08 PM

I think I can answer your first question. You can access it by means of Putty but first you need to enable ssh access with the server-manager.

The second question I have no answer for you ... :-(
Maybe someone else has one... you might search the devinfo mailinglist.

Hope this helps.

regards,

Jan


RE: Yes I know that, TX anyway. I wan to use mySQL-Front a great TOOL for managing mySQL server (I am using it on my W2k servers with mySQL for quite a time), but first you must have an account which has rights to access the server from the network !!! Becouse I am NOT mySQL command promt USER, please help me with those two lines which will grant ROOT to access mySQL server from lokal net or specified IP !!!

Tx,

Andrej

Title: Re: mySQL
Post by: chris meredith on July 31, 2002, 07:14:11 PM

You want to use a "Grant" statement.  

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management

Title: Re: mySQL
Post by: HJO on July 31, 2002, 10:10:35 PM

Maybe the best way to do this is to install an contrib from Darell May, which can be found on http://myezserver.com/downloads/mitel/contrib/phpmyadmin-2.2.3/ hopefully this is what you're searching for.

Good Luck,
Hans

Title: Re: mySQL
Post by: HJO on July 31, 2002, 10:10:41 PM

Maybe the best way to do this is to install an contrib from Darell May, which can be found on http://myezserver.com/downloads/mitel/contrib/phpmyadmin-2.2.3/ hopefully this is what you're searching for.

Good Luck,
Hans

Title: Re: mySQL
Post by: Andrej Fercic on August 01, 2002, 01:01:41 AM

Yes, thats it ;)

Tx,

Andrej