1、下载免安装zip文件解压后,将所在的文件bin目录加入到环境变量中,运行命令:
net start mysql : 服务名无效
进入到bin目录下,运行mysqld --install //Service successfully installed.
2、接第一步net start mysql : mysql服务无法启动
mysqld --initialize
如果报错:mysqld --remove mysql
再安装、初始化
3、启动成功后,设置mysql密码。
mysql -u root -p
默认密码为空直接回车
更新密码
update mysql.user set authentication_string=password("123456") where user="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 '("123456") where user="root"' at line 1
直接:ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
设置密码:SET PASSWORD = '123';
刷新更改:flush privileges;
退出:quit
4、连接navicat
新建连接-----》 mysql -------》》登录名 就写库名,输入密码即可,在点击一下新建的数据库就欧了
navicat连接MySQL报错1251 client dose not support
出现这种情况的原因是:mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password,
mysql -u root -p
输入密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
退出即可
测试连接:
1045-Access denied for user 'root'@'localhost'(using password: YES)
mysql -u root -p
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
原因:修改加密规则之后原来的密码就无效了
删除之前的mysql文件,重新安装无效
mysql安装到第三步“Start Service“出现红叉,Could not start the service MySQL解决方法
https://www.cnblogs.com/jap6/p/10677907.html