XAMPP MySQL密码设置(在PHPMYADMIN中不能输入)

2022-01-05 00:00:00 xampp mysql 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."

现在我想进入我的 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" 目录中找到以下代码.并按照下面给出的说明进行操作.我试过这样,我成功地在浏览器上运行 localhost/phpMyAdmin、MySQL 命令提示符以及 MySQL 查询浏览器.

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,那么在 xampp/apache/conf/httpd.conf 中用ServerName localhost:81"替换 xampp/apache/conf/httpd.conf 中的ServerName localhost:81" 在第 184 行.之后它甚至可能无法工作.然后替换

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.

相关文章