开机发现mysql服务不在了
于是手动加上改服务
mysqld --install MySQL80 --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"
# The TCP/IP Port the MySQL Server will listen on port=3307 # Path to installation directory. All paths are usually resolved relative to this. basedir="C:/Program Files/MySQL/MySQL Server 8.0/" # Path to the database root datadir="C:/ProgramData/MySQL/MySQL Server 8.0/Data/"
服务加成功
用命令行的方式进行启动
启动正常,但是登陆不了
已解决,最后发现是自己坑了自己
MYSQL80,设置的端口是3307
MYSQL,设置的端口是3306
如果用 mysql -u root -p 是访问的本地3306的mysql服务,当然是访问不了的了
改成下面这个,登录成功
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -P 3307 -p