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'的访问被拒绝(使用密码:NO) 在配置中定义的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."

虽然我已经在xampp中设置了两个MySQL服务器，另一个是mysql-5.5.36，但是我想输入Phpmyadmin.我已经在网上搜索过，但是内容没有足够的帮助.在登录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和Xampp运行Mysql服务器，也想浏览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 Command提示符和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';

第二期: 方法1::您可以先退出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服务正在使用此端口，停止该服务将释放端口80，您可以使用此端口连接Apache.要停止该服务，请转到任务管理器->服务选项卡"，右键单击"World Wide Publishing服务"并停止.如果没有找到，请转到运行> services.msc"，然后再次找到该位置，然后右键单击"World Wide Publishing服务"并停止.

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服务"，请转到运行>> 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屋！