Re: iTools MySQL problem

Dan,

I'd recommend using:

../mysql -p -u root

If you don't specify the -p option, MySQL won't prompt you for a password
and it will try to log you in without one.  Since you _do_ have a password
on the account, that would explain why it keeps telling you "permission
denied".

Hope this helps,

Erik.

On Mon, 29 Jul 2002, Dan Tappin wrote:

> > Dan,
> >
> > You meant "SELECT" instead of "SLECT", right?
>
> Opps... Yes :^)
>
> > The error that you experienced below "Can't connect to local MySQL..."
> > typically occurs when the MySQL server is not running but access is
> > attempted.
>
> It is running though.  I can run ./mysql test or ./mysql -u root
>
> And I can get into mysql with out a password.
>
> If I try to set the admin password via the Aqua tool mysqladmin I get the
> sock's error.
>
> Dan
>
> > Make sure that the MySQL is running by checking the Process Viewer or "ps
> > ax |grep mysql" on the command line.
> >
> > If MySQL is not running, use the "safe_mysqld" command to start it.
> >
> > Hope this helps,
> >
> > Erik.
> >
> > On Mon, 29 Jul 2002, Dan Tappin wrote:
> >
> >> I can get into mysql and the mysql tables are there (SHOW TABLES) but if I
> >> run a SLECT I get a 'no table' error.
> >>
> >> I have uninstalled and re-installed this package a few times.  I think 
> >> there
> >> is something wrong with it.
> >>
> >> I run the installer and then I run the iTools MySQL app.  It initializes 
> >> the
> >> DB's and asks for an admin password.  I enter only the new password as
> >> directed and I get:
> >>
> >> error: 'Can't connect to local MySQL server through socket 
> >> '/tmp/mysql.sock'
> >> (2)'
> >>
> >> I have e-mailed Tenon but I have yet to get a response and I am looking for
> >> other users who have seen the same thing.
> >>
> >> Thanks,
> >>
> >> Dan
>

-- 
Erik Lotspeich                          Lead Engineer
Tenon Intersystems                      erik@xxxxxxxxx
1123 Chapala Street Ste 200             805-963-6983
Santa Barbara, CA 93101-3142            http://www.tenon.com/


---------                                
---------
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.