Re: iTools MySQL problem

[Glenn A. Bookout <gblists@xxxxxxxxxxxxxxxxxxx>]

Dan:

On 07/25/2002 13:19 USA PT (-0800), dan@xxxxxxxxxxxx ( Dan Tappin ), 
wrote...

>I installed the Tenon MySQL package I am am completely lost on how to get
>access to mysql?
>
>I installed mysql from an other source on a different system and I can't
>seem to make heads or tails of this.
>
>I just need to create a admin user with full privileges from any system so
>that I can use MacSQL to administer the databases.
>
>When ever I try to connect I get:
>
>error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
>type errors.
>
>This hurts my brain!
   A very common problem w/ MySQL setups these days.  I'm currently in 
the process of setting up/learning MySQL and PHP, so I've been making a 
few notes.

   If are using terminal locally, and you can get into the MySQL DB at 
all, try these from my gathered list of setup items:

=============
13. Set password for the root-user:
      /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password'
     /usr/local/mysql/bin/mysqladmin -u root -h localhost -p password 
'new-password'
     NOTE: I've consistantly had problems w/ the above cmds., so the work 
around is:
           a) connect to mysql:
                  mysql -u root -p
                  { enter password }
           b) pick db, delete all users:
                  use mysql;
                  delete from user;
           c) check results:
                  select * from user;
           d) should get:   Empty set (0.00 sec).
           e) re-add all users ( for ease-of-use copy copy/paste each
              line FROM 1st non-space char. TO CR ):
                  GRANT ALL PRIVILEGES ON *.* TO root@localhost
                  IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
                  GRANT ALL PRIVILEGES ON *.* TO root@"%"
                  IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
                  GRANT ALL PRIVILEGES ON *.* TO mysql@localhost
                  IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
                  GRANT ALL PRIVILEGES ON *.* TO mysql@"%"
                  IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
           f) check results:
                  select * from user;
           g) should be fine now showing two each entries for root and 
mysql.
=============

   I don't remember what I did if you can't get any access, like:

>error: 'Access denied for user: 'root@localhost' (Using password: NO)'

   But, here I think that it's saying the current passord is "NO".  Not, 
sure though, but playing w/ the options on the MySQL startup line ( maybe 
just  >mysql -u root ) should at least get you in so you can work the 
above.

   If you would like a copy of my complete BBEdit cheat file and notes on 
MySQL/PHP, drop me a private msg. and I'll forward it to you.

   Hope that helps.

Glenn
---------                                ---------
Tenon Intersystems' iTools Mailing List
To unsubscribe:  send mailto://itools-
request@xxxxxxxxxxxxxxx
with the subject: unsubscribe
Find searchable mailin list archives at:
http://itools.blackpepper.co.nz