Thanks for the quick reply Simon! I checked in the file, and just as you said the info was there. No, I actually solved the problem myself shortly after setting up phpMyAdmin from sourceforge.net Top notch little software package there(free too)! For newbies like me, it works out great, hopefully in a few weeks I'll be much more well versed.
Again, really appreciate know the 'real way' to do it! Have a great one! Terry On Wed, 2002-04-24 at 03:18, Simon Green wrote: > Look in db mysql.user to see what users can do what. > GRANT ALL ON *.* TO user@% IDENTIFIED BY "password"; > Simon > > -----Original Message----- > From: Unix Newbie [mailto:[EMAIL PROTECTED]] > Sent: 24 April 2002 10:15 > To: [EMAIL PROTECTED] > Subject: Mysql users setup. > > > > > Hello all! > > I am just starting out with learning mysql and I have run into some > speed bumps that are mostly my configuration. I have set up mysql > running on a Mac OS X box with php running a particular software package > called phpESP. Works great (a bit slow, but great). > > Now, in order to have my system go live the head honchos decided that > my department could not have the mysql database and the webserver on > thes same machine (security reasons). Now I have read some of the docs > regarding doing this, whatever user accesses the database has to have > the IP that it will be coming from set up after the @ symbol. Well, can > I change an existing user to have access from any location, and how > would I see if that is already set up for this user? > > > Sorry for the newbie questions, but docs, urls, or pretty much > anything will get me started thanks so much! > > Terry. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php