一.MySQL 5.6.25(Linux)
1. Linux
① Install vmware:
(1) choose centos 64;
(2) memory 2048MB;
(3) hard disk 80G;
② Install CentOS 6.6:
(1) add partion: boot(200MB) -> swap(4096MB) -> /(the rest)
(2) remember cancel Kdump.
(3) network adapter: only host model.
③alter IP (include host):
④Close firewall:
2.Xshell:
①Install Xshell
②create connection:
③transfer mysql-5.6.25-linux-glibc2.5-x86_64.tar.gz:
④tar
⑤install MySQLWorkBench
⑥connection:
二.MySQL 5.6.35(Win10)
1.
①install MySQL
②add the position of MySQL in path: like: D:\Mysql 5.6
③copy mydefault.ini, and rename 'my.ini'. remember change this two option:
basedir = D:\Mysql 5.6
datadir =D:\Mysql 5.6
And alter character set:
input
character-set-server=utf8 under [mysqld]; and default-characcter-set=utf8 under [client](need to create by yourself,sometimes)
④run cmd by administrator, cd D:\Mysql 5.6\bin, input 'mysqld -install', if success, it will display 'Service successfully installed.'
*if you had installed mysql before, you need to input 'sc delete mysql', and then carry out 'mysqld -install' command.
⑤input 'net start mysql', start mysql
⑥'mysql -uroot -p'
⑦chang password: '
use mysql; update user set password=password('root') where user='root'; flush privileges;'
2. Navicatt①install Navicatt
②connection:
*Conclusion:
When I install MySQL 5.6, and tend to start MySQL Service, I encounter 1067 error. I tried almost methods from internet, but failed. So the following is my solution
①clear your mysql information in regedit.
②delete HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL File. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL.
③sc delete mysql
④move the disk: first of all, I install mysql in D:\. Finally, I move it in F:\; then success.