SOLVED:RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
error "1045: Access denied for user ' [EMAIL PROTECTED]' (Using password: YES) when trying to connect" When I log into mysql - user#mysql -u user -p password - I connect fine. Does anyone have any suggestions?? thanks, tait tait sanders computer support technician element IT ser

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
. so does anyone know what could be the problem with the password here? I really want to include the password in the script as I don't want to be prompted for it at say 3 in the morning when cron runs it. thanks, tait tait sanders computer support technician element IT services informa

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
yes the user can see the databases with 'show databases;' I was thinking that there might be a permissions issue... but it doesn't seem so. thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith university 97

mysqldump access denied error

2005-01-17 Thread Tait Sanders
ysql - user#mysql -u user -p password - I connect fine. Does anyone have any suggestions?? thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 5

Re: mysqldump error

2004-03-21 Thread tait sanders
: mysqldump -uuserid -ppassword --add-drop-table mtweblog > BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17

mysqldump error

2004-03-21 Thread tait sanders
denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect". when i log into mysql and do 'mysqldump --opt mtweblog > BckUpmtweblog.sql;' it gives "Error: 1064: You have an error in your SQL syntax." can anyone help me to dump this da

Re: can't install DBI on panther

2004-01-27 Thread tait sanders
Folly wrote: On 27 Jan 2004, at 00:37, tait sanders wrote: i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back reporting heaps of errors like the following: "from Perl.xs:1: /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 380:30

Re: can't install DBI on panther

2004-01-26 Thread tait sanders
.lo anywhere, but I'm not sure what this means. I find gd_jpeg.Plo in the .deps directory. I'm sorry, I don't know what a .Plo or .lo file is. The .Plo file just contains "#dummy". This is a bit off-topic from mysql or the original question, I'm afraid. tait

can't install DBI on panther

2004-01-26 Thread tait sanders
error: parse error before "int_least32_t"" etc etc etc this just goes on and on... what am I to do to get DBI installed on my OS10.3?? please help ta tait On 22/01/2004, at 5:42 AM, Moritz von Schweinitz wrote: i've never used MT, but this kinda sounds as if yo

unsupported driver trouble

2004-01-20 Thread tait sanders
g the following error: "Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC..." I've checked in my mt.cfg file and I have added: "ObjectDriver DBI::mysql Database /var/mysql/mtweblog DBUser labadmin" so I don't understand what's going on.

mysql will not start

2004-01-18 Thread tait sanders
the DNS name. i.e. 'media' instead of 'media.arts.unsw.edu.au'. The article goes on to explain that this 'prevents the database from being created'. It has the fix. just wanted to post it here as someone might find it useful. ta tait tait sanders computer technici

Re: newbie - connect error

2004-01-15 Thread tait sanders
d the mysql.sock and used 'mysql_config --socket' to recreate it. this produces a new mysql.sock but then trying to start mysql produces the error of before. can i uninstall mysql rather than deleting it. I've tried the 'rpm' utility but it's not on my os. thanks heap

Re: newbie - connect error

2004-01-15 Thread tait sanders
ermissions or directory locations). For this go to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: Hi, I'm a newbie to

newbie - connect error

2004-01-15 Thread tait sanders
mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw