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...
> Ohhhh, 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 now....even 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....
>
>
