Re: VB6 + MySQL

Hi Nuno,

Nuno Vaz Oliveira wrote:
> Hello Shawn,
>
> Thanks for the reply...
>
>> Hello Nuno,
>>
>> My responses are intermingled below...
>> <snip>
>> "Manage users" is a vague term. Do you mean:
>> a) manage MySQL database login accounts
>> or
>> b) manage application user information
>
> What I mean is to have the possibility to add a new user to the MySQL
> database system (the same way I can with PHPmyAdmin).
> This way I could program a User Managment System and use only my app.
> I'm not talking about users to my application. That is programmed and
> stored in a table. I'm talking about users of MySQL so that I can connect
> to MySQL as 'root', 'admin' or other user that I might want to create.
>
Yes, assuming that the account you are connecting with has at least 
SUPER privileges, you can issue any of the commands needed to affect 
login accounts and their privilege settings
http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html


>> You can backup the DB but this is generally not an action performed by
>> client applications. There are number of methods available for backing
>> up a MySQL server. A good place to start reading for ideas would be:
>> http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html
>
> I'll probably agree with you when you say thet client applications 
> shouldn't
> perform any backup operation. However, as far as I know, to do a SQL
> dump I need to be at the server. In this case, the server is in one of 
> our
> company's offices but not the one I work at. In that case how can I do
> a weekly backup?
>
The backup utility "mysqldump" can be run against any MySQL database it 
can reach. All you need to do is to specify the necessary --host and 
--port options when you call the program.  The presumes that the login 
account you are attempting to connect with will have the privileges to 
login from an outside address.

>>>
>> Yes, the ODBC drivers support SSL connections. This is harder to setup
>> on Windows systems as they typically are not shipped with the same set
>> of SSL tools as Linux systems but it is possible and has been tested.
>>
>> Other options for encrypting network transfers:
>> * a VPN connection from the client to the server
>> * an SSH connection between the client and the server.
>
> I was thinking that using the ODBC driver SSL (or other encryption)
> method was not possible. It's great that is does but... It's hard to
> configure and for now I think I will just implement all the funcionality
> I need. After that I will think about that. Just a couple of question...
> Do I need to program the encryption along with my app or can it be
> implemented at any time? Do the client computers need any additional
> software?
>
AFAIK, the ability to use an SSL certificate is built into the ODBC 
drivers. However the production of those certificates are not natively 
supported on Windows without 3rd party software. You can generate your 
certs on a central machine and distribute them with your application 
then tell your drivers to use your certs during the connection phase. 
Again, I have not had a lot of experience using SSL on Windows but IIRC 
it was the generation of the certificate files that took me the longest 
to get correct.
>> <snip>
> Thanks for the info and the links. I really appreciate. :)
>
Any time!

-- 
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN

Are you MySQL certified?  www.mysql.com/certification
     __  ___     ___ ____  __
    /  |/  /_ __/ __/ __ \/ /   
   / /|_/ / // /\ \/ /_/ / /__  
  /_/  /_/\_, /___/\___\_\___/   
         <___/   www.mysql.com


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]