SOLVED:RE: mysqldump access denied error
the solution here is that my password contained metacharacters and therefore I needed to include escapes before eac metacharacter like such: /usr/bin/mysqldump -u user -pg/#o/$ogle db > dbBackup.sql this did the trick. thanks all for your help tait -Original Message- From: Tait Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:36 PM To: mysql@lists.mysql.com Subject: mysqldump access denied error I've put together a shell script that is simply - /usr/bin/mysqldump -u user -ppassword db > dbBackup.sql When I run this script I get the 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 services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED - PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ForwardSourceID:NT00017DC6
RE: mysqldump access denied error
The user does have file privileges but - I just tried running the same script without the password included. Like the following: "/usr/bin/mysqldump -u user -p db > dbBackup.sql" instead of "/usr/bin/mysqldump -u user -ppassword db > dbBackup.sql" and this worked... 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 information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED â PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately. "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 18/01/2005 01:23 PM To "Tait Sanders" <[EMAIL PROTECTED]> cc Subject RE: mysqldump access denied error Check that the user has FILE privileges, given that a SELECT ... INTO OUTFILE sounds awfully like a mysqldump :- The FILE privilege gives you permission to read and write files on the server host using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements. A user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL server. (This implies the user can read any file in any database directory, because the server can access any of those files.) The FILE privilege also allows the user to create new files in any directory where the MySQL server has write access. Existing files cannot be overwritten. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax From: Tait Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:47 PM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: RE: mysqldump access denied error 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 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED - PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately. "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 18/01/2005 01:13 PM To "Tait Sanders" <[EMAIL PROTECTED]>, cc Subject RE: mysqldump access denied error Hi Tait, Have you tried show databases to make sure that user can actually use that database? mysql>show databases; That will tell you if that user has access as it won't show up in the listing. They may well be able to log into mysql but can they actually access that database is more the question. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Tait Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:36 PM To: mysql@lists.mysql.com Subject: mysqldump access denied error I've put together a shell script that is simply - /usr/bin/mysqldump -u user -ppassword db > dbBackup.sql When I run this script I get the 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 services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED - PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the u
RE: mysqldump access denied error
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 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED â PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately. "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 18/01/2005 01:13 PM To "Tait Sanders" <[EMAIL PROTECTED]>, cc Subject RE: mysqldump access denied error Hi Tait, Have you tried show databases to make sure that user can actually use that database? mysql>show databases; That will tell you if that user has access as it won't show up in the listing. They may well be able to log into mysql but can they actually access that database is more the question. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Tait Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:36 PM To: mysql@lists.mysql.com Subject: mysqldump access denied error I've put together a shell script that is simply - /usr/bin/mysqldump -u user -ppassword db > dbBackup.sql When I run this script I get the 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 services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED - PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately. ForwardSourceID:NT00017DC2
mysqldump access denied error
I've put together a shell script that is simply - /usr/bin/mysqldump -u user -ppassword db > dbBackup.sql When I run this script I get the 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 services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 --- PRIVILEGED â PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately.
Re: mysqldump error
thanks - i ran the command below and it worked. and now I'm trying to import using: 'mysql -u root -p mtweblog < Bckupmtweblog.sql' on CLI on different machine and am getting "Error 1 at line 11: Can't create/write to file'./mtweblog/mt_author.frm' Errorcode 13". any suggestions here? tait On 22/03/2004, at 10:15 AM, [EMAIL PROTECTED] wrote: First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example: 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 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog > BckUpmtweblog.sql' from CLI it gives "Error: 1045: Access 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 databse? tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
mysqldump error
hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog > BckUpmtweblog.sql' from CLI it gives "Error: 1045: Access 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 databse? ta tait tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
Re: can't install DBI on panther
well I finally got DBI 1.40 installed thanks to all you lot. FYI - I installed all the developer tools - not the select few I had chosen previously, then modified the mysql_config and the makefile created. this worked. thanks heaps for all the help. ta tait On 27/01/2004, at 6:00 PM, Steve 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: sys/types.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 411:19: ctype.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 423:23: locale.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 440:20: setjmp.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 446:26: sys/param.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 451:23: stdlib.h: No such file or directory At a guess, I'd say you haven't installed the Developer Tools. That installs /usr/include which you appear to be missing. HTH Steve. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] tait sanders computer technician sir robert webster bldg trc unsw
Re: can't install DBI on panther
i'm already logged in as SU so sudo won't help. thanks anyways. ta tait On 27/01/2004, at 12:12 PM, Douglas Sims wrote: I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all sort of problems but I finally got it to work. I don't exactly remember what finally did it, though. I think it might have been running the install with sudo, as in: sudo perl -MCPAN ... etc. but I'm not sure. If you haven't tried that, perhaps it will work. I've been trying to install GD (gd-2.0.21) off and on for a few days now and meeting with the same frustration. I build zlib, libpng, jpeg-6b without any errors, but gd blows up when I make. Here is the specific part of the build which blows up: gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/X11R6/include -I/usr/X11R6/include/freetype2 -I/usr/X11R6/include -g -O2 -MT gd_jpeg.lo -MD -MP -MF .deps/gd_jpeg.Tpo -c gd_jpeg.c -fno-common -DPIC -o .libs/gd_jpeg.lo gd_jpeg.c:41:21: jpeglib.h: No such file or directory gd_jpeg.c:42:20: jerror.h: No such file or directory gd_jpeg.c:54: error: parse error before "cinfo" gd_jpeg.c: In function `fatal_jpeg_error': I don't find gd_jpeg.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 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: sys/types.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 411: 19: ctype.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 423: 23: locale.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 440: 20: setjmp.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 446: 26: sys/param.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 451: 23: stdlib.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 1749: error: parse error before "STRLEN" /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 1749: warning: type defaults to `int' in declaration of `STRLEN' /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 1749: warning: data definition has no type or storage class In file included from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 121, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 1805, from DBIXS.h:19, from Perl.xs:1: /usr/include/gcc/darwin/3.3/inttypes.h:33:72: sys/cdefs.h: No such file or directory /usr/include/gcc/darwin/3.3/inttypes.h:34:56: machine/ansi.h: No such file or directory In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 121, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 1805, from DBIXS.h:19, from Perl.xs:1: /usr/include/gcc/darwin/3.3/stdint.h:24:27: machine/types.h: No such file or directory In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 121, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 1805, from DBIXS.h:19, from Perl.xs:1: /usr/include/gcc/darwin/3.3/stdint.h:34: error: parse error before "uint8_t" /usr/include/gcc/darwin/3.3/stdint.h:35: error: parse error before "uint16_t" /usr/include/gcc/darwin/3.3/stdint.h:36: error: parse error before "uint32_t" /usr/include/gcc/darwin/3.3/stdint.h:37: error: parse error before "uint64_t" /usr/include/gcc/darwin/3.3/stdint.h:41: error: parse error before "int_least8_t" /usr/include/gcc/darwin/3.3/stdint.h:42: error: parse error before "int_least16_t" /usr/include/gcc/darwin/3.3/stdint.h:43: 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 you dont have the DBI installed: $ perl -MCPAN -eshell install DBI cheers, M. tait sanders wrote: hi all, not sure if this is the appropriate place to
can't install DBI on panther
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: sys/types.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:411: 19: ctype.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:423: 23: locale.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:440: 20: setjmp.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:446: 26: sys/param.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:451: 23: stdlib.h: No such file or directory /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749: error: parse error before "STRLEN" /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749: warning: type defaults to `int' in declaration of `STRLEN' /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749: warning: data definition has no type or storage class In file included from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805, from DBIXS.h:19, from Perl.xs:1: /usr/include/gcc/darwin/3.3/inttypes.h:33:72: sys/cdefs.h: No such file or directory /usr/include/gcc/darwin/3.3/inttypes.h:34:56: machine/ansi.h: No such file or directory In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805, from DBIXS.h:19, from Perl.xs:1: /usr/include/gcc/darwin/3.3/stdint.h:24:27: machine/types.h: No such file or directory In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121, from /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805, from DBIXS.h:19, from Perl.xs:1: /usr/include/gcc/darwin/3.3/stdint.h:34: error: parse error before "uint8_t" /usr/include/gcc/darwin/3.3/stdint.h:35: error: parse error before "uint16_t" /usr/include/gcc/darwin/3.3/stdint.h:36: error: parse error before "uint32_t" /usr/include/gcc/darwin/3.3/stdint.h:37: error: parse error before "uint64_t" /usr/include/gcc/darwin/3.3/stdint.h:41: error: parse error before "int_least8_t" /usr/include/gcc/darwin/3.3/stdint.h:42: error: parse error before "int_least16_t" /usr/include/gcc/darwin/3.3/stdint.h:43: 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 you dont have the DBI installed: $ perl -MCPAN -eshell install DBI cheers, M. tait sanders wrote: hi all, not sure if this is the appropriate place to post this -- so please point me in the right direction if not here... I have a G4 with os10.3.2 server, mysql v4.0.16, and MoveableType 2.6 I'm trying to initialise the moveabletype system by running mt-load.cgi and am recieving 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. please help ta tait tait sanders computer technician sir robert webster bldg trc unsw tait sanders computer technician sir robert webster bldg trc unsw
unsupported driver trouble
hi all, not sure if this is the appropriate place to post this -- so please point me in the right direction if not here... I have a G4 with os10.3.2 server, mysql v4.0.16, and MoveableType 2.6 I'm trying to initialise the moveabletype system by running mt-load.cgi and am recieving 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. please help ta tait tait sanders computer technician sir robert webster bldg trc unsw
mysql will not start
hi all, i had a problem where: running apple os 10.3 server with mysql 4.0.16 and mysql would not start. found this solution at: http://docs.info.apple.com/article.html?artnum=107537 problem was that mysql was unable to start due to the hostname on my system being set to something other than 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 technician sir robert webster bldg trc unsw
Re: newbie - connect error
On 16/01/2004, at 12:32 PM, Gregory Newby wrote: From your description, it's not clear whether you already did this. If you installed other than with a binary distribution from mysql.com (or a mirror), it is possible that things are in somewhat different locations than in the INSTALL-BINARY file. But get the file (it comes with the distributions you download) so you can see the steps. yep I've already done this. everything I do comes back with the same error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I even deleted 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 heaps for all your help. ta tait tait sanders computer technician sir robert webster bldg trc unsw
Re: newbie - connect error
well I found my hostname.err file. It states this: "mysqld started InnoDB: Operating system error number 13 in a file operation. The error means that mysqld does not have the access rights to the directory. mysqld ended." so okay - how do I give mysqld the rights to the directory?? I've got mysql installed in /usr/bin/mysql and the db's and logs in /var/mysql - this is where the mysql db itself is. ta tait On 16/01/2004, at 10:36 AM, Gregory Newby wrote: Hi, Tait. It sounds like your server is never actually starting properly. There could be any number of reasons for this - it's best to work through the installation instructions that came with the package. To see what failed, chances are good there is an entry in the error log (it will probably be named "hostname.err" where "hostname" is your system's name) under your data directory (perhaps /usr/local/mysql/data, but you might have installed it in another location). View with something like this: tail /usr/local/mysql/data/hostname.err If you can't find the data directory or the err file, chances are that something fundamental is misconfigured (such as file permissions 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 mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start mysql with 'mysqld_safe &' I get a message that: "Starting mysqld daemon with databases from /var/mysql" "040116 10:07:57 mysqld ended" then nothing... the terminal is blank. when I then do 'ps auwx | grep mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and 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 Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby tait sanders computer technician sir robert webster bldg trc unsw
newbie - connect error
Hi, I'm a newbie to mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start mysql with 'mysqld_safe &' I get a message that: "Starting mysqld daemon with databases from /var/mysql" "040116 10:07:57 mysqld ended" then nothing... the terminal is blank. when I then do 'ps auwx | grep mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and 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