mysql意外关闭

7vhp5slm  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(267)

我正在尝试用xampp升级mysql。php版本=>5.6.3旧版mysql版本=>5.6.21需要升级=>5.7.22(仅在5.7系列中提供下载)
我按照以下步骤升级:

Download latest MySQL but download the zip file not the MSI
Unzip the zip file to a location.
Shutdown Mysql process (no need to remove service) from XAMPP control panel.
Go to XAMPP folder, rename mysql folder to mysql_old
Copy the new unzipped mysql folder to XAMPP folder, in it delete the data folder.
Copy over the data folder from the mysql_old to the new mysql folder.
Copy over the my.ini file under mysql_old/bin to mysql/bin.
Copy over other ini and executable files from mysql_old root folder to mysql (XAMPP ini files, my-huge.ini, my-small.ini, etc..). in my case i copied my-default.ini
Run mysql process from XAMPP control panel. Should work. (You may need
to kill XAMPP first).-->Here I struck out and facing mysql shutdown error.
(OPTIONAL) Run mysql/bin/mysql_upgrade.exe -u USERNAME -p to update tables in the local databases that may have problems due to the version change.

我在我的.ini文件中尝试了1.change port as 330733068111,正如其他人建议的那样。2.进入mysql/data/directory删除ibdata1&ib\u logfile*(ib\u logfile0,ib\u logfile1,ib\u logfile101)文件重启xampp服务器
mysql\u error.log显示如下:2018-05-04t06:31:04.062353z 0[注]c:\mysql upgradexampp\sm3\xampp\mysql\bin\mysqld.exe(mysqld 5.7.22)作为进程9428启动。。。
我以管理员身份运行xampp控制面板,但它仍然显示

Error: MySQL shutdown unexpectedly. 
[mysql] This may be due to a blocked port, missing dependencies,  
[mysql] improper privileges, a crash, or a shutdown by another method. 
[mysql] Press the Logs button to view error logs and check 
[mysql] the Windows Event Viewer for more clues 
[mysql] If you need more help, copy and post this 
[mysql] entire log window on the forums

在命令提示符下,我得到以下错误:error\mysql\bin>mysql-u root-p enter password:error 2003(hy000):无法连接到“localhost”上的mysql服务器(10061)
请有人给个建议解决。谢谢

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题