Mysql learning notes (simple use + Navict in Windows), learning notes navict

Mysql learning notes (simple use + Navict in Windows), learning notes navict

I have installed mysql before. I just want to try it out again recently.

I found that I forgot the commands and still wanted Baidu. So I 'd better sort them out.

Although there are a lot of related introductions on the internet, it would be better to sort them out.

The first is download and installation, and there are a lot of online content that will not be listed one by one

The first is to enable the service command:

Net start mysql

Close the service command:

Net stop mysql

The following is the logon command:

Mysql-u root-p

Root is the default user name

If no password is set, press Enter.

If you have set a password and typed a password

Logon successful:

View All databases:

Show databases;

Exit:

Exit;

In actual use, database management tools may be used to facilitate database operations.

I am using Navict Premium

Open the new link and enter the corresponding database information.

After entering the correct information, you can connect