Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
config mysql user
Name: gvm9999 Date: January 25, 2005 at 13:24:45 Pacific OS: Win XP SP2 CPU/Ram: 2GHZ
Comment:
I installed mySQL on my local webserver. I created a user in the 'user'-table from the 'mysql'-database by adding a record.
But you have to specify the host. How can I configure a user that can be from anywhere?(not only localhost or IPs from the local web).
Name: Michael J (by mjdamato) Date: January 25, 2005 at 22:49:13 Pacific
Reply:
Hmmm... Not following you. When I am creating user accounts for MySQL, they are accounts that will be used by my applications to access the database - they are not accounts that I am using to access the database. For example if your application will be running on the same server as the database, then the host would be localhost.
Michael J
0
Response Number 2
Name: gvm9999 Date: January 26, 2005 at 01:12:27 Pacific
Reply:
yes,but what if I want that people within the network can get access to it?
Can I leave the "Host"-field empty so everyone can for example read from the database but cannot change anything?
If its not already broke,it will be later!!!
0
Response Number 3
Name: gvm9999 Date: January 26, 2005 at 01:13:12 Pacific
Summary: well i took the mySQL book back to the library which told me how to create users and stuff so i dont know any of that. this is what i have in this config file which im sure is being executed each time...
Summary: The ideal solution here is to use ASP.NET windows authentication. If the user is using IE and is logged in to the domain, ASP.NET and IIS do all the work for you. You can specify allowed users in a ...
Summary: It looks pretty good to me...I connect fine to mysql in a .NET application, but my connection string looks a bit different: ConnectionString = "SERVER=localhost;user id=uidhere;password=pwhere;databas...
0 
