I am a newbie to the mySQL world and am having some difficulties with it. I am running a Win2K network (Win2K Pro, Win2K Adv. Server) using TCP/IP. I loaded mySQL on both a server and a workstation. I was able to get the server going (mysqld-nt --install, net start mysql), and was able to log into the server from my workstation (mysql.exe -h webserver -u administrator). I was able to see the databases (show databases;). I went out to the web and started poking around for a GUI client program. I loaded and tested a whole bunch of them, but my favorite was mySQL Front. I was able to load it, log in to the "Test" database, create tables, and everything else. I loaded a couple of others, but didn't find anything I liked better. I decided to go with mySQL Front. When I retried mySQL Front, I could no longer access the database. I was still able to access it, however, from mysql.exe (mysql.exe -h webserver -u administrator). I bought the Paul DuBois book, and started combing through it. I found something that sounded like it made sense - permissions. I tried shutting down the server, and then restarting it using "mysqladmin --skip-grant-tables", but the NT Command Processor just hangs when I issue this command. Now I have this thing so messed up, that I cannot log into the server at all except locally. What am I doing wrong??? Thanks! Greg Miller, IS/Development SantaPlus --------------------------------------------------------------------- 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
