installation nightmare
I feel like one big fat stupid sheep problem SOLVED... It turns out that the root of all the problems was my own little forgetful brain... I had forgotten that I had changed the permissions on the apache22/data files to 766 which prevented the execution of all the php scripts which snowballed into incorrect readings of info.php and a whole bunch of stuff. Now, apache22, mysql, php, phpMySql, etc. etc. all work fine as out of the box Thanks for all the input from everyone and Happy Holidays to all :-[ :-! :-X -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: installation nightmare
This is the best response todate. ! John Daisley wrote: I have read through your message again because I really could not believe you were having so many issues then it struck me... Thank you for listening... :-) You installed MySQL 6.0.8, an Alpha release on to what seems like a production box Sorry to disappoint you, but I am an overzealous amateur with Unix in general. I think the thinking behind it all is fabulous; it's just that, I find, there is a kind-of smugness in the community about the systems and software: people assume that we amateur-idiots are supposed to know more than we do. I really do not like the idea of having to read through all the documentation of any program until I need to get into the details - most software, like Cups and Salmba are set up once and thereafter one need not even think about it; generally it works without problem. No, I have the setup strictly locally for my own pleasure and enlightenment and to help me with the creation and, sometimes, development of a website by more qualified people working for me... now, I'm just trying to help out my daughter to update her egyptology site (www.ptahhotep.com) with a database. and now you are having trouble getting other versions to work? Well this isn't going to be very helpful but I guess you are learning the hard way why you never install alpha software onto anything other than a box which you rely on only to collect dust. You're right... :-) - but it is helpful. I didn't realize that this was an alpha until I deinstalled... ok, ok, that's my fault... Seems to me the box you are working on is pretty messed up with Apache, Php and MySQL all having problems. Restore a backup from before it got messed up so you know you have a working base then try again one piece of software at a time. Other than the backup, which was not necessary, as this is a fresh install of FreeBSD7.0, I did exactly that: I deinstalled, deleted stray files and anything I could find related to MySQL, PHP5, phpMyAdmin, and even Webmin. I then updated the Ports files and started to reinstall everything. Well, I thought that would fix things... ehhh, no; not only did it not work, there was another wrench that was dropped by php5.2.8 - it is broken and phymyadmin cannot be installed and setup. Soo, as we say in French: rebelotte! - or in English back to square 1. So, now I am just rying to set up MySQL - first try, to start the server was a system freeze because I went for a directive from the Documentation. To tell you the truth, I have never done backups on the FreeBSD installations - the reasoning is quite simple... if it fails, I have backed up the work files and anything of importance on other machines and reinstallaing the OS and programs is not a big deal - at least, it never has been; until now. I have had a couple of crashes but it has exclusively been due to HDDs failing. Even on the last failure I was able to salvage all important files without any great problems. Other than that, as you are struggling with MySQL, PHP and Apache but are happy with commercial software offerings then go with what you are happy with. Get a copy of SQL Server and IIS. Everyone has there own preference and you have to go with what you are most comfortable and productive with. For me its Oracle10g/MySQL5 on Fedora, for you I'm sure its something totally different. What you don't want to do is try something you are not comfortable with, mess it up and then go onto a user group blaming the software particularly when its such an established piece of software as MySQL which can proudly boast millions of working installs spread across probably every conceivable platform. I couldn't agree more. For example, I have more problems with MS Office than you can imagine... OpenOfficeOrg is fabulous ... Only problem is the compatibility with MS files is the macros, but I don't often need them. Thats my rant for the day, now as its gone 1am Im off to bed. Sweet dreams, and have a nice holiday. Phil Jourdan John */John Daisley/* Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator http://www.mysql.com/certification/candidates.php?exam=4(CMDBA) MySQL Certified Developer http://www.mysql.com/certification/candidates.php?exam=3 (CMDEV) MySQL Certified Associate http://www.mysql.com/certification/candidates.php?exam=6 (CMA) Comptia A+ Certified Professional IT Technician On Fri, 2008-12-19 at 15:47 -0500, PJ wrote: Do what I can, there seems to be no way to install mysql 5.1.30 on FreeBSD 7.0 I even removed all files in reference to mysql5.0, 5.1, 6.0.8 from the Ports collection, cvsup'd the Ports, deinstalled php5, php5-mysql, phpMyAdmin, Webmin and followed the documentation as closely as possible (a number of contradictions in file names and locations) to install MySQL 5.1.30, run the install tables script, change the root password
installation nightmare
Do what I can, there seems to be no way to install mysql 5.1.30 on FreeBSD 7.0 I even removed all files in reference to mysql5.0, 5.1, 6.0.8 from the Ports collection, cvsup'd the Ports, deinstalled php5, php5-mysql, phpMyAdmin, Webmin and followed the documentation as closely as possible (a number of contradictions in file names and locations) to install MySQL 5.1.30, run the install tables script, change the root password both with and without the server name (it is never clear in the documentation as to just when to start or stop the server) - the mysql database is not created, access is denied to root (using password=NO) - now, why is one supposed to set up the password and then the password is not accepted - what is this nonsense; su mysql does not work how is it possible that I was originally able to set up mysql6.0.8 and get it running along with phpMyAdmin and Webmin... now I have updated even php5 to 5.2.8 and now phpMyAdmin cannot be installed because of a break in php5.2.8 (the php5-sld - or something like that) This is the most absurd mess that I have seen - it seems that the programmers have all gone loony and have forgotten that the essence of productivity and success is the old KISS principle - Keep It Simple Stupid. I think there must be a lot of people sleeping out there in computer never-never-land. No wonder Bill Gates is a genius among the so-called computer nerds out there. I detest Windows and all their bloated garbage - but you have to admit that their aim is to make it simple for us Idiots out here. My productivity has dropped to minus a few hundred percent since I started to set up mysql. Is there somebody out there who could help me figure out this mess. What error files, if any should I be looking for... O, yes - to add to all the shit, I now cannot access php (index) files on apache22 since upgrading to apache22 2.2.11 and php5.2.8 - now I have to try to figure what has changed in both those programs... man, this is no way to work with programs... look at Adobe and most of the commercial stuff - there are at times some running issues, but mostly they just keep adding features to a solid base... why are all these open source programs such a hassle... I suppose I should set up some older versions and just never update... seems that's the way to go. Sorry to be ranting, but this is just unbelievable... I have, in the past had some problems in installing such programs as cups and samba, but eventually I was able to fix things and now those programs are no longer a problem... but noweven pgsql was a breeze to install and update... the only reason I'm trying to install mysql is because my ISP Web host is using that... maybe not if I can help it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: installation nightmare
First of all, you are using a ports distribution system from BSD which means that you are not dealing with MySQL directly but with a BSD API layer on top of MySQL for installation. So much of your issues may end up being a BSD problem, not a MySQL problem at all. If the BSD scripts that are supposed to keep your fingers out of the installation gears are confusing you when you read the MySQL instructions that tell you how to turn the cranks without getting your fingers in the gears, then maybe you need to stop and find docs that are specific to BSD install of MySQL or install from source which matches the docs. That said, it sounds like you skipped the step about flush privileges And, once you set the root password, you need to add -p to mysql (and others) to ask it to prompt you for your password. It would help a great deal if you could more clearly document what you did, and where things FIRST went wrong, and STOP THERE and post instead of moving forward and then rambling on about how bad everything is and dumping several different issues into a giant rant. It makes it very difficult for anybody to help you when you do that. Also makes people less likely to WANT to help you, which is an even bigger issue. :-) There is no need to start/stop the server, but you MUST flush the privileges after you change them. Or, if you prefer, swat the fly with a cannon and stop/start the server. :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: installation nightmare
Take a look at the online documentation, it will give you all the info you could dream of regarding error files, installation procedures and configuration issues. I have never installed MySQL on Freebsd so can't help you there but I have installed it on Redhat, Centos, Solaris, windows and Mac with the utmost ease and I really cannot see the FreeBSD install being anything different. Sounds like you have a lot of other software issues too, maybe you should look at the problems of the system as a whole! If something refuses to install its usually a fault with the system / software configuration you are trying to install too and rarely a fault with the installation procedure itself. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Fri, 2008-12-19 at 15:47 -0500, PJ wrote: Do what I can, there seems to be no way to install mysql 5.1.30 on FreeBSD 7.0 I even removed all files in reference to mysql5.0, 5.1, 6.0.8 from the Ports collection, cvsup'd the Ports, deinstalled php5, php5-mysql, phpMyAdmin, Webmin and followed the documentation as closely as possible (a number of contradictions in file names and locations) to install MySQL 5.1.30, run the install tables script, change the root password both with and without the server name (it is never clear in the documentation as to just when to start or stop the server) - the mysql database is not created, access is denied to root (using password=NO) - now, why is one supposed to set up the password and then the password is not accepted - what is this nonsense; su mysql does not work how is it possible that I was originally able to set up mysql6.0.8 and get it running along with phpMyAdmin and Webmin... now I have updated even php5 to 5.2.8 and now phpMyAdmin cannot be installed because of a break in php5.2.8 (the php5-sld - or something like that) This is the most absurd mess that I have seen - it seems that the programmers have all gone loony and have forgotten that the essence of productivity and success is the old KISS principle - Keep It Simple Stupid. I think there must be a lot of people sleeping out there in computer never-never-land. No wonder Bill Gates is a genius among the so-called computer nerds out there. I detest Windows and all their bloated garbage - but you have to admit that their aim is to make it simple for us Idiots out here. My productivity has dropped to minus a few hundred percent since I started to set up mysql. Is there somebody out there who could help me figure out this mess. What error files, if any should I be looking for... O, yes - to add to all the shit, I now cannot access php (index) files on apache22 since upgrading to apache22 2.2.11 and php5.2.8 - now I have to try to figure what has changed in both those programs... man, this is no way to work with programs... look at Adobe and most of the commercial stuff - there are at times some running issues, but mostly they just keep adding features to a solid base... why are all these open source programs such a hassle... I suppose I should set up some older versions and just never update... seems that's the way to go. Sorry to be ranting, but this is just unbelievable... I have, in the past had some problems in installing such programs as cups and samba, but eventually I was able to fix things and now those programs are no longer a problem... but noweven pgsql was a breeze to install and update... the only reason I'm trying to install mysql is because my ISP Web host is using that... maybe not if I can help it
Re: installation nightmare
John Daisley wrote: Take a look at the online documentation, it will give you all the info you could dream of regarding error files, installation procedures and configuration issues. I have been looking at this stuff until my eyes pop out - perhaps there is too much of it. It certainly is very confusing. I have never installed MySQL on Freebsd so can't help you there but I have installed it on Redhat, Centos, Solaris, windows and Mac with the utmost ease and I really cannot see the FreeBSD install being anything different. Sounds like you have a lot of other software issues too, maybe you should look at the problems of the system as a whole! If something refuses to install its usually a fault with the system / software configuration you are trying to install too and rarely a fault with the installation procedure itself. As a matter of fact, I have set up this FreeBSD 7.0 box strictly for modifying and improving a couple of simple (??) websites. Everything was working perfectly util I tried to unistall MySQL6.0.8alpha and install v. 51 to be compatible with the ISP Website host. From what I see, there is a problem in the documentation (or my inability to comprehend) of MySQL. I have been trying for 4 days without any success. And things get more complicated when there is a problem in other software like php5.2.8. I just now reinstalled MySQL5.1.30; I ran mysql_install_db --user=mysql and that seemed to be ok; I then tried to start the server with bin/mysqld_safe -user=mysql and wow... wait... wait... wait how long am I supposed to wait ... the thing just hung up and I had to reboot... how am I supposed to start the thing - I have started it befor with mysql-server start from /usr/local/etc/rc.d/ and even by rebooting... that's it for today - tomorrow I'll try again.. absurdity seems to never end... :-( */John Daisley/* Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator http://www.mysql.com/certification/candidates.php?exam=4(CMDBA) MySQL Certified Developer http://www.mysql.com/certification/candidates.php?exam=3 (CMDEV) MySQL Certified Associate http://www.mysql.com/certification/candidates.php?exam=6 (CMA) Comptia A+ Certified Professional IT Technician On Fri, 2008-12-19 at 15:47 -0500, PJ wrote: Do what I can, there seems to be no way to install mysql 5.1.30 on FreeBSD 7.0 I even removed all files in reference to mysql5.0, 5.1, 6.0.8 from the Ports collection, cvsup'd the Ports, deinstalled php5, php5-mysql, phpMyAdmin, Webmin and followed the documentation as closely as possible (a number of contradictions in file names and locations) to install MySQL 5.1.30, run the install tables script, change the root password both with and without the server name (it is never clear in the documentation as to just when to start or stop the server) - the mysql database is not created, access is denied to root (using password=NO) - now, why is one supposed to set up the password and then the password is not accepted - what is this nonsense; su mysql does not work how is it possible that I was originally able to set up mysql6.0.8 and get it running along with phpMyAdmin and Webmin... now I have updated even php5 to 5.2.8 and now phpMyAdmin cannot be installed because of a break in php5.2.8 (the php5-sld - or something like that) This is the most absurd mess that I have seen - it seems that the programmers have all gone loony and have forgotten that the essence of productivity and success is the old KISS principle - Keep It Simple Stupid. I think there must be a lot of people sleeping out there in computer never-never-land. No wonder Bill Gates is a genius among the so-called computer nerds out there. I detest Windows and all their bloated garbage - but you have to admit that their aim is to make it simple for us Idiots out here. My productivity has dropped to minus a few hundred percent since I started to set up mysql. Is there somebody out there who could help me figure out this mess. What error files, if any should I be looking for... O, yes - to add to all the shit, I now cannot access php (index) files on apache22 since upgrading to apache22 2.2.11 and php5.2.8 - now I have to try to figure what has changed in both those programs... man, this is no way to work with programs... look at Adobe and most of the commercial stuff - there are at times some running issues, but mostly they just keep adding features to a solid base... why are all these open source programs such a hassle... I suppose I should set up some older versions and just never update... seems that's the way to go. Sorry to be ranting, but this is just unbelievable... I have, in the past had some problems in installing such programs as cups and samba, but eventually I was able to fix things and now those programs are no longer a problem... but noweven pgsql was a breeze to install and
Re: installation nightmare
PJ wrote: longer a problem... but noweven pgsql was a breeze to install and update... the only reason I'm trying to install mysql is because my ISP Web host is using that... maybe not if I can help it no offense but at this time, perhaps its operator error i've installed mysql on freebsd may times. -- -- Chaim Rieger www.jravel.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: installation nightmare
I have read through your message again because I really could not believe you were having so many issues then it struck me... You installed MySQL 6.0.8, an Alpha release on to what seems like a production box and now you are having trouble getting other versions to work? Well this isn't going to be very helpful but I guess you are learning the hard way why you never install alpha software onto anything other than a box which you rely on only to collect dust. Seems to me the box you are working on is pretty messed up with Apache, Php and MySQL all having problems. Restore a backup from before it got messed up so you know you have a working base then try again one piece of software at a time. Other than that, as you are struggling with MySQL, PHP and Apache but are happy with commercial software offerings then go with what you are happy with. Get a copy of SQL Server and IIS. Everyone has there own preference and you have to go with what you are most comfortable and productive with. For me its Oracle10g/MySQL5 on Fedora, for you I'm sure its something totally different. What you don't want to do is try something you are not comfortable with, mess it up and then go onto a user group blaming the software particularly when its such an established piece of software as MySQL which can proudly boast millions of working installs spread across probably every conceivable platform. Thats my rant for the day, now as its gone 1am Im off to bed. John John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Fri, 2008-12-19 at 15:47 -0500, PJ wrote: Do what I can, there seems to be no way to install mysql 5.1.30 on FreeBSD 7.0 I even removed all files in reference to mysql5.0, 5.1, 6.0.8 from the Ports collection, cvsup'd the Ports, deinstalled php5, php5-mysql, phpMyAdmin, Webmin and followed the documentation as closely as possible (a number of contradictions in file names and locations) to install MySQL 5.1.30, run the install tables script, change the root password both with and without the server name (it is never clear in the documentation as to just when to start or stop the server) - the mysql database is not created, access is denied to root (using password=NO) - now, why is one supposed to set up the password and then the password is not accepted - what is this nonsense; su mysql does not work how is it possible that I was originally able to set up mysql6.0.8 and get it running along with phpMyAdmin and Webmin... now I have updated even php5 to 5.2.8 and now phpMyAdmin cannot be installed because of a break in php5.2.8 (the php5-sld - or something like that) This is the most absurd mess that I have seen - it seems that the programmers have all gone loony and have forgotten that the essence of productivity and success is the old KISS principle - Keep It Simple Stupid. I think there must be a lot of people sleeping out there in computer never-never-land. No wonder Bill Gates is a genius among the so-called computer nerds out there. I detest Windows and all their bloated garbage - but you have to admit that their aim is to make it simple for us Idiots out here. My productivity has dropped to minus a few hundred percent since I started to set up mysql. Is there somebody out there who could help me figure out this mess. What error files, if any should I be looking for... O, yes - to add to all the shit, I now cannot access php (index) files on apache22 since upgrading to apache22 2.2.11 and php5.2.8 - now I have to try to figure what has changed in both those programs... man, this is no way to work with programs... look at Adobe and most of the commercial stuff - there are at times some running issues, but mostly they just keep adding features to a solid base... why are all these open source programs such a hassle... I suppose I should set up some older versions and just never update... seems that's the way to go. Sorry to be ranting, but this is just unbelievable... I have, in the past had some problems in installing such programs as cups and samba, but eventually I was able to fix things and now those programs are no longer a problem... but noweven pgsql was a breeze to install and update... the only reason I'm trying to install mysql is because my ISP Web host is using that... maybe not if I can help it
installation nightmare
Or should I say 4-day-mare... I have been trying to set up mysql for the last 4 days with weird success. I first installed mysql 6.0.8alpha not knowing I needed 5.0 compatibility for my ISP Website host. I go everything working pretty well... mysql6, php5, phpMyAdmin, all on FreeBSD 7.0 with apache2.2.9_5; all but the setup of the pba_history table for phpmyadmin - just no way. Anyway, I unistalled mysql6 and am now trying to install mySQL 5.1.30 from the FreeBSD ports collection. I have tried about everything I can think of besides the arcane documentation that is not at all accurate - for instance, there is no mysq-test.pl or something like that that is referenced in the database, but there is mysqltest in the .../bin directory. However, running that results in errors. When I do manage to set the root user password, it is not accepted... I just cannot understand what kind of a mess this is. The only thing I can provide is the error file: (biggie - is the name of the server) 081218 17:40:17 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 081218 17:40:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 081218 17:40:18 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 081218 17:40:18 mysqld_safe mysqld from pid file /var/db/mysql/biggie.pid ended 081218 17:46:04 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 081218 17:46:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 081218 17:46:04 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 081218 17:46:04 mysqld_safe mysqld from pid file /var/db/mysql/biggie.pid ended 081218 17:54:09 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 081218 17:54:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 081218 17:54:09 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 081218 17:54:09 mysqld_safe mysqld from pid file /var/db/mysql/biggie.pid ended Either I am totally incompetent and cannot decipher the instructions or there is some kind of beatie running here... Hope somebody can help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: installation nightmare
Hi PJ, To be quite honest you may have better luck downloading and installing MySQL yourself. It's very rare I install anything from the ports on FreeBSD or apt repositories on Debian, simply because you have little (if any) control over what goes on. At least if you do it yourself you know how you're setting the system up. That's just from personal experience. Download the FreeBSD binary from http://dev.mysql.com/downloads/mysql/5.1.html, and extract it somewhere on your system (e.g. /tmp.) Follow the instructions in http://dev.mysql.com/doc/refman/5.1/en/installing-binary.html which explains in full detail what to do and why you're doing what you're doing. Just in case you're wondering, your problems with 5.1.30 appear to be that the data directory it's trying to use (/var/db/mysql) is from a pre-5.1 server (and you need to run mysql_upgrade to correct it, but this requires an up-and-running system in the first place.) Your second issue is that InnoDB does not have permissions to create files in this directory. Check the owner/group MySQL is trying to run as has access to /var/db/mysql. Regards, Andy PJ wrote: Or should I say 4-day-mare... I have been trying to set up mysql for the last 4 days with weird success. I first installed mysql 6.0.8alpha not knowing I needed 5.0 compatibility for my ISP Website host. I go everything working pretty well... mysql6, php5, phpMyAdmin, all on FreeBSD 7.0 with apache2.2.9_5; all but the setup of the pba_history table for phpmyadmin - just no way. Anyway, I unistalled mysql6 and am now trying to install mySQL 5.1.30 from the FreeBSD ports collection. I have tried about everything I can think of besides the arcane documentation that is not at all accurate - for instance, there is no mysq-test.pl or something like that that is referenced in the database, but there is mysqltest in the .../bin directory. However, running that results in errors. When I do manage to set the root user password, it is not accepted... I just cannot understand what kind of a mess this is. The only thing I can provide is the error file: (biggie - is the name of the server) 081218 17:40:17 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 081218 17:40:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 081218 17:40:18 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 081218 17:40:18 mysqld_safe mysqld from pid file /var/db/mysql/biggie.pid ended 081218 17:46:04 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 081218 17:46:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 081218 17:46:04 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 081218 17:46:04 mysqld_safe mysqld from pid file /var/db/mysql/biggie.pid ended 081218 17:54:09 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 081218 17:54:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 081218 17:54:09 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 081218 17:54:09 mysqld_safe mysqld from pid file /var/db/mysql/biggie.pid ended Either I am totally incompetent and cannot decipher the instructions or there is some kind of beatie running here... Hope somebody can help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org