Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to open mysql in wamp

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to open mysql in wamp, which can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The way to open mysql in wamp is to first open the bin folder of the mysql installation directory under wamp, then start the server program of MySQL, and finally open the command processing window to start mysql.

Open the MySql service 1. Open the command line and open the bin folder of the mysql installation directory under wamp (I installed Wamp server on disk G)

Start the server program of MySQL, that is, enter: mysqld. (please note that this is mysqld, not mysql)

3. Open the client window of mysql: that is, open the command processing window, enter mysql's bin directory again, and type mysql-h hostname-u username-p to start mysql. Here, my hostname is localhost,username for root.

Difference

The difference between ① mysql and mysqld: mysqld is the server program mysql is the command line client program configuration environment variable, so you don't have to enter such a long path every time

Find the [Path] variable, click "Edit", and add the bin directory of ";" + MySQL in the variable value box in the pop-up "Edit system variable" dialog box. My directory here is:; G:\ wamp\ bin\ mysql\ mysql5.6.12\ bin

The mysql service was successfully started and logged in.

The great task has been completed.

Start the apache service

Add practical information first.

Example of using http.exe command under windows: usually we probably use the http.exe command to install, open, stop, and delete apache services. Httpd-k install registers Apache as a windows service, because we are using the apache2.2 version, so the default service name is "Apache2.4". Httpd-k install-n "service name" registers Apache as a windows service and specifies a service name yourself. Httpd-k install-n "service name"-f "conf\ my.conf" registers Apache as a windows service, specifies a service name, and uses a specific profile. Httpd-k uninstall removes the Apache service. By default, the Apache service will be removed using "Apache2.4" httpd-k uninstall-n "service name" and create a service name yourself. Httpd-k start starts the Apache service. Httpd-k stop stops the Apache service. Httpd-k restart restarts the Apache service.

Add the bin directory of apache to the system environment variable, which is more convenient

Open the command line as an administrator: enter

Httpd-k install / / add the apache service to the windows service, so open the command line as an administrator!

Httpd-k start / / enable apache service

Httpd-k stop / / stop the apache service

When I added the service here, I changed the name and made an error when opening it, because it looks for the version you installed by default (mine is Apache2.4)

So delete the service, add it again, and don't add the parameter-n this time (don't change the name)

Thank you for reading this article carefully. I hope it is helpful for everyone to share how to open mysql content in wamp. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report