List:General Discussion« Previous MessageNext Message »
From:frederic nivor Date:March 8 2013 4:32pm
Subject:Re: mysql table hidden while operation on it still work
View as plain text  
when I :
show databases;
I got:
+--------------------+
| Database           |
+--------------------+
| information_schema |
| Applications       |
| Developer          |
| Library            |
| System             |
| bin                |
| cores              |
| etc                |
| private            |
| sbin               |
| usr                |
| var                |
+--------------------+
which are some directories at root / (except for information_schema),
so I thought my datadir variable was not well configured, but when I :
show variables;
I got :
datadir
/var/mobile/Applications/EED44E40-E013-44DE-9DB4-D6DB6D491F72/Library/data/
which is the right path, where mysql and performance_schema folders are
stored.

Still couldn't access mysql database…


On Friday, March 8, 2013, frederic nivor <nouatzi@stripped> wrote:
> I've just installed the mysql, and its default database (mysql and
performance_schema), so I connect with:
> mysql -u root
> Initialy there is not password.
> and when I :
> show grants for 'root'@'localhost';
> I got :
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
> GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
>
> On Friday, March 8, 2013, Reindl Harald <h.reindl@stripped> wrote:
>>
>>
>> Am 08.03.2013 15:53, schrieb frederic nivor:
>>> I use mysql-5.6.10 on a cross-platform.
>>> when I :
>>> use mysql;
>>> I got :
>>> ERROR 1049 (42000): Unknown database 'mysql'
>>> but when I :
>>> select  User,Host,Password from mysql.user;
>>> I got the right results.
>>> Did I do something wrong in configuration ?
>>
>> what user?
>> what permissions has the user?
>>
>>

Thread
mysql table hidden while operation on it still workfrederic nivor8 Mar
  • Re: mysql table hidden while operation on it still workReindl Harald8 Mar
    • Re: mysql table hidden while operation on it still workfrederic nivor8 Mar
      • Re: mysql table hidden while operation on it still workfrederic nivor8 Mar
        • Re: mysql table hidden while operation on it still workReindl Harald8 Mar