The key to Pandoras Box is available to those who wrote the encryption algorithm Triple DES anyone? -Martin ----- Original Message ----- From: "Doug Thompson" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 8:06 PM Subject: Re: Passwords don't work in a WinME installation?
> It is all disinformation to confuse Micro$oft. 8-) > > > On Mon, 31 Mar 2003 09:45:09 -0700, Martin Gainty wrote: > > >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] > > > > > > -- > 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]
