[ale] mySQL

[Mike Lockhart]

Installing it by hand is definately the best way to go.

>From mysql.com, just grab the linux binary build (mysql-max, so you have

innodb).

Untar the file in /usr/local, then do "ln -s /usr/local/mysql-xxx-xxx
mysql (makes upgrades much easier). 

Then edit /etc/profile and add at the end
-> PATH=$PATH:/usr/local/mysql/bin

In /etc/ld.so.conf add "/usr/local/mysql/lib" then ldconfig

After thats done, read the install file in /usr/local/mysql and follow
the directions there as to adding the user/groups, permissions, etc...

Then startup mysql and run the security script :)



On Thu, 2002-09-19 at 16:07, Jim wrote:
> 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.
> 
-- 

================================
Michael Lockhart - PHP Developer
Intercosmos Media Group
mailto:mlockhart at intercosmos.com
http://orbital.intercosmos.net
================================

 This is a digitally signed message part