Unknown database error

2012-10-29 Thread javad bakhshi
Hi,

I get an Unknown database error when I am trying to connect to mysql using C 
API.

I have created the database in mysql prompt as root:

CREATE DATABASE Lr0;

I am pretty sure that the problem is a ownership issue, because when I do
ls -l in my datadir I get:

[javad64@udbl64 data]$ ls -l
total 20532
-rw-rw 1 javad64 mysql   10485760 Oct 26 14:10 ibdata1
-rw-rw 1 javad64 mysql    5242880 Oct 26 14:10 ib_logfile0
-rw-rw 1 javad64 mysql    5242880 Oct 19 15:28 ib_logfile1
drwx-- 2 javad64 javad64 4096 Oct 26 14:35 Lr0
drwx-- 2 javad64 mysql   4096 Oct 22 11:04 mysql
drwx-- 2 javad64 mysql   4096 Oct 22 11:04 test

which shows Lr0 doesn't have mysql ownership.

my question is:
1- Why does this happen? While I am creating the 
database in mysql prompt as root.

2- How can I fix it? I don't have root access in the system I am using
so the chown solution is off table.


 
Best regards,
Javad Bakhshi,
Computer Science M.Sc
Department of IT, Uppsala University


Re: Unknown database error

2012-10-29 Thread Michael Dykman
The contents of datadir is typically owned by the mysql user and group.
Certain attributes on the datadir itself (ls -ld $datadir) can affect the
permissions of newly-created files and directories.  You need to talk to
you sysadmin,  with a eye towards doing something like

chown -R mysql:mysql $datadir

I honestly cannot think of a scenario where the datadir should be
permissioned any other way.

On 2012-10-29 6:26 AM, javad bakhshi javadbakh...@yahoo.com wrote:

Hi,

I get an Unknown database error when I am trying to connect to mysql using
C API.

I have created the database in mysql prompt as root:

CREATE DATABASE Lr0;

I am pretty sure that the problem is a ownership issue, because when I do
ls -l in my datadir I get:

[javad64@udbl64 data]$ ls -l
total 20532
-rw-rw 1 javad64 mysql   10485760 Oct 26 14:10 ibdata1
-rw-rw 1 javad64 mysql5242880 Oct 26 14:10 ib_logfile0
-rw-rw 1 javad64 mysql5242880 Oct 19 15:28 ib_logfile1
drwx-- 2 javad64 javad64 4096 Oct 26 14:35 Lr0
drwx-- 2 javad64 mysql   4096 Oct 22 11:04 mysql
drwx-- 2 javad64 mysql   4096 Oct 22 11:04 test

which shows Lr0 doesn't have mysql ownership.

my question is:
1- Why does this happen? While I am creating the
database in mysql prompt as root.

2- How can I fix it? I don't have root access in the system I am using
so the chown solution is off table.



Best regards,
Javad Bakhshi,
Computer Science M.Sc
Department of IT, Uppsala University


FW: BSD: Random unknown database error

2002-04-19 Thread Dan S. Camper

Update:

After finding a reference to problems with BSDI and the realpath() system
call in the mailing list archives, I tried rebuilding MySQL with the
HAVE_BROKEN_REALPATH flag defined.  That seemed to clear up the problem, at
least with the testing that I performed.  YMMV.

DSC
_
Dan S. Camper Borrowed Time, Inc.
Software Thaumaturge   http://www.bti.net


-- Forwarded Message
 From: Dan S. Camper [EMAIL PROTECTED]
 Date: Thu, 18 Apr 2002 12:41:31 -0500
 To: MySQL [EMAIL PROTECTED]
 Subject: BSD: Random unknown database error
 
 All:
 
 Recently I've run into a problem where I intermittently receive an Unknown
 database error while attempting to communicate with a local MySQL server.  I
 read through the mail list archives and discovered that others reported
 similar problems under BSD, but I didn't see any concrete solutions.  I may
 not be able to provide a solution, but I believe I can pinpoint the cause.
 
 Let me apologize now for the length of this message.  I'm trying to explain
 enough so that someone else, more knowledgable about MySQL's internals, can
 either use it to solve the problem or refute my guess.
 
 First, my environment:  MacOS X (10.1.4), MySQL 3.23.49, running on a G3
 PowerBook (Firewire), latest dev tools from Apple.  The MySQL server is
 running on that system as well as my own C++ code.
 
 Before seeing the problem within MySQL I found a problem with my own
 multithreaded code.  Each thread is responsible for loading a file in one
 directory and then manipulating a couple of other files in a different
 directory, all referenced relatively to the application's directory.  When the
 load got high -- there were many concurrent threads -- I would intermittently
 receive an error from the OS telling me that one of the files I was trying to
 open could not be found.  Given that the file in question was one that was
 supposed to always be present, I grew suspicious.  After a bit of debugging,
 imagine my surprise when I discovered that the full pathname the OS was trying
 to use was wrong.  Example
 
   Source file:foo/text.txt
   Dest file:  data/index.txt
   App directory:  /Users/lordgrey/Projects/myproject/
 
 When the problem occurred while opening the dest file, referenced relatively,
 the OS was actually trying to open:
 
   /Users/lordgrey/Projects/myproject/foo/data/index.txt
 
 instead of
 
   /Users/lordgrey/Projects/myproject/data/index.txt
 
 Once I nailed down a variable with the current working directory at
 application launch time and used that to fully qualify my datafiles, all of my
 problems disappeared.
 
 As further testing, I started cranking up the number of threads.  Now, in
 addition to dinking around with files, each thread has its own MySQL
 connection.  Increasing the number of threads started causing the unknown
 database error to appear, pretty much in direct proportion to the number
 threads.
 
 The other problem reports in the archive noted that the unknown database
 problem seemed to occur when the system's load was high.  That would agree
 with what I found.
 
 Anyway, it occurs to me that MySQL is failing to find a database -- which is a
 directory -- for the same reason that my code couldn't find its own data
 files.  Namely:  MySQL is using a relative path, BSD is mucking around with
 the concept of current working directory incorrectly and it's colliding with
 other concurrent threads also trying to use relative paths.
 
 I haven't picked the MySQL source code apart to see if this is really the case
 or not, but it seems reasonable.  If it's true then the actual problem lies in
 BSD/MacOS/etc. but it can be worked around in the MySQL server.
 
 Cheers,
 
 DSC

-- End of Forwarded Message


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




BSD: Random unknown database error

2002-04-18 Thread Dan S. Camper

All:

Recently I've run into a problem where I intermittently receive an Unknown
database error while attempting to communicate with a local MySQL server.
I read through the mail list archives and discovered that others reported
similar problems under BSD, but I didn't see any concrete solutions.  I may
not be able to provide a solution, but I believe I can pinpoint the cause.

Let me apologize now for the length of this message.  I'm trying to explain
enough so that someone else, more knowledgable about MySQL's internals, can
either use it to solve the problem or refute my guess.

First, my environment:  MacOS X (10.1.4), MySQL 3.23.49, running on a G3
PowerBook (Firewire), latest dev tools from Apple.  The MySQL server is
running on that system as well as my own C++ code.

Before seeing the problem within MySQL I found a problem with my own
multithreaded code.  Each thread is responsible for loading a file in one
directory and then manipulating a couple of other files in a different
directory, all referenced relatively to the application's directory.  When
the load got high -- there were many concurrent threads -- I would
intermittently receive an error from the OS telling me that one of the files
I was trying to open could not be found.  Given that the file in question
was one that was supposed to always be present, I grew suspicious.  After a
bit of debugging, imagine my surprise when I discovered that the full
pathname the OS was trying to use was wrong.  Example

Source file:foo/text.txt
Dest file:  data/index.txt
App directory:  /Users/lordgrey/Projects/myproject/

When the problem occurred while opening the dest file, referenced
relatively, the OS was actually trying to open:

/Users/lordgrey/Projects/myproject/foo/data/index.txt

instead of

/Users/lordgrey/Projects/myproject/data/index.txt

Once I nailed down a variable with the current working directory at
application launch time and used that to fully qualify my datafiles, all of
my problems disappeared.

As further testing, I started cranking up the number of threads.  Now, in
addition to dinking around with files, each thread has its own MySQL
connection.  Increasing the number of threads started causing the unknown
database error to appear, pretty much in direct proportion to the number
threads.

The other problem reports in the archive noted that the unknown database
problem seemed to occur when the system's load was high.  That would agree
with what I found.

Anyway, it occurs to me that MySQL is failing to find a database -- which is
a directory -- for the same reason that my code couldn't find its own data
files.  Namely:  MySQL is using a relative path, BSD is mucking around with
the concept of current working directory incorrectly and it's colliding
with other concurrent threads also trying to use relative paths.

I haven't picked the MySQL source code apart to see if this is really the
case or not, but it seems reasonable.  If it's true then the actual problem
lies in BSD/MacOS/etc. but it can be worked around in the MySQL server.

Cheers,

DSC
_
Dan S. Camper Borrowed Time, Inc.
Software Thaumaturge   http://www.bti.net



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




random (load-related?) unknown database errors

2002-03-22 Thread Jeff DeFouw

MySQL every so often will return unknown database errors for no apparent
reason on a FreeBSD 4.4 (and earlier 4.x versions) server I maintain.  
This affects different user, scripts, and databases.  One user says there
is a big slowdown around each event, perhaps a load issue, but at least
when I check the symptoms are gone.  The databases clearly haven't moved.  
What could cause this?  Are there any fixes or workarounds?

I also see the 99% CPU issue frequently, but as I see in the list archive
that hasn't been tracked down yet.

--
Jeff DeFouw [EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Unknown database

2002-03-20 Thread Ozette Brown

MySQL Error: 1049 (Unknown database 'databasename')

I having a very weird unpredictable problem.  I have a webserver which
makes database connections via Perl and DBI.  For the most part it works
pretty much all the time but sometimes (2 or 4 times per month) it gives
an error:  Unknown database 'databasename'.

Now,  nothing has changed.  I'm notified of the unknown database
message, then when I check things out, I'm able to connect to the
database.  This very strange.

While searching the archives, I noticed at least 2 other people with the
same problem and we are all running some 4.x version of FreeBSD.

Does anyone have any ideas?

Any help is very much appreciated.

Thanks,

Ozette



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Symbolically linked database, unknown database problem.

2001-12-06 Thread Peter Campbell


I've created databases on a partition without problems, now I come 
to create a new database on a different partition and I can't access 
the database at all.

At this stage I have the following in the mysql data directory 
(among others):

lrwxrwxrwx1 mysqlmysql  17 Sep  3 11:56 candi - 
/asp/mysql/candi/
lrwxrwxrwx1 mysqlmysql  24 Dec  7 12:40 cc - 
/home/fastbase/cc/mysql/

The first database (candi) is fine (along with others in the 
/asp/mysql path) but the cc database is not accessible.

If I log-in as user mysql I can access that directory fine so I 
thought it may be another problem but I guess rights may still be an 
issue.

Any ideas?
What are the rules/requirements for mysql to recognise the 
database directory?

I haven't created any tables yet (as I can't access the database).



Peter Campbell
http://www.fastbase.co.nz
Phone NZ 04 385 2230, Fax 04 385 2224.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Symbolically linked database, unknown database problem.

2001-12-06 Thread Quentin Bennett

Hi,

Try ls -Ll cc, to check that the link is valid and to see the permissions on
the destination.

HTH 

Quentin
-Original Message-
From: Peter Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, 7 December 2001 12:57 p.m.
To: [EMAIL PROTECTED]
Subject: Symbolically linked database, unknown database problem.



I've created databases on a partition without problems, now I come 
to create a new database on a different partition and I can't access 
the database at all.

At this stage I have the following in the mysql data directory 
(among others):

lrwxrwxrwx1 mysqlmysql  17 Sep  3 11:56 candi - 
/asp/mysql/candi/
lrwxrwxrwx1 mysqlmysql  24 Dec  7 12:40 cc - 
/home/fastbase/cc/mysql/

The first database (candi) is fine (along with others in the 
/asp/mysql path) but the cc database is not accessible.

If I log-in as user mysql I can access that directory fine so I 
thought it may be another problem but I guess rights may still be an 
issue.

Any ideas?
What are the rules/requirements for mysql to recognise the 
database directory?

I haven't created any tables yet (as I can't access the database).



Peter Campbell
http://www.fastbase.co.nz
Phone NZ 04 385 2230, Fax 04 385 2224.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Unknown database problem

2001-08-31 Thread Artem Koutchine

Hi!

I having a very weird unpredictable problem.
A script run from cron at 2:00am every day
must conect to database 'ubex' and do some
stuff with it. The script is in perl and uses DBI.
It works fine pretty much all the time but sometimes
(1 or 2 time per month) it gives an error:

Unknown database 'ubex'

Mysql is 3.23.40, OS is FreeBSD 4.4-RC, Perl is 5.005_03
DBI.pm  is 1.14 (ID: v. 10.32 2000/06/14 20:04:03)
MySQL DBD is 2.0409  (ID: v 1.5 1999/10/03 17:46:19)

The same happens with other databases accessed from
a script run from a cron.

What could be wrong?

Regards,
Artem


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: phpmyadmin + mysql +Unknown database 'test'

2001-05-18 Thread Prasad R.L

Hi,

Well, I also had the same problem and finally traced the bug down
to a file called db_readdump.php3 in phpmyadmin directory. 

If you'r still having the problem, may be this is helpful to you too.

edit db_readdump.php3 and add in the beginning of the file 

   $db = trim($db); 

Then at the bottom of the code (somewhere around line no.45)
you will find.. 

if(!empty($sql_file)  $sql_file != none  ereg(^php[0-9A-Za-z_.-]+$,
basename($sql_file)))
{
$sql_query = addslashes(fread(fopen($sql_file, r),
filesize($sql_file)));
}

Cut this part of code and paste it just below, the following code... 

$pieces  = split_sql($sql_query);

if (count($pieces) == 1  !empty($pieces[0]))
{
   $sql_query = trim($pieces[0]);
   include (sql.php);
   exit;
}

thats it, 

Hope this helps,

Regards,

Sivaprasad. R.L
http://netlogger.net


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Error 1049 - Unknown database...

2001-05-14 Thread Vibol Hou

Hi,

I have a MySQL 3.23.37 server that runs on a FreeBSD 4.2 SMP box which runs
some semi-intensive web applications.  The system itself has 1GB memory.

A few times a minute, I get the following error from my applications:

MySQL Error: 1049 (Unknown database 'databasename')

The server receives about 105 queries/sec.  The queries range from simple
select statements to joins between several tables on databases no larger
than a total of 800MB and also include insert, delete, and update
statements.  A good mix of everything.

The application is able to connect, but the queries run against the database
indicate the above error 2-3 times a minute.

I've experienced this with 3.23.32 as well and upgraded to 3.23.37.

Does anyone experienced with MySQL internals know what's going on?

--
Vibol Hou
KhmerConnection
http://khmer.cc


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Error 1049 - Unknown database...

2001-05-14 Thread Samuel Chen

Just starting using mysql. I am just guesing here :-).

It seems to me that it is looking for a database called
databasename?  Perhaps somewhere in your application
you are asking the mysql about databasename database.
I mean, is it possible that you forgot to replace
databasename with the real database name in your application?

s.

- Original Message - 
From: Vibol Hou [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, May 14, 2001 4:53 PM
Subject: Error 1049 - Unknown database...


 Hi,
 
 I have a MySQL 3.23.37 server that runs on a FreeBSD 4.2 SMP box which runs
 some semi-intensive web applications.  The system itself has 1GB memory.
 
 A few times a minute, I get the following error from my applications:
 
 MySQL Error: 1049 (Unknown database 'databasename')
 
 The server receives about 105 queries/sec.  The queries range from simple
 select statements to joins between several tables on databases no larger
 than a total of 800MB and also include insert, delete, and update
 statements.  A good mix of everything.
 
 The application is able to connect, but the queries run against the database
 indicate the above error 2-3 times a minute.
 
 I've experienced this with 3.23.32 as well and upgraded to 3.23.37.
 
 Does anyone experienced with MySQL internals know what's going on?
 
 --
 Vibol Hou
 KhmerConnection
 http://khmer.cc
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Error 1049 - Unknown database...

2001-05-14 Thread Vibol Hou

I'm going to add that there is nothing wrong with the database name that is
in the query.  If the same query, with slightly different constraints and
the _exact_ same database name, is run 1000 times and 3 of them give the
Unknown database error, that rules out an application error.

Furthermore, if it is  a SQL error, then MySQL would likely return an error
that indicates a SQL error rather than an Unknown database error.

Thanks,
--
Vibol Hou
KhmerConnection
http://khmer.cc

-Original Message-
From: Vibol Hou [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:54 PM
To: MySQL List
Subject: Error 1049 - Unknown database...


Hi,

I have a MySQL 3.23.37 server that runs on a FreeBSD 4.2 SMP box which runs
some semi-intensive web applications.  The system itself has 1GB memory.

A few times a minute, I get the following error from my applications:

MySQL Error: 1049 (Unknown database 'databasename')

The server receives about 105 queries/sec.  The queries range from simple
select statements to joins between several tables on databases no larger
than a total of 800MB and also include insert, delete, and update
statements.  A good mix of everything.

The application is able to connect, but the queries run against the database
indicate the above error 2-3 times a minute.

I've experienced this with 3.23.32 as well and upgraded to 3.23.37.

Does anyone experienced with MySQL internals know what's going on?

--
Vibol Hou
KhmerConnection
http://khmer.cc


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Unknown Database, Error 1049 problems...

2001-03-28 Thread Gerald Clark

Jason Guritz wrote:
 
 mysql show databases;
 +---+
 | Database  |
 +---+
 | directory |
 | mysql |
 | phpBB |
 | testdb  |
 | trial |
 +---+
 5 rows in set (0.00 sec)
 
 mysql use testdb;
 ERROR 1049: Unknown database 'testdb'
 
 Keeps happening to me too.
 
 It was working the day before :(
 
 Jason
Were you moving directories around?
Looks like testdb has some spaces or other unprintable characters in its 
directory name.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Unknown Database, Error 1049 problems...

2001-03-28 Thread jason

I know you people are busy but I have seen this question a few times on the lists to 
no avail. *see below*

It has been figured out by my admin.

It appears that one or more entries in the ACL tables is corrupt, when this happens so 
its preventing logins.

So you have to replace the ACL with a fresh copy and then replace all the domain and 
passwords.

I am not pretending in any way to know what I am talking about compared to anyone 
else. You are the experts but I thought you might
want to know for the future. When the exact problem pops up again.

Kindest regards,

Jason

mysql show databases;
+---+
| Database  |
+---+
| directory |
| mysql |
| phpBB |
| testdb|
| testdb2   |
+---+
5 rows in set (0.00 sec)

 mysql use testdb2;
ERROR 1049: Unknown database 'testdb2'


Thats the error message that can be fixed by replacing the ACL. This is of course when 
there is no trailing white space or anything
else wrong.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




phpmyadmin + mysql + Unknown database 'test'

2001-03-19 Thread - = k o l i s k o = -

Hi!

I have installed many of mysql servers and phpMyAdmin clients.
And every time it worked together fine.

Now i have problem on RH70 with mysql and phpMyAdmin:


Database pokus
Error
SQL-query:

Content-Type: application/octet-stream
MySQL said: Unknown database ' pokus'
Back
--

this error is writed when i manualy write sql command to create a new table
in standard database 'test'.

My sql command:

create table aaa (bbb text);

I am logged to phpMyAdmin as a 'root' user with all privileges trough
'advanced' authentification:

 begin cut config.inc.php 
$cfgServers[1]['host'] = 'localhost';   // MySQL hostname
$cfgServers[1]['port'] = '';// MySQL port - leave blank
for default port
$cfgServers[1]['adv_auth'] = true; // Use advanced
authentication?
$cfgServers[1]['stduser'] = 'root'; // MySQL standard user (only
needed with advanced auth)
$cfgServers[1]['stdpass'] = '';  // MySQL standard password
(only needed with advanced auth)
$cfgServers[1]['user'] = 'root';// MySQL user (only needed
with basic auth)
$cfgServers[1]['password'] = '';// MySQL password (only
needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only
this db is accessible
$cfgServers[1]['verbose'] = ''; // Verbose name for this
host - leave blank to show the hostname
 end cut config.inc.php -


other info:
[root@ns /root]# rpm -qa | grep mysql
mysql-3.23.32-1.7
mysqlclient9-3.23.22-3
mysql-server-3.23.32-1.7
php-mysql-4.0.4pl1-3
[root@ns /root]#

[root@ns /root]# uname -a
Linux ns.euronet.sk 2.2.17-14 #1 Mon Feb 5 16:02:20 EST 2001 i686 unknown
[root@ns /root]#

--- begin cut /var/log/mysqld.log: -
010319 12:33:37   1 Connectroot@localhost on
  1 Init DBmysql
  1 Query  SELECT User, Password, Select_priv FROM
user where User = 'root' AND Password = PASSWORD('')
  1 Query  SELECT VERSION() AS version
  1 Quit
--- end cut /var/log/mysqld.log -



Any idea?

Thank You for help!


S pozdravem,
Michal Kolesar
+420 608 225025
[EMAIL PROTECTED]
http://www.egarden.cz
server of free unix services



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php