Shulou(Shulou.com)05/31 Report--

Cmd how to connect to the MySQL database, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

1. Mysql command line connection

1. Generally, for the mysql that has just been installed, if you check to enable mysql lineclient. You can directly find the start-program-mysql command line client as shown in the following figure

2. After clicking the mysql command line, you will be prompted to enter your root password. Enter the correct root password and then connect to the msyql database.

How to connect to the database on the Cmd command line

1. If the mysql command line is not installed, we can find the path where mysqld is located (copy the path where mysqld.exe is located)

2. Use cd to switch to the msyqld.exe path, and then enter the mysql connection command as follows

The format is:

Mysql-P port number-h mysql hostname\ ip-u root (user)-p

3. If the command line is the local machine where mysql is located, and you can enter mysql-u root-p directly with the default port 3306.

Third, third-party mysql database connection tools

There are many of these through third-party database connection tools, such as setting the relevant parameters in the following figure

Once connected, it will be a more user-friendly graphical interface.

Other remote connection tools

Phpmyadmin is undoubtedly the most widely used graphical tool for php to manage databases, because it involves different environments and paths. No detailed operation is done in this example.

Other considerations

1. By default, mysql can only be logged in locally, and the public network can be connected normally if needed.

2. You need to set open permissions in the mysql\ user table. For example, hosts is a host that can be connected remotely.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.