MySQL5.7.21如何安装配置
这篇文章主要介绍MySQL5.7.21如何安装配置,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!
创新互联公司是一家专业提供果洛州企业网站建设,专注与成都网站制作、做网站、外贸营销网站建设、H5开发、小程序制作等业务。10年已为果洛州众多企业、政府机构等服务。创新互联专业网站制作公司优惠进行中。
官方参考手册
1.解压MySQL 5.7.20安装包,如X:\MySQL\mysql-5.7.21-winx64。(是没有data和my.ini的)
2.配置mysql的环境变量,创建MYSQL_HOME,并且在Path添加上%MYSQL_HOME%\bin;
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文件
5.再输入mysqld --install,如果出现Service successfully installed 说明注册成功了。
注意:如果此操作报错Install/Remove of the Service Denied!,建议使用管理员身份进入命令提示符
6.启动MySQL服务,命令:net start mysql
7.设置密码 mysqladmin -u root password 密码
8.修改密码方法如下 :接着输入mysql -uroot -p 由于之前登陆过,直接输入刚才设置密码(登录root第一次是免密码的直接回车进入到) MYSQL>
接着输入:update mysql.user set authentication_string=password('你想输入的密码') where user='root' and Host ='localhost'; 然后接着再输入: flush privileges;
9.输入命令show databases; 查看数据表
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.21如何安装配置”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注创新互联行业资讯频道!
新闻名称:MySQL5.7.21如何安装配置
文章来源:http://myzitong.com/article/jjiidj.html