HOW TO USE VB TO REMOTELY OPERATE MYSQL DATABASE PROGRAMS OUT OF THE ENVIRONMENT

You can extract the ,,put it in a self-extracting file, and set the self-extracting to system32

Write a registry script that reads as follows:

windows

registry

editor

version

hkey_local_machine\software\odbc\driver]

usagecount"=dword:00000001driver"="c:\\windows\\system32\\"

setup"="c:\\windows\\system32\\"

The first time you run it, you can call it.,Mine is to put the VB runtime library in.,The total size is about 2M.,It's easy to use.,No installation interface appears.。

I've been bothered about this problem before, and it hasn't solved the problem, if your program is small, maybe the method you are pursuing now will be very good, if it is a relatively large program, multiple files are not a convenient solution, it depends on your own choice. If you succeed, don't forget to inform your little brother.

You're not packing all of your dynamic link libraries into it! Use the "Setup Factory 7" software to package it into an exe installation file, and then install the exe file on another computer!

This is the reason for the lack of control, because the program uses the MySQL control, but if it is not available on other computers. It can't be called, resulting in an error.

Workaround: (Take Microsoft ADO Data Control as an example).

2.Make a copy of this file and put it with your program.

3. Enter in the initial area of the program (take the control name, form load event as an example).

shell " /s " & "", vbhide

Note that this control is in the same directory as your program.

If not, it should be: shell" /s " & "The absolute path of the widget (preferably no spaces in the path).", vbhide

Please use VC as DLL to access the MySQL database directly, which is called by VB.

Save the password in the software, of course, it is not safe, it is necessary to make a program on the server to process, the program only transmits unimportant items once, for example: the user who buys the No. 2 product is naylance, so pass the server user: naylance, item id=2, let the server do the calculation, save it locally, 100% will be intercepted, such as:

Decompile, update the command after wpe captures the packet (because the database password is saved, you can execute any command, unless you give low account permissions, but you can definitely read and write normal data, right?) If you replace the password with *, so that the user can see it, this is even more insecure.

MyQL is CS mode, that is, client-server mode, without a client, you can't connect to the server.

Do you want to connect to someone else's MySQL database?

Sweat. You don't have a database?

This problem is easy to solve, you don't need to type mysql commands. If you don't have a database, what kind of mysql command do you type?,I don't understand.。

The remote connection is the same as the local connection, and the remote needs to write the IP address.

If you need to install a support file, you can't run it. Just like the .net program needs to be installed on the computer. net fromwork as well!

It's not that it's not installed. ，.Nothing to do with the problem! Your problem is that the database doesn't have backlinks.

What's wrong?

Is it the reason why remote mysql does not allow remote connections?

You can try it out as follows.

First, go to mysql:mysql -u root -p password:**

Then you can go to the MySQL database and view the user table in it.

Run the following command: use mysql;

select host,user from user;Here you can see +--host | user |+root ||localhost | debian-sys-maint ||localhost | root ||namenode | root |+The bold part is to update this to %, i.e. all addresses can be accessedupdate user set host='%' where host=''Quit.

Then open the file in the mysql directory and find it.

bind-address = Change to the IP address of your server to save and exit, restart MySQL, OK, and you can log in remotely.