Topic: UrbanSql Editor with e-smith

[Gwenaël]

I Try to use UrbanSql Editor on remote station but the access is locked.
How can i access from a microsoft (2000, 98, ME)  station to my Database in secure connection (server connected to internet)?

I like phpMyadmin but i want to use Urban.

Can you help me?

Thanks a lot,

Gwenaël

[Darrell May]

Gwenaël wrote:
>
> I Try to use UrbanSql Editor on remote station but the access is locked.
> How can i access from a microsoft (2000, 98, ME)  station to my Database in
> secure connection (server connected to internet)?
>

OK, some basics.  You need to download and install the mysql odbc driver myodbc-2.50.37-nt.zip and set up via Control Panel > ODBC Data Sources, your database(s) information.

Next you would establish a VPN connection to your e-smith server and open the UrbanSql utility.  Choose one of your databases via the alias drop down box and select Connect.  This will result in an error saying Access Denied for user 'someone@hostname.somewhere.com' which is actually your Windows pc host name as far as the UrbanSql utility is concerned.  What you need to do via the e-smith command line is grant your pc access to the mysql database.

So for instance if the error responded with:

Access denied for user 'gwenael@pc-00065.cyberwork.be' you would need to do something like this logged in as root on the e-smith server:

mysql
mysql> grant all on *.* to 'pc-00065' identified by 'password';

Which says grant full access to every database from computer 'pc-00065' using the password 'password'.

Hope this helps,

Darrell

[Dan Brown]

> mysql
> mysql> grant all on *.* to 'pc-00065' identified by 'password';

This won't do what you say, IIRC.  What this will do is grant all privileges to a _user_ called pc-00065.  I think what you'd want would be "grant all on *.* to fred@pc-00065 identified by 'whatever';".  Of course, "fred" can be anything there.

[Darrell May]

Dan Brown wrote:
>
> > mysql
> > mysql> grant all on *.* to 'pc-00065' identified by
> 'password';
>
> This won't do what you say, IIRC.  What this will do is grant
> all privileges to a _user_ called pc-00065.  I think what
> you'd want would be "grant all on *.* to fred@pc-00065
> identified by 'whatever';".  Of course, "fred" can be
> anything there.

Actually Dan in this instance you may not realize that UrbanSQL requires the computer to connect, not the user, so pc-00065 is the computer name, as identified directly from UrbanSQL.  I could have used pc-00065.netsourced.com to be more precise.

Regards,

Darrell