[ale] mySQL

John jcouncilman at knology.net
Thu Sep 19 22:46:46 EDT 2002


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.






More information about the Ale mailing list