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 <noua...@gmail.com> 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.rei...@thelounge.net> 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? >> >>
