[ale] mySQL

[James P. Kinney III]

Drew! Welcome to the world of mysql permissions.

A book recommendation:
MySQL & mSQL from O'Reilly (ISBN 1-56592-434-7). It has the best written
chapter on the permission scheme in MySQL I've ever seen. In other
words, I followed what it said o do and it worked!

In a nutshell, users are keyed to both a machine name and a user name.
So that is a common first headache. If you installed mysql from rpms,
there should be html documentation in
/usr/share/doc/mysql-3.23.49/manual.html (2.3MB)

When you use the mysql command, it almost always needs a username
(--user= username) and password (--password=password). You also need to
have DNS working or a populated /etc/hosts file. Users must be added and
associated with machine names or IP addresses.

On Thu, 2002-09-19 at 16:27, 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?
> -- 
> 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.
-- 
James P. Kinney III   \Changing the mobile computing world/
President and CEO      \          one Linux user         /
Local Net Solutions,LLC \           at a time.          /
770-493-8244             \.___________________________./

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7 



 This is a digitally signed message part