atomicrat2552 Posted August 17, 2008 Share Posted August 17, 2008 I have MySQL Server 6.0 running freshly installed on Win XP SP3, and am attempting to connect using Navicat 8/HeidiSQL 3.2 and upon entering the info and attempting to connect I receive this message: Could not establish connection! Details: SQL Error: Access denied for user 'root'@'localhost' (using password:YES) I initially thought that Norton may have been blocking the program or the port, so I opened port 3306 up and gave full access to MySQL, Navicat and HeidiSQL. This didn't work and I still receive the error. Any help would be appreciated. Link to comment https://forums.phpfreaks.com/topic/120104-cannot-connect-to-mysql-server-6/ Share on other sites More sharing options...
Hooker Posted August 17, 2008 Share Posted August 17, 2008 it's not a problem with the server, it's probably going to be one of two things that you can check: 1.) Is the password you're entering corrent. 2.) Do Navicat 8/HeidiSQL 3.2 support mysql 6.0 On another note, it's really not a good idea to use 6.0 right now unless you know what you're doing since it's an alpha candidate, the most recent, viable version of mysql (community) is 5.1. Link to comment https://forums.phpfreaks.com/topic/120104-cannot-connect-to-mysql-server-6/#findComment-618725 Share on other sites More sharing options...
atomicrat2552 Posted August 17, 2008 Author Share Posted August 17, 2008 Navicat and HeidiSQL both claim to be compatible. Thanks on the server tip though, didn't see anything saying alpha on the site. Link to comment https://forums.phpfreaks.com/topic/120104-cannot-connect-to-mysql-server-6/#findComment-618727 Share on other sites More sharing options...
Hooker Posted August 17, 2008 Share Posted August 17, 2008 Give 5.1 a try and make sure you note the password you're using for the "root" user Also: MySQL 6.0 Community Edition - Alpha Development Release NOTE: This alpha release, as any other pre-production release, should not be installed on production level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any other software beta release. MySQL generally recommends that you dump and reload your tables from any previous version to upgrade to 6.0. Link to comment https://forums.phpfreaks.com/topic/120104-cannot-connect-to-mysql-server-6/#findComment-618732 Share on other sites More sharing options...
atomicrat2552 Posted August 17, 2008 Author Share Posted August 17, 2008 lol, no wonder i am legally blind in one eye thanks for the help though! Link to comment https://forums.phpfreaks.com/topic/120104-cannot-connect-to-mysql-server-6/#findComment-618735 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.