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]