开发者

Listing MySQL databases on a local XAMPP install

I have a local MySQL install via XAMPP, running on OSX. PHPMyAdmin lists the databases that are running under the MySQL install, but when I run

mysql > show databases;

Only information_schema is listed. Wh开发者_Go百科at's the best way to go about troubleshooting this?


You are probably not connecting to MySQL with the right credentials.

Try supplying a username/password/host combination that actually has permissions to list databases through show databases command.

Something like this:

$ mysql -u root -h X.Y.Z.A -p

Then supply root's password. And I mean MySQL's root, not your OS X's root password.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜