如何通过XAMPP使用MySQL? [英] How do I use MySQL through XAMPP?

问题描述

我安装了XAMPP v3.2.1是因为我想学习如何在MySQL中创建数据库并了解有关TOMCAT的更多信息.但是，我对现在该做什么感到有些困惑.我已经阅读了许多博客和本页上的文档 http://dev.mysql.com/doc/refman/5.0/en/creating-database.html .

I installed XAMPP v3.2.1 because I wanted to learn how to create database in MySQL and learn more about TOMCAT. However, I am a little confused about what to do now. I have read many blogs and the documentation on this page http://dev.mysql.com/doc/refman/5.0/en/creating-database.html.

在遵循指示的同时，我发现: 我无法访问我的本地主机.

While following the directions I found that: I can't access my local host.

尝试的解决方案:我关闭了Skype，因为我读到这可能是一个问题. 我的计算机上没有任何较旧版本的XAMPP，并且我不相信我已连接到任何其他服务器.因此，我无权做任何事情.

Attempted Solution: I shut down skype because I read that might be an issue. I don't have any older versions of XAMPP on my computer and I don't believe I am connected to any other servers. So, I don't have permission to do anything.

OR

我要通过错误的命令提示符访问mysql吗?我正在尝试从XAMPP shell使用MySQL.我不确定为什么我无法使所有工作正常进行.我会用这种错误的方式吗?

Am I trying to access mysql through the wrong command prompt? I am trying to use MySQL from the XAMPP shell. I am not sure why I cannot get everything working. Am I going about this the wrong way?

感谢您的帮助

推荐答案

XAMPP仅提供MySQL(数据库服务器)&在一个设置中使用Apache(Web服务器)，您可以使用xampp启动器对其进行管理.

XAMPP only offers MySQL (Database Server) & Apache (Webserver) in one setup and you can manage them with the xampp starter.

成功安装后，导航到xampp文件夹并执行xampp-control.exe

After the successful installation navigate to your xampp folder and execute the xampp-control.exe

在mysql行按下开始按钮.

Press the start Button at the mysql row.

现在，您已经成功启动了mysql.现在，有2种不同的方法来管理mysql服务器及其数据库.

Now you've successfully started mysql. Now there are 2 different ways to administrate your mysql server and its databases.

但是首先，您必须设置/更改MySQL Root密码.启动Apache服务器，然后在浏览器的地址栏中键入localhost或127.0.0.1.如果您尚未从htdocs文件夹中删除任何内容，则会显示xampp状态页面.导航到安全设置并更改您的mysql根密码.

But at first you have to set/change the MySQL Root password. Start the Apache server and type localhost or 127.0.0.1 in your browser's address bar. If you haven't deleted anything from the htdocs folder the xampp status page appears. Navigate to security settings and change your mysql root password.

现在，您可以浏览到http://localhost/phpmyadmin下的phpmyadmin或下载Windows mysql客户端，例如navicat lite或mysql workbench.安装它并使用新的root密码登录到mysql服务器.

Now, you can browse to your phpmyadmin under http://localhost/phpmyadmin or download a windows mysql client for example navicat lite or mysql workbench. Install it and log in to your mysql server with your new root password.

这篇关于如何通过XAMPP使用MySQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！