473,322 Members | 1,781 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Unable to ADD databases

------=_NextPart_000_0077_01C35A80.D1D75610
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_0077_01C35A80.D1D75610--

Jul 19 '05 #1
0 1197

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jeffery C. Baldwin | last post by:
------=_NextPart_000_0077_01C35A80.D1D75610 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello All - I'm just started the process of learning MySQL and...
0
by: beck4353 | last post by:
Hi, I am using VS.NET Arch. and I am having problems connecting to ANY database. I am trying to a either a SqlConnection or OleDBConnection object to my project. When I try to define the...
12
by: InProcess | last post by:
Let me start by saying that, yes we know v6.5 is no longer supported by Microsoft and that moving to SQL2000 might resolve our problem. Actually the migration to SQL2000 is 1 to 2 months out and in...
10
by: Grumpy Aero Guy | last post by:
Visual Studio .net Academic Edition: After creating a OLEdbDataadapter, followed by an OLE DB Connection (all of which occurs successfully, by the way), I am unable to create a Dataset. I...
16
by: gumby | last post by:
I'm having trouble getting HADR to work with the sample databases on two HS20 xSeries blades, Red Hat ES4 up3, DB2 8.2.4, getting the following error. SQL1768N Unable to start HADR. Reason code...
12
by: mvsguy | last post by:
I'm an Access noob and apologize if I'm asking a stupid question. The problem is that I'm unable to design/preview reports on a database. How do I go about fixing this? Background - A user has...
1
by: SkyGringo | last post by:
Hi. We are using SQL Server 2005 64-bit on Windows Server 2003 R2 x64 Enterprise Edition. I have a really weird problem where I have people out there who are placed in the db_owner,...
4
by: =?Utf-8?B?VG9kZCBKYXNwZXJz?= | last post by:
Hey guys, I've written a web application that I'm simply trying to use to access a database. When I run the application locally (or as an NT Service) it can easily access the remote SQL...
5
Markus
by: Markus | last post by:
I'll leave out the annoying 'i'm a newbie' speech and get to the point: i'm a newbie at perl ;) First thing i ever wrote in perl and it doesnt work. I'm using xampp as my localhost - with perl...
1
by: grzegorz.gazda | last post by:
I had to detach the database to delete the transaction log as it took the hole disk space. No I am trying to attach database, however I am not able to do so. The engine is asking me whether I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.