RE: Unable to ADD databases

2003-08-04 Thread Jeffery C. Baldwin
A GEEZ!  I apologize to all, I did not take the time to 'think'
before I wrote. 

Sorry for the waste of bandwidth :-)

And thank you to Leonardo for the reply.

Jeff

-Original Message-
From: Leonardo Rodrigues Magalhães [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 04, 2003 12:21 PM
To: Jeffery C. Baldwin
Subject: Re: Unable to ADD databases


Seems no problem at all. GRANT does not CREATE databases, it just
GRANT
privileges. If you need to create a new database, you should try:

create database mynewdatabase;


Sincerily,
Leonardo Rodrigues

- Original Message - 
From: "Jeffery C. Baldwin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 04, 2003 1:06 PM
Subject: Unable to ADD databases


> Hello All -
>
> I'm just started the process of learning MySQL and databases in
general.
> I just bought the book 'MySQL' written by Paul DuBois, who I gather is
> really active in this community.
>
> Anyhow..  Here's the problem that I'm having.
>
> mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY
> 'secret';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> show databases;
> +--+
> | Database |
> +--+
> | helpdesk |
> | mysql|
> | test |
> +--+
> 3 rows in set (0.01 sec)
>
> Anyone notice the problem?  Even though I get no error.. the sampdb is
> not being greated.  This is weird as I've been able to use this exact
> command in the past with no problems.  I even tried logging in as root
> before starting the mysql client, still made no difference.
>
> Thanks in advance..
>
> Jeff
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Books advice

2003-08-04 Thread Jeffery C. Baldwin
Just to drop my $.02 in on this.. I started reading the 1st version of
Pauls' MySQL book online a week or so back using my account over at
'Safari', once I read a little and decided that I was genuinely
interested in this MySQL 'thing', I went over to Barnes and Noble with
intentions of getting a hard copy of the 2nd edition of this book..
well.. I ended up leaving the store with a copy of 'Mastering MySQL' by
Sybex instead.  I returned that book yesterday and picked up the 2nd
Edition of MySQL :-).  I initially chose the 'Mastering MySQL' book
pretty much due to one reason, and that the size of the MySQL' book was
a little intimidating.  But once I got home and started reading the
Sybex book I realized why Pauls' book is so long, it is impossible to
cover the amount of content necessary to get a good grasp for Mysql
without using a lot of paper :-).  The Sybex book made a lot of
assumptions and didn't go into what I felt was very thorough detail on
any subject (my idea is that this is a great book for the experienced DB
admin), while Paul takes the time to explain each subject and every
detail very thoroughly.

Thanks Paul, I just started this book but I'm already very impressed.

Again.. all of this is just my $.02 and I am VERY new at all of this DB
stuff

Jeff

+---+
|  Jeffery C Baldwin
|  Computer Consultant II
|
|  University of North Carolina - Chapel Hill
|  213 Miller Hall
|  CB# 1105
|  Chapel Hill, NC 27599
|
|  Phone: (919) 843-2725
|  Fax: (919) 966-8928
|  E-Mail: jeff_baldwin at unc dot edu
+---+

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 04, 2003 12:02 PM
To: Asif Iqbal; Ralph Guzman
Cc: 'Fawad Siddiqui'; [EMAIL PROTECTED]
Subject: RE: Books advice

At 21:04 -0400 7/31/03, Asif Iqbal wrote:
>I just ordered this book
>
>MySQL
>The definitive guide to using, programming,
>and administering MySQL 4
>by Paul Dubois
>
>I found it more technical than MySQL cook book by Paul Dubois

Comparison information:

http://www.kitebird.com/mysql-book-comparison.php

This page also includes links to each book's home page that
provides other information about the book such as ISBN.

>
>
>On Thu, 31 Jul 2003, Ralph Guzman wrote:
>
>>  Here are two other books that I would recommend, specially the first
>>  one:
>>
>>  * SQL Queries for Mere Mortals: A Hands-On Guide to Data
Manipulation in
>>  SQL
>>  by Michael J. Hernandez, John L. Viescas
>>
>>  Joe Celko's SQL for Smarties: Advanced SQL Programming
>>  by Joe Celko
>>
>>
>>  -Original Message-
>>  From: Fawad Siddiqui [mailto:[EMAIL PROTECTED]
>>  Sent: Thursday, July 31, 2003 5:06 PM
>>  To: [EMAIL PROTECTED]
>>  Subject: Books advice
>>
>>  Hi,
>>
>>  I would like to learn about RDBMS, namely mysql of course, but know
>>  really nothing in this area, so have to learn about; RDBMS, SQL and
>>  mysql from scratch.
>>
>>  In this regard, if anyone knows of any books they think would start
me
>>  off on the right foot, I would be very grateful.
>>
>>  I have done some searching on Amazon, with the following results.
>>
>>  1.Beginning Databases with MySQL
>> by Richard Stones, Neil Matthew
>>
>>  2.MySQL Cookbook
>> by Paul DuBois
>>
>>  3.Managing and Using MySQL
>>by George Reese, et al
>>
>>  4.Inside Relational Databases
>> by Mark Whitehorn, Bill Marklyn
>>
>>  5.Database Design
>> by Ryan K. Stephens, Ronald R. Plew
>>
>>  6.The Practical SQL Handbook: Using SQL Variants
>> by Judith S. Bowman, et al
>>
>>
>>  Many thanks in advance for all your help.
>>
>>
>>  Fawad
>>
>>
>>
>>
>
>--
>Asif Iqbal
>http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
>There's no place like 127.0.0.1


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Unable to ADD databases

2003-08-04 Thread Jeffery C. Baldwin
Hello All -
 
I'm just started the process of learning MySQL and databases in general.
I just bought the book 'MySQL' written by Paul DuBois, who I gather is
really active in this community.
 
Anyhow..  Here's the problem that I'm having.
 
mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY
'secret';
Query OK, 0 rows affected (0.00 sec)
 
mysql> show databases;
+--+
| Database |
+--+
| helpdesk |
| mysql|
| test |
+--+
3 rows in set (0.01 sec)
 
Anyone notice the problem?  Even though I get no error.. the sampdb is
not being greated.  This is weird as I've been able to use this exact
command in the past with no problems.  I even tried logging in as root
before starting the mysql client, still made no difference.
 
Thanks in advance..
 
Jeff