MySQL数据库 & SQLyog(可视化管理工具)的下载与安装（简洁版），附带建表和
1.下载MySQL安装包MySQL :: Download MySQL Community Serverhttps://csdnimg.cn/release/blog_editor_html/release2.3.7/ckeditor/plugins/CsdnLink/icons/icon-default.png?t=O83Ahttps://dev.mysql.com/downloads/mysql/5.5.html#downloadshttps://i-blog.csdnimg.cn/direct/283388200c584ea0bbe3db7cc4adcff9.png
2.解压 压缩包
https://i-blog.csdnimg.cn/direct/8b03c00e342c4d38bc0faffbec38f2df.png2.1复制 bin 目次路径
https://i-blog.csdnimg.cn/direct/65d2833d0b6b4d51891fe0f7314e12ec.png
3.配置情况
https://i-blog.csdnimg.cn/direct/5408057a1aa24e4d8818648165a3c597.png
https://i-blog.csdnimg.cn/direct/4c63056892da46df8622b6810a4d03e0.png
https://i-blog.csdnimg.cn/direct/fbbfeafc90414bea8ab0d456291d9fe8.png
https://i-blog.csdnimg.cn/direct/21da0925e98a4d859e36301c6f57d5ae.png
4.安装MySQL
4.1打开cmd
【以管理员身份打开，不然会在实验‘mysqld --install’报Install/Remove of the Service Denied!(安装/删除服务被拒绝！)】
https://i-blog.csdnimg.cn/direct/163759d8eb6f4e6f887198446b0d33ef.png
4.2初始化
mysqld --initialize https://i-blog.csdnimg.cn/direct/dcbf6046c02c4561bf3facb34c492e25.png
4.3安装
mysqld --install https://i-blog.csdnimg.cn/direct/4f1c44d7d2d24b23a54a751eb28d833d.png
【假如报The service already exists!，则说明有以前没删干净的MySQL版本，实验sc delete mysql下令即可】
4.4启动服务
net start mysql https://i-blog.csdnimg.cn/direct/da0873a82ff04537af9996fb1fcf9233.png
4.5登入
mysql -uroot -p(后面跟data路径.err文件里的密码) 在初始化后会主动生成data文件夹
https://i-blog.csdnimg.cn/direct/832cd529418e44b0ae313e6c144aedae.png
https://i-blog.csdnimg.cn/direct/5d9791531c8f4a3eb96a4572e929844b.png
https://i-blog.csdnimg.cn/direct/0ef7b0108dfd423084c0693e65dc946e.png
https://i-blog.csdnimg.cn/direct/b3587707476b47adbc68398a4bab7e5d.png
4.6修改暗码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'tiger'; 暗码修改为：tiger
https://i-blog.csdnimg.cn/direct/5d2db3857d5e4bd48e26b0a6cf93a1de.png
5.下载SQLyog安装包
（1）SQLyog官网（不推荐，需要注册登录）：Version History - SQLyog Knowledge Base
（2）找到一个github博主的下载地点：https://github.com/webyog/sqlyog-community/wiki/Downloads
（原文地点：https://blog.51cto.com/lenglingx/10735662）
（3）softonic的下载地点：https://sqlyog.en.softonic
SQLyog 13.2.1
https://s3.amazonaws.com/SQLyog_Community/SQLyog+13.2.1/SQLyog-13.2.1-0.x64Community.exe
双击运行
https://i-blog.csdnimg.cn/direct/ba951d3f716149a59c25811f4d2eeb06.png
6.安装SQLyog
基本不停下一步即可
https://i-blog.csdnimg.cn/direct/401ab1d297d4409b9da09b88f58000ad.png
https://i-blog.csdnimg.cn/direct/d4f0ee7831e54cc0b12cbfd01afcfd8e.png
https://i-blog.csdnimg.cn/direct/e78145c1b3ce46aeb173f98d97f4ba41.png
https://i-blog.csdnimg.cn/direct/bf1068ca6daf42d39423c8ab1070e420.png
https://i-blog.csdnimg.cn/direct/1e6f2f1cffef4249a14814594898b2fc.png
https://i-blog.csdnimg.cn/direct/dc97e3387b7f4f80a6abc8837b2dd657.png
https://i-blog.csdnimg.cn/direct/bca54780c9304f439144675b60681519.png
7.连接MySQL
https://i-blog.csdnimg.cn/direct/6d86b71da95b4ab9b4646a8816a48080.png
连接成功
https://i-blog.csdnimg.cn/direct/278a49d656134d32b19e70a68d67ab98.png
8.建表和四个基本的增编削查语句
CREATE DATABASE `ckk_school`;
USE `ckk_school`;
CREATE TABLE `student` (
`stu_id` INT(10) NOT NULL AUTO_INCREMENT,
`stu_name` VARCHAR(20) COLLATE utf8_bin DEFAULT NULL,
`stu_id_card` VARCHAR(18) COLLATE utf8_bin DEFAULT NULL,
`stu_pwd` VARCHAR(32) COLLATE utf8_bin DEFAULT NULL,
`stu_mobile` VARCHAR(11) COLLATE utf8_bin DEFAULT NULL,
`stu_gender` INT(1) DEFAULT NULL,
`enrollment_date` DATE DEFAULT NULL,
`remark` VARCHAR(200) COLLATE utf8_bin DEFAULT NULL,
`del_mark` INT(1) DEFAULT '1',
PRIMARY KEY (`stu_id`)
) ENGINE=INNODB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO `student`(`stu_id`,`stu_name`,`stu_id_card`,`stu_pwd`,`stu_mobile`,`stu_gender`,`enrollment_date`,`remark`,`del_mark`)
VALUES (1,'小明','610123200210202345','pwd123','13500001111',1,'2024-10-20','stu测试',1);
DELETE FROM student WHERE stu_id = 1;
UPDATE student SET stu_name = '蔡坤坤' WHERE stu_id = 1 AND stu_name = '小明';
SELECT * FROM student; https://i-blog.csdnimg.cn/direct/dc4768978054414db1fb529efac7653d.png
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]