[ale] mySQL

[ChangingLINKS.com]

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?
-- 
Wishing you Happiness, Joy and Laughter,
Drew Brown
http://www.ChangingLINKS.com

---
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.