MySQL5.7.21安装与密码图文配置教程

2024-07-24 13:15:26

字体：大中小

来源：转载

供稿：网友

MySQL5.7.21安装与密码设置教程，具体如下

官方参考手册

1.解压MySQL 5.7.20安装包，如X:/MySQL/mysql-5.7.21-winx64。（是没有data和my.ini的）

mysql5.7,mysql5.7.21,密码

2.配置mysql的环境变量，创建MYSQL_HOME，并且在Path添加上%MYSQL_HOME%/bin;

mysql5.7,mysql5.7.21,密码

3，配置my.ini. 并把my.ini放到bin目录下（1.如果放在mysql-5.7.21-winx64 目录下，在下面执行net start mysql时可能无法启动MYSQL服务、2.不会自动生成data）

[client] default-character-set=utf8 [mysqld]#解压目录 如：D:/MySQL/mysql-5.7.21-winx64 basedir = %MYSQL_HOME% #解压目录 如：D:/MySQL/mysql-5.7.21-winx64/data datadir = %MYSQL_HOME%/data  port = 3306  default-character-set=utf8

4. 以管理员身份进入命令行（可在小娜搜索输入cmd找到），并进入X:/MySQL/mysql-5.7.21-winx64/bin目录下输入命令：mysqld --initialize-insecure (生成无密码的root用户) 后，在mysql-5.7.20-winx64 目录下就会出现data文件

mysql5.7,mysql5.7.21,密码

5.再输入mysqld --install，如果出现Service successfully installed 说明注册成功了。

注意：如果此操作报错Install/Remove of the Service Denied!，建议使用管理员身份进入命令提示符

mysql5.7,mysql5.7.21,密码

6.启动MySQL服务，命令：net start mysql

mysql5.7,mysql5.7.21,密码

7.设置密码 mysqladmin -u root password 密码

8.修改密码方法如下：接着输入mysql -uroot -p 由于之前登陆过，直接输入刚才设置密码（登录root第一次是免密码的直接回车进入到） MYSQL>

mysql5.7,mysql5.7.21,密码

接着输入：update mysql.user set authentication_string=password('你想输入的密码') where user='root' and Host ='localhost'; 然后接着再输入： flush privileges;

mysql5.7,mysql5.7.21,密码

9.输入命令show databases; 查看数据表

mysql5.7,mysql5.7.21,密码

MySQL常用的命令如下

List of all MySQL commands: Note that all text commands must be first on line and end with ';'（要以“;”结尾） ?  (/?) Synonym for `help'. clear (/c) Clear the current input statement. connect (/r) Reconnect to the server. Optional arguments are db and host. delimiter (/d) Set statement delimiter. ego (/G) Send command to mysql server, display result vertically. exit (/q) Exit mysql. Same as quit. go (/g) Send command to mysql server. help (/h) Display this help. notee (/t) Don't write into outfile. print (/p) Print current command. prompt (/R) Change your mysql prompt. quit (/q) Quit mysql.rehash (/#) Rebuild completion hash. source (/.) Execute an SQL script file. Takes a file name as an argument. status (/s) Get status information from the server. tee (/T) Set outfile [to_outfile]. Append everything into given outfile. use (/u) Use another database. Takes database name as argument. charset (/C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets. warnings (/W) Show warnings after every statement. nowarning (/w) Don't show warnings after every statement. resetconnection(/x) Clean session context.

10.输入 /q; 退出MySQL

11.关闭MySQL服务,命令：net stop mysql

mysql5.7,mysql5.7.21,密码