1.安装
msi版windows安装地址
https://dev.mysql.com/downloads/windows/installer/5.7.html
免安装版安装过程
cd mysql-5.7.20-winx64\bin
mysqld -install ///mysqld -remove
mysqld --initialize
在 MySQL 的根目录下会生成一个 data 文件夹,注意里面的一个以 .err 结尾的文件,初始密码就在这个文件里
如果解压后的 MySQL 中没有一个名为 my-default.ini 的文件,则自己在根目录下新建一个名为 my.ini 的文件,输入以下内容。
[mysqld]
basedir=D:\mysql-5.7.20-winx64
datadir=D:\mysql-5.7.20-winx64\data
port=3306
命令行输入
net start mysql
mysql -u root -p
mysql命令:
set password for root@localhost=password('xxxxxx');
use mysql;
quit
添加用户
INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'guest', PASSWORD('guest123'), 'Y', 'Y', 'Y');
添加全权限(支持远程连接)用户 用户名为guest,密码为123456 地址为%,可修改为特定地址。
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON TUTORIALS.* -> TO 'zara'@'localhost' -> IDENTIFIED BY 'zara123';
更新操作
FLUSH PRIVILEGES;
管理数据库命令
mysql> use RUNOOB;
mysql> SHOW DATABASES;
mysql> SHOW TABLES;
mysql> SHOW COLUMNS FROM runoob_tbl;
mysql> SHOW INDEX FROM runoob_tbl;
mysql> create DATABASE RUNOOB;
[root@host]# mysqladmin -u root -p create RUNOOB
mysqli_query(connection,query,resultmode);
mysql> drop database RUNOOB;
[root@host]# mysqladmin -u root -p drop RUNOOB
CREATE TABLE IF NOT EXISTS `runoob_tbl`( `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id` ) )ENGINE=InnoDB DEFAULT CHARSET=utf8;
mysql> DROP TABLE runoob_tbl
mysql> INSERT INTO runoob_tbl -> (runoob_title, runoob_author, submission_date) -> VALUES -> ("学习 PHP", "菜鸟教程", NOW());
对于含有中文的数据插入,需要添加 mysqli_query($conn , "set names utf8"); 语句。
SELECT column_name,column_name FROM table_name [WHERE Clause] [LIMIT N][ OFFSET M]mysql > UPDATE runoob_tbl SET runoob_title = ' 学习 C++ ' WHERE runoob_id = 3 ;
mysql> DELETE FROM runoob_tbl WHERE runoob_id=3;