phpMyAdmin 表底部出现 Connection for controluser as defined in your configuration failed.
来源:互联网 发布:手机变成电脑桌面软件 编辑:程序博客网 时间:2024/06/01 12:42
参考链接 http://ubuntuforums.org/showthread.php?t=1152326
I found how to correct the problem in case anyone else needs a quick fix:
When recently upgrading my server to Ubuntu 9.04, phpMyAdmin was also upgraded to version 5.0.75. When I loaded up the new version, I was alarmed to find a new error message that read: Connection for controluser as defined in your configuration failed.
It turned out this error was due to the fact that version 5 of phpMyAdmin adds support for a new feature known as a linked-tables infrastructure. This infrastructure allows for new features such as bookmarks, comments, SQL-history, PDF-generation, and field contents transformation. The problem was that this new feature is enabled by default, with generic credentials set up for the controluser. If you don't have your database set up for the infrastructure, you will see the error. I have no use for these new features, so I'd rather just not mess with them. If you do want to enable the advanced features, here is an informative post about doing so on Ubuntu. If you just want to disable the linked-tables infrastructure, which is often the easiest and least intrusive way, just follow these steps:
1. Type nano /etc/phpmyadmin/config.inc.php in the Linux terminal. You can substitute nano for vi or your favorite text editor.
2. Find the two blocks of text that read:
$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;
one is near the top embedded in an if statement, and the other is towards the bottom. The text is not exactly the same for each block, but $cfg['Servers'][$i]['controluser'] is what matters. The block that is actually used by phpMyAdmin depends on your setup, but just for simplicity we will apply the change to both.
3. Just comment out those four lines by adding a // in front of each one.
4. Save, and the error should disappear next time you access phpMyAdmin. If you are still having trouble, feel free to post a comment.
大意是因为某些高级功能点引起,将 /etc/phpmyadmin/config.inc.php 文件里的
$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;
注解了就好
- phpMyAdmin 表底部出现 Connection for controluser as defined in your configuration failed.
- Connection for controluser as defined in your configuration failed.
- ubuntu 下解决phpmyadmin error: “Connection for controluser as defined in your configuration failed”
- Connection for controluser as defined in your configuration failed phpmyadmin xampp
- phpmyadmin (Invalid hostname for server 1. Please review your configuration)
- 使用phpmyadmin出现The mbstring extension is missing. Please check your PHP configuration是什么原因?
- macOS卸载MySQL数据库与workbench提示"Your connection attempt failed for user 'root' from your host ..."解决方法
- hadoop出现Cannot initialize Cluster. Please check your configuration for mapreduce.framework.name
- A TensorBoard plugin for visualizing arbitrary tensors in a video as your network trains.
- Your configuration does not allow connection to http://packagist.org
- Composer异常: Your configuration does not allow connection to xx.
- phpmyadmin出现“Cannot start session without errors, please check errors given in your PHP and/or webs”
- Host Credentials报错"Connection to host as user oracle failed: ERROR: Wrong password for user"的解决一例
- 新版as出现failed for task ':app:clean'.xxxxxx的问题
- AS中运行项目时出现Error:Execution failed for task ':app:transformClassesWithDexForDebug'...问题解决
- 解决AS混淆时出现的错误Execution failed for task ':app:transformClassesAndResourcesWithProguardForRelease'
- AS编译时再部分手机出现Error:Execution failed for task ':app:transformClassesWithDexForDebug'. > com.
- AS导入项目出现Error:Execution failed for task ':app:processDebugManifest'.错误
- “五一”真正的劳动节
- Cocos2d-x +Android + Windows 7
- C#中如何读取数据库中的图片
- linux 下对硬盘设备的操作
- android应用程序跳转到系统的各个设置页面
- phpMyAdmin 表底部出现 Connection for controluser as defined in your configuration failed.
- mysql error 大全
- java.lang.NoClassDefFoundError: javax.activation.DataHandler的解决办法
- ZigZag Conversion
- jpeg入门学习笔记
- 高流量高并发网站架构(转)
- loj 1224 - DNA Prefix
- 非常简单的利用CreateProcess注入DLL的方法
- VirtualBox 共享文件夹设置