[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: how to read existing databases copied from somewhere else
From:       Reindl Harald <h.reindl () thelounge ! net>
Date:       2012-02-27 9:30:40
Message-ID: 4F4B4D40.6060302 () thelounge ! net
[Download RAW message or body]


Am 27.02.2012 09:05, schrieb Pengkui Luo:
> Hi, I am new to mysql and have a question regarding how to read/import
> existing mysql databases (i.e. binaries, not sql dumps) copied from
> somewhere.
> 
> However, the "show databases;" command did not give me the "foo" database;
> and the "use foo;" command was denied access. Does it have to do with the
> grant table? 

no, you missed to set the permissions to the datadir
if you copy the whole datadir grant tables are part
of your structure becuase they are defined in the
database "mysql" as also passwords


["signature.asc" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]