Table of Contents
Start the MySql service
Home Database Mysql Tutorial How to open mysql in wamp

How to open mysql in wamp

Sep 30, 2020 am 10:20 AM
apache mysql wamp

How to open mysql in wamp: first open the bin folder of the mysql installation directory under wamp; then start the MySQL server program; finally open the command processing window and start mysql.

How to open mysql in wamp

Recommended: "mysql tutorial"

Start the MySql service

 1. 打开命令行,打开wamp下的mysql安装目录的bin文件夹(我把Wamp server安装在G盘)
Copy after login

How to open mysql in wamp

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

  1. How to open mysql in wamp
3.打开mysql的客户端窗口:即打开命令处理窗口,再次进入mysql的bin目录,输入mysql -h hostname -u username -p就可以启动mysql了。在这里,我的hostname是localhost,username为root。
Copy after login
Difference


①mysql 和mysqld 的区别:
Copy after login
    mysqld is a server program
  • mysql is a command line client program
Configure environment variables, so you don’t have to enter such a long path every time

Find the [Path] variable and click [ Edit], in the variable value box in the [Edit System Variables] dialog box that pops up, add ";" MySQL's bin directory. My directory here is: ;G:\wamp\bin\mysql\mysql5.6.12\bin;

The mysql service was successfully started and logged in.


How to open mysql in wamp Done.

Start the apache service

Let’s get started first

在windows下使用http.exe命令的例子:
平时我们使用最多的可能就是用http.exe命令安装、开启、停止,删除apache服务这些操作。

httpd -k install 
将Apache注册为windows服务,因为我们使用的是apache2.2版本,所以默认的服务名为"Apache2.4"。

httpd -k install -n "服务名" 
将Apache注册为windows服务,自己指定一个服务名字。

httpd -k install -n "服务名" -f "conf\my.conf"将Apache注册为windows服务,自己指定一个服务名字,并且使用特定配置文件。

httpd -k uninstall
移除Apache服务,缺省地,将使用"Apache2.4"httpd -k uninstall -n "服务名"移除Apache服务,自己制定一个服务名字。

httpd -k start
启动Apache服务。

httpd -k stop
停止Apache服务。

httpd -k restart
重启Apache服务。
Copy after login

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


As an administratorOpen the command line: Enter

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

httpd -k start //Start the apache service
httpd -k stop //Stop the apache service
······

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


How to open mysql in wamp So delete the service and add it again. This time do not add the parameter -n. (Don’t change the name)

How to open mysql in wamp That’s it.

The above is the detailed content of How to open mysql in wamp. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to set the cgi directory in apache How to set the cgi directory in apache Apr 13, 2025 pm 01:18 PM

To set up a CGI directory in Apache, you need to perform the following steps: Create a CGI directory such as "cgi-bin", and grant Apache write permissions. Add the "ScriptAlias" directive block in the Apache configuration file to map the CGI directory to the "/cgi-bin" URL. Restart Apache.

How to start apache How to start apache Apr 13, 2025 pm 01:06 PM

The steps to start Apache are as follows: Install Apache (command: sudo apt-get install apache2 or download it from the official website) Start Apache (Linux: sudo systemctl start apache2; Windows: Right-click the "Apache2.4" service and select "Start") Check whether it has been started (Linux: sudo systemctl status apache2; Windows: Check the status of the "Apache2.4" service in the service manager) Enable boot automatically (optional, Linux: sudo systemctl

How to delete more than server names of apache How to delete more than server names of apache Apr 13, 2025 pm 01:09 PM

To delete an extra ServerName directive from Apache, you can take the following steps: Identify and delete the extra ServerName directive. Restart Apache to make the changes take effect. Check the configuration file to verify changes. Test the server to make sure the problem is resolved.

How to connect to the database of apache How to connect to the database of apache Apr 13, 2025 pm 01:03 PM

Apache connects to a database requires the following steps: Install the database driver. Configure the web.xml file to create a connection pool. Create a JDBC data source and specify the connection settings. Use the JDBC API to access the database from Java code, including getting connections, creating statements, binding parameters, executing queries or updates, and processing results.

How to view your apache version How to view your apache version Apr 13, 2025 pm 01:15 PM

There are 3 ways to view the version on the Apache server: via the command line (apachectl -v or apache2ctl -v), check the server status page (http://<server IP or domain name>/server-status), or view the Apache configuration file (ServerVersion: Apache/<version number>).

What to do if the apache80 port is occupied What to do if the apache80 port is occupied Apr 13, 2025 pm 01:24 PM

When the Apache 80 port is occupied, the solution is as follows: find out the process that occupies the port and close it. Check the firewall settings to make sure Apache is not blocked. If the above method does not work, please reconfigure Apache to use a different port. Restart the Apache service.

How to view the apache version How to view the apache version Apr 13, 2025 pm 01:00 PM

How to view the Apache version? Start the Apache server: Use sudo service apache2 start to start the server. View version number: Use one of the following methods to view version: Command line: Run the apache2 -v command. Server Status Page: Access the default port of the Apache server (usually 80) in a web browser, and the version information is displayed at the bottom of the page.

How Debian improves Hadoop data processing speed How Debian improves Hadoop data processing speed Apr 13, 2025 am 11:54 AM

This article discusses how to improve Hadoop data processing efficiency on Debian systems. Optimization strategies cover hardware upgrades, operating system parameter adjustments, Hadoop configuration modifications, and the use of efficient algorithms and tools. 1. Hardware resource strengthening ensures that all nodes have consistent hardware configurations, especially paying attention to CPU, memory and network equipment performance. Choosing high-performance hardware components is essential to improve overall processing speed. 2. Operating system tunes file descriptors and network connections: Modify the /etc/security/limits.conf file to increase the upper limit of file descriptors and network connections allowed to be opened at the same time by the system. JVM parameter adjustment: Adjust in hadoop-env.sh file

See all articles