MySQL Windows 下的安装
my.ini
####################配置文件开始################### # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/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-set=utf8 [mysqld] port=3306 basedir ="D:\IDE\mysql-5.7.20-winx64" datadir ="D:\IDE\mysql-5.7.20-winx64\data" tmpdir ="D:\IDE\mysql-5.7.20-winx64\data" socket ="D:\IDE\mysql-5.7.20-winx64\data\mysql.sock" log-error="D:\IDE\mysql-5.7.20-winx64\data\mysql_error.log" #server_id = 2 #skip-locking max_connections=100 table_open_cache=256 query_cache_size=1M tmp_table_size=32M thread_cache_size=8 innodb_data_home_dir="D:\IDE\mysql-5.7.20-winx64\data" innodb_flush_log_at_trx_commit =1 innodb_log_buffer_size=128M innodb_buffer_pool_size=128M innodb_log_file_size=10M innodb_thread_concurrency=16 innodb-autoextend-increment=1000 join_buffer_size = 128M sort_buffer_size = 32M read_rnd_buffer_size = 32M max_allowed_packet = 32M explicit_defaults_for_timestamp=true sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES ####################配置文件结束###################
[MASTER主机]
服务注册 mysqld install MySQL --defaults-file="D:\IDE\mysql-5.7.20-winx64\my.ini"
修改注册表 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL
初始化 mysqld --initialize
启动 net start mysql
==================================================================================
由于MYSQL5.6开始ROOT就是随机密码,所以需要修改密码
net stop mysql
cd "C:\Program Files (x86)\MySQL\MySQL 5.7\bin"
start mysqld --skip-grant-tables
mysql -ANe"update mysql.user set authentication_string=PASSWORD('a') where user='root'"
mysqladmin shutdown
net start mysql
mysql -uroot -p
Enter password: (enter the password 'mynewpassword' and hit <Enter>)
==================================================================================
卸载:
移除服务 mysqld remove
sc delete MySQL
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL" /f
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL" /f
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL" /f
[SLAVE从机]
mysqld install MySQL-SLAVE --defaults-file="D:\IDE\mysql-5.7.20-winx64-slave\my.ini"
卸载:
移除服务 mysqld remove
sc delete MySQL-SLAVE
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL-SLAVE" /f
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL-SLAVE" /f
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL-SLAVE" /f
=============================================================================================
在公司的win7笔记本上,遇到过一直在启动中,卸载之后服务也一直都在删不干净,新装服务又说服务已存在,附解决办法:
如何彻底的卸载和删除Windows service
最近遇到很头疼的问题,安装到服务器的Windows Service卸载的时候出错了,结果在服务列表中就一直驻留,并且系统进程一直在运行,怎么都杀不掉。
最后终于找到办法了:
1.常规做法,批处理命令卸载
Net Stop ServiceName
sc delete ServiceName
pause
2.如果还是没办法,那就继续尝试
a.找到系统注册表,删掉服务的注册表信息,通常路径在:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services 找到你的Service服务的名字,然后把整个文件夹删掉
b.如果还是在继续运行,service列表中还显示的话,用管理员权限打开cmd 命令 sc delete serviceName,如果提示 “the specified service is marked as deletion”。
导致windows service不能部署,也不能被删除,使用 SC 命令也不奏效。确实冒了一把冷汗。经过10几分钟的折腾,终于弄明白了:原来是windows service database缓存的原因,reboot server可以完美解决问题。但实际上我们可以尝试:
1. 关闭所有windows service控制面板。
2. 查找windows service的PID:SC queryex service_name
3. 杀掉进程:taskkill /PID service_pid /f
这样就再也不用担心windows service部署了。
至此就可以完全卸载掉了。
总结一下自己在工作中的经验。
===========================================================================================
创建用户和授权
mysql> mysql -uroot -pa
mysql> create database demodb;
mysql> create user 'a'@'localhost' identified by 'a';
mysql> grant all on demodb.* to 'a'@'localhost';