XAMPP MySQL 密码设置(PHPMYADMIN 中无法输入) [英] XAMPP MySQL password setting (Can not enter in PHPMYADMIN)

问题描述

首先:我无法在 "localhost:80/phpmyadmin/" 输入 PHPMYADMIN.因为当我使用用户名:root 和密码:HamdunSoft 安装 MySQL 服务器 mysql-5.5.36 时.之后，当我输入 localhost:80/phpmyadmin/时，它会显示如下消息.

Firstly: I am cannot entering PHPMYADMIN at "localhost:80/phpmyadmin/". Because when I install MySQL server mysql-5.5.36 with Username :root and Password : HamdunSoft . After that when I enter localhost:80/phpmyadmin/ it show me a message like below .

"错误 MySQL 说:文档1045 - 用户 'root'@'localhost' 的访问被拒绝(使用密码:否)配置中定义的 controluser 连接失败.phpMyAdmin 尝试连接 MySQL 服务器，但服务器拒绝连接.您应该检查配置中的主机、用户名和密码，并确保它们与 MySQL 服务器管理员提供的信息相对应."

"Error MySQL said: Documentation 1045 - Access denied for user 'root'@'localhost' (using password: NO) Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."

现在我想进入我的 Phpmyadmin，虽然我已经在 xampp 中设置了两个 MySQL 服务器，一个是 mysql-5.5.36.我在网上搜索过它，但内容没有足够的帮助.如何在登录 phpmyadmin 之前在 xampp 中设置密码.

Now I want enter my Phpmyadmin though I have setup two MySQL server one in xampp, another mysql-5.5.36. I have searched it in net but the content was not helpful sufficiently. How can I set the password in xampp before login in phpmyadmin .

另一个不同的问题是: XAMPP Apache 服务器说:有人正在使用端口 80.我通过停止 Skype 解决了这个问题.但是又遇到了这类问题.我认为像 Skype 一样，另一个软件正在使用端口 80.我想随心所欲地使用任何带有 Apache 的端口.它可能是端口 80 或 81 或 82.如果任何其他进程正在使用我想要的端口，我想替换它并将该端口提供给 Apache.

Another different issue is: XAMPP Apache server was saying : port 80 is being used by some one. I solved it by stopping Skype. But again having this types of problem. I think like Skype another software is using port 80. I want to use any port with Apache as I wish. It may be port 80 or 81 or 82. If any other process is using my desired port I want to replace that and give that port to Apache.

推荐答案

第一期:你想从Mysql运行Mysql server，从Xampp也想浏览phpmyadmin，这样你就可以操作数据库.然后按照规则:

First Issue: You want to run Mysql server from Mysql and from Xampp also want to browse phpmyadmin so that you can operate database.Then follow the rules:

从 config.inc.php 文件中的 "Xampp/phpmyadmin" 目录中找到以下代码.并按照下面给出的说明进行操作.我已经尝试过这样，并且成功地在浏览器、MySQL 命令提示符以及 MySQL 查询浏览器上运行了 localhost/phpMyAdmin.

From "Xampp/phpmyadmin" directory in config.inc.php file find the below code. And follow the given instructions below. I have tried like this and I was successful to run both localhost/phpMyAdmin on browser, MySQL Command prompt as well as MySQL query browser.

$cfg['Servers'][$i]['auth_type']    = 'config';
$cfg['Servers'][$i]['user']         = 'pma';
$cfg['Servers'][$i]['password']     = '';
$cfg['Servers'][$i]['controluser']  = 'user_name/root';   
$cfg['Servers'][$i]['controlpass']  = 'passwaord';

并将上面的每个语句替换为下面每个对应的代码.

And replace the above each statement with the below each corresponding code.

$cfg['Servers'][$i]['auth_type']    = 'config';
$cfg['Servers'][$i]['user']         = 'root';
$cfg['Servers'][$i]['password']     = 'Muhammad Ashikuzzaman';
$cfg['Servers'][$i]['controluser']  = 'root';   
$cfg['Servers'][$i]['controlpass']  = 'Muhammad Ashikuzzaman';

第二期:方式一:你可以先退出Skype.当 Apche 服务器启动时，您可以再次运行 Skype.如果您想在另一个端口上运行 Apache，请在第 184 行将 xampp/apache/conf/httpd.conf "ServerName localhost:80" 替换为 "ServerName localhost:81".之后它可能无法正常工作.然后替换

Second Issue: Way 1 : You can quit Skype first. And when Apche server is started then again you can run Skype. If you want to run Apache in another port then replace in xampp/apache/conf/httpd.conf "ServerName localhost:80" by "ServerName localhost:81" At line 184. After that even it may not work. Then replace

#Listen 0.0.0.0:80
#Listen [::]:80
Listen 80 

通过

#Listen 0.0.0.0:81
#Listen [::]:81
Listen 81

在第 45 行

方式2:如果你想使用端口80.然后按照这个.在 Windows 8 中，World Wide Publishing Service 正在使用此端口，停止此服务将释放端口 80，您可以使用此端口连接 Apache.要停止服务，请转到任务管理器 -> 服务选项卡"，右键单击全球发布服务"并停止.如果找不到，请转到运行 > services.msc"，然后再次找到并右键单击World Wide Publishing Service"并停止.

Way 2 : If you want to use port 80. Then follow this. In Windows 8 "World Wide Publishing Service is using this port and stopping this service will free the port 80 and you can connect Apache using this port. To stop the service go to the "Task manager –> Services tab", right click the "World Wide Publishing Service" and stop. If you don't find there then go to "Run > services.msc" and again find there and right click the "World Wide Publishing Service" and stop.

如果您没有找到World Wide Publishing Service"，请转到运行>>resmon.exe>>网络选项卡>>侦听端口"并查看哪个进程正在使用端口 80.

If you didn't find "World Wide Publishing Service" there then go to "Run>>resmon.exe>> Network Tab>>Listening Ports" and see which process is using port 80.

然后从概述>>CPU"中右键单击该进程并单击结束进程树".如果该过程是可能是关键问题的系统.

And from "Overview>>CPU" just Right click on that process and click "End Process Tree". If that process is system that might be a critical issue.

这篇关于XAMPP MySQL 密码设置(PHPMYADMIN 中无法输入)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！