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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.