I'm new to MySQL, and just installed the latest production release on Win 2K. I have a few questions on users and privileges, please help me understand.
First, when MySQL starts as a service, what user and password does it use to access the database? I created a MySQL account, should I change the MySQL service properties to use that account? Or leave it using "Local System account"? I installed MySQL while logged in as Administrator. When logged in as Administrator, I can start winmysqladmin, and it comes up with a green light. When I log in as any other user, I get a red light, even when I have added that user to the mysql/user table with a GRANT ALL. How can I get it to come up with a green light for a normal user? I know the MySQL server is running because I can telnet to localhost 3306 and see the MySQL version number pop out. I removed the "user=" and "password=" entries from the my.ini file, because I didn't like seeing a password exposed in plain text. This seemed to have no effect on MySQL at all. What are those entries for? Do I need them? What should they be? The MySQL account name and password? Thank you. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 --------------------------------------------------------------------- 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
