2、解壓到任意路徑,比如"D:\Programm Files\"。
3、進入MySQL路徑,復制my-small.ini為my.ini,
在[mysqld]部分添加
basedir = "D:/Program Files/Mysql-5.5.10-win32"
datadir = "D:/Program Files/Mysql-5.5.10-win32/data"。
# 設置mysql服務器的字符集(可選)
default-character-set=gbk
[client]
# 設置mysql客戶端的字符集(可選)
default-character-set=gbk
4、將MySQL的bin目錄路徑添加到系統(tǒng)變量里。(可選)
5、注冊服務
CMD進入MySQL/bin文件夾
mysqld --install "MySQL Database Service" --defaults-file="D:\Program Files\MySQL-5.5.10-win32\my.ini"
("MySQL Database Service"為服務名,帶空格需用引號,可自取)
("D:\Program Files\MySQL-5.5.10-win32\my.ini"為INI路徑,帶空格需用引號)
啟動服務
net start "MySQL Database Service"
6、首次登陸MySQL
mysql -u root -p
(密碼為空)
7、設置密碼
mysql> use mysql
Database changed
mysql> update user set PASSWORD = PASSWORD('你的新密碼') where USER='root' and HOST='localhost';
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
mysql> exit
mysql 簡單sql語句
create database test1;
show databases;
use test1;
show tables;
drop database test1;
use test1;
create table testtable(name varchar(10), number int(10));
desc test;
show create table test \G; 查看詳細的表定義
drop table test;