[ale] mySQL

[Dana Powers]

Check the types of tables you have installed:

mysql> SHOW VARIABLES LIKE 'HAVE%';

YES means you can use it
NO means you cant
DISABLED means that it is compiled into the server, but not initialized -
check your my.cnf file

dpk

----- Original Message -----
From: "John" <jcouncilman at knology.net>
To: ale at ale.org
To: "James P. Kinney III" <jkinney at localnetsolutions.com>;
<x3 at ChangingLINKS.com>; "Atlanta Linux User Group (E-mail)" <ale at ale.org>
Sent: Thursday, September 19, 2002 7:46 PM
Subject: Re: [ale] mySQL


> InnoDB is only included in MySQL-Max.
> To check if you are using InnoDB, do:
> mysql> show table status;
> (I think that is right)
>
> To change a table to InnoDB, do:
> mysql> alter table table_name type=InnoDB;
> (Also, I think that is right).
>
>
> John
>
>
> On 19 Sep 2002 20:03:28 -0400, "James P. Kinney III"
> <jkinney at localnetsolutions.com> wrote :
>
> >
> > 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 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.