Multiple USER using IP? or same Username?

[wacks]

hey guys!

im migrating from MS Access database to MySQL for LAN and WAN programming...

* Is it possible to use the same UserName (like in MSSQL) and Password for one database system?

* My client is in a DSL connection, is it possible to use each IP Addresses of each computer for the same database?


thank u very much! i really need your advices... thnx

 

[steve1]

Your question is very hard to understand, so I will try to cover many possibilities.

You can have many users use the sameuser/ password on the same or different databases, and many users/ passwords on the same or different databases. Each password can be limited to a particular originating system, or many. This can be used as a sort of cheap firewall.

The method of connecting to the network, or even the type of network has no bearing on the ability to use MYSQL. DSL is fine. The server really SHOULD have a fixed IP address. The simplest use of a centralized database is simply using clients pointing to a central system. There IS the ability to use replication though, so you could have several systems that update one another with changes.

I don't believe MYSQL provides any capability for "NT based authentication".

ACCESS, MYSQL, MSSQL, etc... can ALL be on the same system accessed by the same IP address. It does this by using different connection methods and/or different ports. The IP address can be thought of as an address. The port can be thought of as a door. You may be at the same address(same system), but go to a different door(program), and you access a different database.

Steve