Hi, Shanta I do have a 'my.cnf' in 'c:\windows' dir, and it's called 'my.ini' in WinMySQLadmin. As I mentioned early, the ONLY user and password in 'my.cnf' is: user=alan, password=alan.
Wait, this is amazing! (I just gave it another try) After about 6hrs, it works now!!! Now only 'alan' can log in and others can NOT!!! :-) Is it because that I restarted the computer just now and that makes the *changes* valid? --- at least for Windows? cheers, feng It seems that when I install MySQL server, some ----- Original Message ----- From: "Thada, Shantalaxmi (NIH/CC/PET)" <[EMAIL PROTECTED]> To: "'Wang Feng '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 05, 2003 5:57 AM Subject: RE: mysql account > > do u have a .my.cnf in c:\ dir or c:\windows dir ? from DOS when > u issue a mysql command it usually picks up the username and password from > the .my.cnf file. > > - Shanta > > > -----Original Message----- > From: Wang Feng > To: [EMAIL PROTECTED] > Sent: 10/4/2003 2:35 PM > Subject: mysql account > > Hi, folks. > > I use WinXP + MySQL. > > I deleted all the rows from the 'user' table of the 'mysql' database > except > my own account (host: localhost, user: alan, password:alan). --- I was > hoping only I have the access to the MySQL databases. > > The problem is that I still can login to MySQL by the DOS command: > 'c:\mysql\bin\mysql' without the '-h localhost -u alan -p' followed. > (NOTE: > MySQL was installed under the c: drive) > > And even the 'c:\mysql\bin\mysql -h localhost' and 'c:\mysql\bin\mysql > -h > localhost -u root' *work* too!!! Terrible!!! > > (BTW, in the 'my.ini' file, the user=alan, password=alan.) --- But I > don't > think this is important as all of the user info are stored in the 'user' > table of the 'mysql' databse. Right? > > > What am I gonna do? Please advise. > > > cheers, > > feng > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
