Re: ROOT Access Denied !!

2002-06-11 Thread Colin Cooler
Thank you Ray, this worked! Colin on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote: > mysql --password > (or just -p) > > On Tuesday 11 June 2002 7:30, you wrote: >> When I try to connect to mysql as 'root' I get the following: >>> [localhost:/Users/cooldaze] root# mysql >>> ERROR 1045: Ac

ROOT Access Denied !!

2002-06-11 Thread Colin Cooler
When I try to connect to mysql as 'root' I get the following: >[localhost:/Users/cooldaze] root# mysql >ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I can connect as a normal user, but can't create any databases or do other necessary admin functions, so I need to be

Re: Newbie MySQL installation problems (specific)

2002-06-09 Thread Colin Cooler
ors regarding innodb, my guess is > that the server is configured to create inno db tables and not myisam > tables, which is what the default binaries/rpm are configured to do (i.e. > create myisam tables, but they are non-transactional). > > Regards, > Bhavin. > > -

Newbie MySQL installation problems (specific)

2002-06-09 Thread Colin Cooler
Buying Paul DuBois' most excellent book "MySQL" has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep "at risk" kids in school). After running his "cleanup instructions"