Re: InnoDB: Operating system error number 13 in a file operation
Hello Egor, You give me hope but... I attempted to set up permissions but it appears that I need to start up MySQL in order to do that. That brings me right back to my original problem of not being able to connect. I am thinking of reinstalling MySQL to see if I missed something in the original install. Any more suggestions please, I am at a loss. Mark D. On Wednesday, July 9, 2003, at 09:26 AM, Egor Egorov wrote: Mark Depenbrock [EMAIL PROTECTED] wrote: Can not make mysql connection - error log: 030708 08:53:48 mysqld started 030708 8:53:49 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 The http://www.innodb.com/ibman.html stated: If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. Question: Should I delete these files? and if so, how do you delete files from the command line? No, you should set up permissions on the directory and file. Error 13 means Permission denied. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB: Operating system error number 13 in a file operation
Rudy, Egor, Victoria, Thank you for keeping an eye on me. I ended up doing a reinstall of MySQL and have successfully connected. I feel I have broken through a wall only to find an infinite number of walls yet to break through. Such is the adventure I have chosen. Be at peace, Mark Depenbrock On Wednesday, July 9, 2003, at 11:13 AM, Rudy Metzger wrote: If you got the error message during creation of the innoDB files (e.g. during install) you HAVE TO DELETE all files and restart the installation. There is no way around this! However, if the file got corrupted after installation (e.g. you already used it for days) you can repair it (maybe someone changed the file permissions and/or ownership). You can change filepermissions on unix (linux) with chmod (type 'man chmod') on the command line, and change ownership with chown (man chown). You can delete files with 'rm' or 'unlink' (again, see the man pages for help) Cheers /rudy -Original Message- From: Mark Depenbrock [mailto:[EMAIL PROTECTED] Sent: woensdag 9 juli 2003 16:35 To: Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: InnoDB: Operating system error number 13 in a file operation Hello Egor, You give me hope but... I attempted to set up permissions but it appears that I need to start up MySQL in order to do that. That brings me right back to my original problem of not being able to connect. I am thinking of reinstalling MySQL to see if I missed something in the original install. Any more suggestions please, I am at a loss. Mark D. On Wednesday, July 9, 2003, at 09:26 AM, Egor Egorov wrote: Mark Depenbrock [EMAIL PROTECTED] wrote: Can not make mysql connection - error log: 030708 08:53:48 mysqld started 030708 8:53:49 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 The http://www.innodb.com/ibman.html stated: If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. Question: Should I delete these files? and if so, how do you delete files from the command line? No, you should set up permissions on the directory and file. Error 13 means Permission denied. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB: Operating system error number 13
Hello Nick, You and I are just about on the same page here. However, I just turned the page you are now baffling over. Let me ask, Did you removed the old Macintosh HD/Library/Receipts/mysql-standard-4.0.13.pkg file before you did the new install. If I am not mistaken, this is what cinched it for me. God bless, be at peace, Mark D On Wednesday, July 9, 2003, at 02:00 PM, Nick Boudreau wrote: Trying to start mysqld for the first time after a reinstall on Mac OS X gives me this error: 030709 12:53:26 mysqld started 030709 12:53:27 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: Cannot continue operation. 030709 12:53:27 mysqld ended Anyone know what could be causing this? I'm baffled. Thanks, Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB: Operating system error number 13 in a file operation
Can not make mysql connection - error log: 030708 08:53:48 mysqld started 030708 8:53:49 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 The http://www.innodb.com/ibman.html stated: If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. Question: Should I delete these files? and if so, how do you delete files from the command line? Please help, Mark D
OS X User - Start up help
I have installed a Mac OS X 'PKG' binary package on my OS version 10.2.6 Mac. I have been instructed that after the installation I can start up MySQL by running the following command lines: [Computer:/usr/local/mysql] mark% sudo ./bin/mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data 030707 12:31:53 mysqld ended [Computer:/usr/local/mysql] mark% bg bg: No current job. Instructions state that I should now be able to connect to MySQL server, e.g. by running [Computer:/usr/local/mysql] mark% /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) It appears that the server is not running...any suggestions? I have checked to see if the mysql.sock exists and it appears to be there: [Computer:/usr/local/mysql] mark% ls /tmp 501 mysql.sock printers printing.462 Thank you, Mark D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002: Can't connect to local MySQL server through socket
I have installed a Mac OS X 'PKG' binary package on my OS version 10.2.6 Mac. I have been instructed that after the installation I can start up MySQL by running the following command lines: [Computer:/usr/local/mysql] mark% sudo ./bin/mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data 030707 12:31:53 mysqld ended [Computer:/usr/local/mysql] mark% bg bg: No current job. Instructions state that I should now be able to connect to MySQL server, e.g. by running [Computer:/usr/local/mysql] mark% /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) It appears that the server is not running...any suggestions? I have checked to see if the mysql.sock exists and it appears to be there: [Computer:/usr/local/mysql] mark% ls /tmp 501 mysql.sock printers printing.462 Thank you, Mark D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]