arianhojat Posted October 31, 2006 Share Posted October 31, 2006 seems like when u upgrade sql on windows to 5, you cannot conncet to the new database cause the user,etc tables are in old format...so mysql provides mysql_update to fix the tables for you so u can connect once again to your database....but the command doesnt work properly... there is a bug for this, not sure what the fix for this is since this suggested fix on mysql's website, submitted by a user, doesnt work for me:http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.htmlwhich says[quote]Couple of bugs in mysql_upgrade.exe, like Bug #20950 "Win version of mysql_upgrade looks for mysqlcheck instead of mysqlcheck.exe", cause problems running mysql_upgrade.The fast and dirty workaround is:cd C:\Program Files\MySQL\MySQL Server 5.0\bincopy mysqlcheck.exe "mysqlcheck"rem Yes, without extention.copy mysql.exe "mysql"cd ..mysql_upgrade --basedir="."[/quote]i get the error bascially when i run last line:[quote]C:\Program Files\MySQL\MySQL Server 5.0>mysql_upgrade -u root -p --basedir="."Enter password: ******.\bin\mysqlcheck.exe: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connectError executing '.\bin\mysqlcheck.exe --defaults-extra-file=.\data\upgrade_defaults --check-upgrade --all-databases --auto-repair --user=root'[/quote] Link to comment https://forums.phpfreaks.com/topic/25735-mysql_update-not-working-for-mysql-5-windows-upgrade/ Share on other sites More sharing options...
fenway Posted October 31, 2006 Share Posted October 31, 2006 I've never encountered this before... probably because I don't run MySQL on windows boxes. I'll let you know if I hear anything. Link to comment https://forums.phpfreaks.com/topic/25735-mysql_update-not-working-for-mysql-5-windows-upgrade/#findComment-117498 Share on other sites More sharing options...
arianhojat Posted October 31, 2006 Author Share Posted October 31, 2006 thanks if u can ask a few people, fenway. i used -u -p options in there just cause mysql_upgrade --basedir="."by itself, will throw that same 'Can't connect to MySQL server' error, so i assumed maybe i should use my password to help the command do its job.yet the user table is the very thing which is messed up, so i dunno if supplying a username and password will help the command connect and fix the tables, since its trying to fix the user/password issue in the 1st place if u get my drift. Link to comment https://forums.phpfreaks.com/topic/25735-mysql_update-not-working-for-mysql-5-windows-upgrade/#findComment-117501 Share on other sites More sharing options...
arianhojat Posted October 31, 2006 Author Share Posted October 31, 2006 errr stupid Symantec Firewall @ my work was hidden (usu its in taskbar) and blocking mysql mysqlupdate from running. errrr! Link to comment https://forums.phpfreaks.com/topic/25735-mysql_update-not-working-for-mysql-5-windows-upgrade/#findComment-117533 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.