473,242 Members | 1,473 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,242 software developers and data experts.

MySQL Database improperly setup?

I installed mySQL and have it running.... but I think I made a
mistake somewhere along the line...... I believe I did follow the
instructions that were provided with the distribution at:
http://dev.mysql.com/downloads/

The database is up. It seems that a test database
instance has been created (named "test"). I can see
it. However, the other database instance that should
have been created, named "mysql" doesn't show up when
I do "show databases". (see below). I think that particular
instance is required for things to work right.

I have also included directory listings of my
/usr/local/mysql directory so you can see that files
for the "mysql" instance really have been created,
with the proper permissions.
Has anyone ever run into this issue? If so do you know
how to get around it??

Thanks......



% mysql
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 7 to server version:
4.0.21-standard

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)
mysql> quit;



[root@localhost data]# pwd
/usr/local/mysql/data
[root@localhost data]# ls -al
total 20576
drwxr-x--- 4 mysql users 4096 Sep 25 02:10 .
drwxr-xr-x 14 root root 4096 Sep 24 22:20 ..
-rw-rw---- 1 root mysql 25088 Sep 24 23:15
ib_arch_log_0000000000
-rw-rw---- 1 root mysql 10485760 Sep 25 02:10 ibdata1
-rw-rw---- 1 root mysql 5242880 Sep 25 02:10 ib_logfile0
-rw-rw---- 1 root mysql 5242880 Sep 24 23:15 ib_logfile1
-rw-rw---- 1 mysql root 5955 Sep 25 02:10
localhost.localdomain.err
-rw-rw---- 1 mysql mysql 6 Sep 25 02:10
localhost.localdomain.pid
drwxr-x--- 2 mysql mysql 4096 Sep 24 22:19 mysql
drwxr-x--- 2 mysql mysql 4096 Sep 6 23:23 test
[root@localhost data]# ls -alR mysql test
mysql:
total 112
drwxr-x--- 2 mysql mysql 4096 Sep 24 22:19 .
drwxr-x--- 4 mysql users 4096 Sep 25 02:10 ..
-rw-rw---- 1 mysql mysql 8778 Sep 24 22:19
columns_priv.frm
-rw-rw---- 1 mysql mysql 0 Sep 24 22:19
columns_priv.MYD
-rw-rw---- 1 mysql mysql 1024 Sep 24 22:19
columns_priv.MYI
-rw-rw---- 1 mysql mysql 9088 Sep 24 22:19 db.frm
-rw-rw---- 1 mysql mysql 306 Sep 24 22:19 db.MYD
-rw-rw---- 1 mysql mysql 3072 Sep 24 22:19 db.MYI
-rw-rw---- 1 mysql mysql 8641 Sep 24 22:19 func.frm
-rw-rw---- 1 mysql mysql 0 Sep 24 22:19 func.MYD
-rw-rw---- 1 mysql mysql 1024 Sep 24 22:19 func.MYI
-rw-rw---- 1 mysql mysql 9064 Sep 24 22:19 host.frm
-rw-rw---- 1 mysql mysql 0 Sep 24 22:19 host.MYD
-rw-rw---- 1 mysql mysql 1024 Sep 24 22:19 host.MYI
-rw-rw---- 1 mysql mysql 8877 Sep 24 22:19
tables_priv.frm
-rw-rw---- 1 mysql mysql 0 Sep 24 22:19
tables_priv.MYD
-rw-rw---- 1 mysql mysql 1024 Sep 24 22:19
tables_priv.MYI
-rw-rw---- 1 mysql mysql 9806 Sep 24 22:19 user.frm
-rw-rw---- 1 mysql mysql 248 Sep 24 23:55 user.MYD
-rw-rw---- 1 mysql mysql 2048 Sep 24 23:58 user.MYI

test:
total 8
drwxr-x--- 2 mysql mysql 4096 Sep 6 23:23 .
drwxr-x--- 4 mysql users 4096 Sep 25 02:10 ..
Jul 20 '05 #1
2 2315
Saqib Ali wrote:
% mysql
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 7 to server version:
4.0.21-standard

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql> show databases;


Try:

% mysql -u root

....

mysql> show databases;

And if that doesn't work, try also:
mysql> use mysql;
Jul 20 '05 #2
Saqib Ali wrote:
However, the other database instance that should
have been created, named "mysql" doesn't show up when
I do "show databases". (see below). I think that particular
instance is required for things to work right.


Indeed, that is correct.

Try running the mysql tool with specifying a user:

$ mysql -u root

Only the test database is set up with wide open privileges (I mean mysql
privileges, which are different from the Unix file permissions). Other
databases often require some user.

Bill K.
Jul 20 '05 #3

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

Similar topics

5
by: lkrubner | last post by:
I have a webserver through Rackspace. I create a domain. I create an FTP user. I upload some files. I create a database called testOfSetupScript and then I create a database user named setup. I...
0
by: David Bernick | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 We're doing a select query on our INNODB database. Linux 2.4.21 on x86 (Athlon). Mysql is 4.0.13. Anyone seen this problem before? - ----- InnoDB:...
0
by: Richard Gabriel | last post by:
Hi all, The following keeps happening and I can't pinpoint a query that is causing it. It did not happen in 3.23.x, but started upon upgrading to 4.0.14. The operating system/hardware...
0
by: Henry Hank | last post by:
Environment: I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the kernel to 2.4.20-19.9smp....
0
by: Johannes B. Ullrich | last post by:
--=-WKgoK98ejo9BZyGYc3N/ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable I am having problems with MySQL 4.0.12 on RedHat Advanced Server 2.1 using a dual Xeon with 8...
4
by: Adam Smith | last post by:
I have a dedicated server running 'FreeBSD 4.9 STABLE' at a hosting site. They have done some default installations, presumably from the CVS ports package ??. Herein lies the problem, "I do not...
74
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either...
13
by: Jim Hubbard | last post by:
I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the...
13
by: Richard Brooks | last post by:
Does anyone here open a second MySQL database and use that as a straight IDX type file that points to the record number in the main database, for speed's sake? Some time ago I'd set up a...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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...

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.