ds342222222 2015-05-25 18:48
浏览 50

OS X Yosemite - 无法登录MySQL服务器

I know this issue has been addressed before in other threads but so far none of their solutions worked. So I'm opening a new one...

I've used this Tutorial to setup a local wordpress page on my Mac (I'm running OS X Yosemite). But unfortunately every time I try to log into phpMyAdmin @ http://localhost/~usernam/phpmyadmin/index.php I get this error message: "(!) Cannot log in to the MySQL server "

Although if I log into mySQL through the terminal the same usernam/password work just fine.

I'm really not sure what's wrong and like a said I tried every solution suggested in any of the other threads with no success. Is there a way to troubleshoot via the terminal and print out what might be wrong so I could post it here?

Here is my config.inc.php

<?php
/*
 * Generated configuration file
 * Generated by: phpMyAdmin 4.4.7 setup script
 * Date: Mon, 25 May 2015 05:28:33 +0000
 */

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'MYPASSWORD';

/* End of servers configuration */

$cfg['blowfish_secret'] = '5562b2e8dedaf8.08870882';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

I've noticed, that when I change $cfg['Servers'][$i]['auth_type'] = 'cookie'; to $cfg['Servers'][$i]['auth_type'] = 'config'; I'm able to access the database but Wordpress ist still having trouble connecting...

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 php 将rtmp协议转hls协议,无法播放
    • ¥15 miniconda安装不了
    • ¥20 python代码编写
    • ¥20 使用MPI广播数据遇到阻塞
    • ¥15 TinyMCE如何去掉自动弹出的“链接…”工具?
    • ¥15 微信支付转账凭证,如何解决
    • ¥15 在win10下使用指纹登录时,界面上的文字最后一个字产生换行现象
    • ¥20 使用AT89C51微控制器和MAX7219驱动器来实现0到99秒的秒表计数,有开始和暂停以及复位功能,下面有仿真图,请根据仿真图来设计c语言程序
    • ¥15 51单片机 双路ad同步采样
    • ¥15 使用xdocreport 生成word