怎么做地方门户网站,郑州制作网站,成都关键词,创业商机网官网1. mysql-5.7.4-m14-winx64.zip下载官方网站下载地址#xff1a;http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17-winx64.zip2、解压到D:\mysql.(路径自己指定)3、在D:\mysql\mysql-5.7.4-m14-winx64下新建my.ini配置文件内容如下#xff1a;#################…1. mysql-5.7.4-m14-winx64.zip下载官方网站下载地址http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17-winx64.zip2、解压到D:\mysql.(路径自己指定)3、在D:\mysql\mysql-5.7.4-m14-winx64下新建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. It‘s 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.[client]default-character-setutf8[mysqld]port3306basedir D:/mysql/mysql-5.7.4-m14-winx64/datadir D:/mysql/mysql-5.7.4-m14-winx64/data/tmpdir D:/mysql/mysql-5.7.4-m14-winx64/data/socket D:/mysql/mysql-5.7.4-m14-winx64/data/mysql.socklog-errorD:/mysql/mysql-5.7.4-m14-winx64/data/mysql_error.log#server_id 2#skip-lockingmax_connections100table_open_cache256query_cache_size1Mtmp_table_size32Mthread_cache_size8innodb_data_home_dirD:/mysql/mysql-5.7.4-m14-winx64/data/innodb_flush_log_at_trx_commit 1innodb_log_buffer_size128Minnodb_buffer_pool_size128Minnodb_log_file_size10Minnodb_thread_concurrency16innodb-autoextend-increment1000join_buffer_size 128Msort_buffer_size 32Mread_rnd_buffer_size 32Mmax_allowed_packet 32Mexplicit_defaults_for_timestamptruesql-modeSTRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION#sql_modeNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES####################配置文件结束###################重点是以下配置其中datadir的目录名称必须是D:/mysql/mysql-5.7.4-m14-winx64/data/。4、在windows系统环境变量path加入如下内容D:\mysql\mysql-5.7.4-m14-winx64\bin;(注意加分号)5、将mysql注册为windows系统服务具体操作是在命令行中执行以下命令(需要以管理员身份运行命令行)增加服务命令mysqld install MySQL --defaults-fileD:\mysql\mysql-5.7.4-m14-winx64\my.ini移除服务命令为mysqld remove6、第5步成功后打开系统服务管理可以看到mysql系统服务(此处需要注意):需要在mysql服务的登陆属性里配置管理员用户登陆(不配置从服务管理里启动报1035错误在命令行启动报启动失败)在命令行启动mysql命令为 net start mysql关闭mysql命令为net stop mysql7、修改root的密码为123456命令行执行mysql –urootmysqlshow databases;mysqluse mysql;mysql UPDATE user SET passwordPASSWORD(‘123456‘) WHERE user‘root‘;mysql FLUSH PRIVILEGES;mysql QUIT8、此时可以在本机上客户端连接了(本人用的是SQLyog)有个系统库叫mysql9、远程登陆配置允许root用户在任何地方进行远程登录并具有所有库任何操作权限具体操作如下1)在本机先使用root用户登录mysql命令行执行mysql -u root -p输入密码(第7步中设置的密码)1234562)进行授权操作mysqlGRANT ALL PRIVILEGES ON *.* TO [email protected]%‘ IDENTIFIED BY ‘youpassword‘ WITH GRANT OPTION;重载授权表mysqlFLUSH PRIVILEGES;退出mysqlquit原文http://www.cnblogs.com/guilty/p/3931767.html
