[ale] mySQL

[Jim]

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.