甘肃住房与城乡建设厅网站,五道口网站建设,西地那非片说明书,软文写作平台发稿1、到mysql官网下载 https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.37-winx64.zip 2、将解压缩后的文件放到自己想要的地方#xff0c;并配置环境变量。例如我存放的目录为#xff1a;F:\mysql\mysql-5.6.14-winx64 在环境变量中添加#xff1a;MYSQL_HOME:F:\mysq…1、到mysql官网下载 https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.37-winx64.zip 2、将解压缩后的文件放到自己想要的地方并配置环境变量。例如我存放的目录为F:\mysql\mysql-5.6.14-winx64 在环境变量中添加MYSQL_HOME:F:\mysql\mysql-5.6.14-winx64 在path路径中加入%MYSQL_HOME%\bin 配置环境变量不是必须的只是为了能更方便的在命令行中使用mysql的命令行工具。3、修改ini配置文件 5.6.14的解压缩版里有一个my-default.ini文件copy一份改名为my.ini放在同级目录下。修改my.ini遵照第二篇文章的做法。我的my.ini内容如下# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. Its a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.#[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.# basedir .....# datadir .....# port .....# server_id .....# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size 128M# sort_buffer_size 2M# read_rnd_buffer_size 2M [mysqld] #设置字符集为utf8loose-default-character-set utf8basedir E:\MySql\mysql-5.6.37-winx64datadir E:\MySql\mysql-5.6.37-winx64\datacharacter-set-server utf8[client]loose-default-character-set utf8[mysql]loose-default-character-set utf8[WinMySQLadmin]server E:\MySql\mysql-5.6.37-winx64\bin\mysqld.exesql_modeNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES4、安装服务 进入cmd这个好像要管理员权限我在C盘下搜索cmd.exe -- C:\Windows\winsxs\wow64_microsoft-windows-commandprompt_31bf3856ad364e35_6.1.7601.17514_none_f387767e655cd5ab\cmd.exe右键以管理员身份运行。这个cmd.exe是64位的cmd。因为我安装的是64位的mysql 输入命令 C:\e: E:\cd E:\MySql\mysql-5.6.37-winx64\bin E:\MySql\mysql-5.6.37-winx64\binmysqld -install Service successfully installed.5、启动服务E:\MySql\mysql-5.6.37-winx64\bincd\ E:\net start mysql MySQL 服务正在启动 . MySQL 服务已经启动成功。6、配置用户 还在上面的命令窗口里面输入命令mysql -u root -p 回车后提示输入密码。 mysql解压缩版初次安装管理员root的密码为空因此直接再回车一次就登入mysql数据库了。 F:\mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.14 MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type help; or \h for help. Type \c to clear the current input statement. 成功后 输入命令use mysql; /*使用mysql数据库*/ mysql use mysql Database changed 输入命令select host,user,password from user; /* 查看系统的账户信息 */ mysql select host,user,password from user; --------------------------- | host | user | password | --------------------------- | localhost | root | | | 127.0.0.1 | root | | | ::1 | root | | | localhost | | | --------------------------- 4 rows in set (0.00 sec) host代表mysql服务允许哪个IP来的请求。localhost和127.0.0.1指mysql服务所在的主机即本地。1是IPV6的IP地址写法 全称为0000:0000:0000:0000:0000:0000:0000:0001。现在都是IPV4的网络可以不用管他。 user指账户名称。不同的host下账户名称可以相同。 password密码。 可以看到默认账户里只支持本地连接并且账户没有密码。现在的问题明确了就是要将匿名用户删除为root用户添加远程访问和密码再为自己添加个人账户。指令如下 mysql update user set passwordPASSWORD(123456) where userroot; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql grant all on *.* to root% identify by root; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ident ify by root at line 1 mysql grant all on *.* to walle% identify by 123456 with grant option; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ident ify by 123456 with grant option at line 1 mysql delete from where user; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near where user at line 1 mysql select host,user,password from user; ------------------------------------------------------------ | host | user | password | ------------------------------------------------------------ | localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | 127.0.0.1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | ::1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | localhost | | | ------------------------------------------------------------ 4 rows in set (0.00 sec) mysql commit; Query OK, 0 rows affected (0.00 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) 转载于:https://www.cnblogs.com/bjgua/p/7463199.html
