473,503 Members | 1,625 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

See test but don't see mysql

Downloaded and installed 4.0.21 on WinXP SP2 system. Started server via
Start, Run, c:\mysql\bin\mysqld.exe. From DOS window, mysql.exe starts
without complaint, but "show databases;" only reveals "test" and not
"mysql", although c:\mysql\data clearly has subdirectories "test" [which is
empty] and "mysql" [which has various triplets of files]. Why is database
"mysql" not shown? Thanks.
Jul 20 '05 #1
1 1380
Frank Natoli wrote:
Downloaded and installed 4.0.21 on WinXP SP2 system. Started server via
Start, Run, c:\mysql\bin\mysqld.exe. From DOS window, mysql.exe starts
without complaint, but "show databases;" only reveals "test" and not
"mysql", although c:\mysql\data clearly has subdirectories "test" [which is
empty] and "mysql" [which has various triplets of files]. Why is database
"mysql" not shown? Thanks.


You didn't specify a user name who has privilege to browse the mysql
database. Try running `mysql.exe -u root'.

Bill
Jul 20 '05 #2

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

Similar topics

5
2003
by: lawrence | last post by:
I posted before, but have now narrowed my problem down to this method. At the start of the method, I test to make sure that I have a resource, a pointer to data returned from a database. This test...
5
2997
by: Richard Wesley | last post by:
I don't know if this is really a Python question of a MySQL question, but i am hopen that there is enough overlap that someone can help me ;-) I have a unit test suite for our server that loads a...
0
2334
by: Sean Ian Rice | last post by:
--B_3140504535_1583437 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Hello. Thought I=B9d pass this along to whoever cares. Issue: error running...
0
1483
by: Jamie Krasnoo | last post by:
Hey all, I was trying to compile, test and install MySQL-4.0.13. Compile went well and it was configured with --with--innodb --enable-assembler --prefix=/usr and nothing else. However when I...
0
1619
by: Jamie Krasnoo | last post by:
Could anyone tell me how to get past this error please? When I 'make test' some of the tests run but then it dies with. create ERROR:...
0
5685
by: Daniel Kasak | last post by:
Hi all. I need to test whether the first bit of a field is numeric. For example, the field might contain: 154 boxes I'm currently testing it by doing: if(abs(left(field,locate(' ',...
0
1339
by: Jason Kinkade | last post by:
I recently installed MySQL 4.0.18 on my slackware 9.1 machine (kernel 2.4.25) by compiling the source. It works fine, and all tests pass except one. The timezone test. Can someone tell me why...
11
9210
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
6
10051
by: sam | last post by:
Hi, I want to compile and test php script in my pc without using internet or web site which is online ? Do you have any idea about it? It is possible to do that ?
0
7188
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7258
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7313
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6970
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7441
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5558
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4663
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3146
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
366
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.