[plug] MySQL and SQL queries

[Jon Miller]

Well there are quite a few places that have tutorials you can use
(google search MySQL tutorials).  As for accessing the database, you can
add a user to the database and give that user certain access.  This can
be done in mysql using the GRANT statement.  For instance GRANT usage ON
* to username at localhost IDENTIFIED BY 'password'; will add username to
the database but no privileges has been given.  Look up the GRANT
statement at the mysql website for more definition.
As for a decent book the MySQL Bible is good (although the graphic is
bad (grey text on a black background).
But the understanding of MySQL is well covered in this book.
Accessing the MySQL database from a CLI is done by issuing the
following:
mysql -u username -p, the system will prompt you for a password or you
can access it by mysql -u username -p database which will prompt you for
a password and log you in using the database specified after the -p.
There are lots of ways of working with MySQL all are quite simple once
you get going. Just don't forget to use the ";" at the end of a command.

You can also use mysqladmin to add a user.


Jon

On Fri, 2003-07-04 at 21:29, Weirdo wrote:
> I am looking at learning how to use MySQL and SQL queries. We are learning 
> access at school and I though I would extended my knowledge for future 
> reference. I am looking for links to good tutorials.
> Also the only user that can access the MySQL database is root. i.e. the 
> program trying to access the database (MySQL navigator, tora...) has to be 
> running as root.
> As I am steering away from GUIs  i would like to know how to access the 
> database and issue queries ... using a command line program (Direct server 
> term?)
> Thanks
> Tim
> 
> weirdo at linuxalien.tk
> Dot TK ambassador #24084 - For a free .tk domain please contact me
> 
> ICQ# 255176389
> MSN weirdo at linuxalien.tk
> 
> Riverton, Perth, WA
-- 
Jon Miller <jlmiller at mmtnetworks.com.au>
MMT Networks Pty Ltd