[ale] mySQL

[John C]

You should ALWAYS use the binaries from mysql.com.  Do not use redhat RPMS
and do not compile it yourself.  This is per Brian Aker - Slashdot.org DBA.
He stressed this about 3 or 4 times during his talk at Linuxworld Expo.




-----Original Message-----
From: Jim [mailto:jcphil at mindspring.com]
To: ale at ale.org
Sent: Thursday, September 19, 2002 5:07 PM
To: x3 at ChangingLINKS.com; ale at ale.org
Subject: Re: [ale] mySQL


RPM installations of MySQL drive me crazy for all of the reasons you cite
here. You can go back to the RPM and run:

rpm -qpi -l mysql-XXXX.rpm

That will show you where it put everything. But if you want reall control
over
the whole process, then build it from scratch. Then there won't be any
question as to whether you have InnoDB support or not. For my part, I like
to
install everything in /usr/local/mysql. And by all means, get phpMyAdmin. It
makes everything much easier.

On Thursday 19 September 2002 04:27 pm, ChangingLINKS.com wrote:
> 09-19-02 1512
> Boy, am I lost. I have been RTFM and trying to follow it, but I can't "do"
> much yet. The good news is that when I type "mysql" at the command prompt,
> I do get the "mysql>" The manual neglects rpm installation tips somewhat
> (like where the mysql install directory "is").
> So, I go to /usr/bin and enter mysql_install_db. According to the manual,
I
> think I am supposed to get 6 new tables to appear in /var/lib/mysql. not.
>
> And, when I do simple things, I get errors:
>
> mysql> use mysql
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
>
> mysql> create database;
> ERROR 1064: You have an error in your SQL syntax near '' at line 1
>
> Also, I am hoping that have InnoDb. How do I check to see if I do? I guess
> that if I don't have InnoDb, it will be best to uninstall mySQL altogther
> and start from scratch?


---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
sent to listmaster at ale dot org.



---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.