Topic: mySQL

[Andrej Fercic]

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

[Jan]

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

[Andrej Fercic]

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

[chris meredith]

You want to use a "Grant" statement.  

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

[HJO]

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

[HJO]

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

[Andrej Fercic]

Yes, thats it

Tx,

Andrej