Great! any links to working examples would be greatly appreciated! Thanks! Martin ----- Original Message ----- From: "Michael Shulman" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 10:02 AM Subject: Re: Passwords don't work in a WinME installation?
> We are using it on Windows 2000 and Windows XP. But it doesn't seem to be > tied in to the Windows security system, so it should work the same on WinME. > > -ms > > ----- Original Message ----- > From: "Martin Gainty" <[EMAIL PROTECTED]> > To: "Michael Shulman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Monday, March 31, 2003 8:45 AM > Subject: Re: Passwords don't work in a WinME installation? > > > Michael et al- > I am trying to locate ONE working MySQL example for windows. Is this a myth > or is there WORKING source example out there somewhere? > Thanks, > Martin > ----- Original Message ----- > From: "Michael Shulman" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, March 31, 2003 9:24 AM > Subject: RE: Passwords don't work in a WinME installation? > > > Start reading here: > http://www.mysql.com/doc/en/Privileges.html > > and read to 4.2.10. > > Two tips I found useful: > 1. The current_user() function tells you what MySQL user name it thinks that > you are. This can be used to verify if you are an authenticated user. > mysql> SELECT current_user(); > > 2. Remove unneeded rows from the user table. For my installation, I removed > all rows except 'root' logging in on the local machine: > > mysql> use mysql; > mysql> delete from user where user != 'root'; > mysql> delete from user where host != 'localhost'; > mysql> flush privileges; > mysql> select user, password, host from user; > +-----------+-----------+------------------+ > | user | host | password | > +-----------+-----------+------------------+ > | root | localhost | xxxxxxxxxxxx | > +-----------+-----------+------------------+ > 1 row in set (0.00 sec) > > If you have a line that has an empty username or % for hostname, this will > make diagnosing your security issues difficult. > > -ms > > > > > > -----Original Message----- > From: Helge Moulding [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 30, 2003 11:02 PM > To: [EMAIL PROTECTED] > Subject: Passwords don't work in a WinME installation? > > > I'm learning the ropes with MySQL. I've got it installed on a WinME > > system, and one of the first things I've noticed is that it doesn't > > seem to care about users. Is that correct? In particular, I've tried > > out the GRANT command to create a new user, but MySQL doesn't seem > > to recognize the new user. Here's what happens: > > > > C:\Program Files\mysql40\bin>mysqld > > > > C:\Program Files\mysql40\bin>mysql > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 1 to server version: 4.0.12-max-debug > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> create database dummy; > > Query OK, 1 row affected (0.44 sec) > > > > mysql> grant select on dummy.* to [EMAIL PROTECTED] identified by 'blah'; > > Query OK, 0 rows affected (0.28 sec) > > > > mysql> quit > > Bye > > > > C:\Program Files\mysql40\bin>mysqladmin flush-privileges > > > > C:\Program Files\mysql40\bin>mysql -u dumdum -p dummy > > Enter password: **** > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > C:\Program Files\mysql40\bin> > > > > I've tried to be very careful to make sure that the password is correct :-) > > I don't know if the fault lies in using "localhost" instead of "127.0.0.1" > > for the host part of the user. I'd have thought that "localhost" and > > "127.0.0.1" would be synonymous... > > > > However, if I try to mess with any kind of passwords, I get difficulties. > > For example, I don't get to set a password for root: > > > > C:\Program Files\mysql40\bin>mysqladmin -u root password temp > > > > C:\Program Files\mysql40\bin>mysql -u root > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 6 to server version: 4.0.12-max-debug > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> > > > > Notice that mysql let user root in without asking for a password, even > > though I used mysqladmin to set a password. (In the book I'm using, > > "MySQL Visual Quickstart Guide" by Ullman, the password is supposed to > > be in single quotes, but in the mysqladmin help output, there are no > > quotes. I've tried it both ways, and neither has the expected effect.) > > > > I used winmysqladmin, which prompted me for a user name and password. > > But mysql lets me in without giving a password for that user, either. > > > > For that matter, mysql will let in any user, even if they haven't been > > created by any method I know of: > > > > C:\Program Files\mysql40\bin>mysql -u nooneknowsme > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 9 to server version: 4.0.12-max-debug > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> > > > > What's going on here? Is the password stuff broken, or is it the fault > > of me working on Windows ME? > > -- > > Helge Moulding > > mailto:[EMAIL PROTECTED] Just another guy > > http://hmoulding.cjb.net/ with a weird name > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > -- > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]