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

This article mainly explains "how to install Mysql locally". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian slowly and deeply to study and learn "how to install Mysql locally" together!

download that installation file

Click on the installation file directly until it is complete

verification

Enter cmd command and type

mysql -u root -p

Enter, and then see the following page, indicating successful installation

DB Eaver Connection Error Resolution

create tables

CREATE TABLE java10.` user` ( name varchar(30) NULL, pwd varchar(10) NULL)ENGINE=InnoDBDEFAULT CHARSET=utf8mb4COLLATE=utf8mb4_0900_ai_ci;

Format:

create table name (

column name 1 varchar(30),

Column name 2 int,

column name 3 double,

Listings 4 varchar(10)

)

Note: The last column has no comma at the end.

Thank you for reading, the above is "how to install Mysql to the local" content, after the study of this article, I believe we have a deeper understanding of how to install Mysql to the local problem, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

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.