Mysql Connection Error Nr 1364
Justin Cranford Email Updates: Status: Duplicate Impact on me: None Category:MySQL Server: Installing Severity:S3 (Non-critical) Version:5.5.8 OS:Microsoft Windows (Windows 7 Enterprise x64) Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [21 Dec 2010 16:31] Justin Cranford Description: The MySQL 5.5.8 x64 essentials installer launches the MySQL Instance Configuration Wizard. If you check the option to allow remote access to the root account, you get error 1364. The error is "Connection failed with the following error - Error Nr 1364 - Field authentication-string doesn't have a default value". Clicking "Skip" on the error prompt allows you to go back and uncheck the "allow remote access for root account", but moving forward the installer displays an error "cannot add MySQL server because it already exists" and hangs for a long time. I had to cancel the install, remote the "C:\Program Files\MySQL" and "C:\ProgramData\MySQL" directories, and do a new install all over again. How to repeat: Run the MySQL 5.5.8 x64 essentials installer on Windows 7 Enterprise x64. In the MySQL Instance Configuration Wizard, check the box to "enable remote access to the root account". When you get to the Execute step, it will give you an error 1364. If you try to click "Skip" and go back to uncheck the "remote root access" option, you can try to move forward but it will fail. Suggested fix: Fix the MySQL Instance Configuration Wizard to be more resilient when re-executing after a partial success. Better yet, fix the root cause of the error. The wizard fails to add a row to the mysql.user table because the authentication-string column does not have a DEFAULT value in the schema. Add a default value to that table, and change the Instance Configuration Wizard to specific that value when inserting a value into mysql.user. [21 Dec 2010 17:51] Peter Laursen Lots of identical or similar reports exist already - including: http://bugs.mysql.com/bug.php?id=58954 http://bugs.mysql.com/bug.php?id=58962 http://bugs.mysql.com/bug.php?id=58965 (follow links in the reports and also understand that if you upgrade fro
Remote Access problem, Error Nr 1364 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 of 12 Thread: [HELP] MySQL Remote Access problem, Error Nr 1364 Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-30-2011,07:39 https://bugs.mysql.com/bug.php?id=59094 AM #1 fattwam View Profile View Forum Posts Private Message View Articles Join Date Jan 2011 Posts 28 [HELP] MySQL Remote Access problem, Error Nr 1364 REGISTER! (FREE) Registered members see less ads and also gain access to other great features. Hey guys, I cant make my MySQL Server enabled for remote access. I have it set up on a windows server. http://www.ac-web.org/forums/showthread.php?112849-HELP-MySQL-Remote-Access-problem-Error-Nr-1364 When setting up the server when i create the database and click enable remote access and put the admin password in then press next and try to start the server everything get the check mark beside it except "Apply Security Settings" it just sits there for about 30 seconds then an error window comes up that is error number 1364. Also when i try to delete the MySQL server and just reinstall it i can not because even after deleting it and restarting it still says the mysql is there. After i do a fresh install MySql still gives me the option to remove it. But i have done some research and deleted again and deleted what was left in Program Data and Program Files and it still wont work. I have been trying this for 5 hours and can not get it to work properly. The farthest i have gotten is the server will work but with Remote Access disabled. But i need it enabled. Please any help is definitely appreciated. Thank you Reply With Quote 03-30-2011,07:43 AM #2 Difer View Profile V
Search Home Forums Downloads Tracker wiki Blogs Browse Join Us History Chat Calendar Member Map Staff More Activity All Activity Github Activity Bug Tracker Activity WIKI Activity My mysql connection Activity Streams Bug Tracker Activity WIKI Activity Search More More All Activity Home Sorry, there is a problem The page you requested does not exist Error code: 1S160/2 Contact Us Existing user? Sign In Contact Us mysql connection error To contact us click hereYou can also email us at [emailprotected] Repositories The Link to the master listof MaNGOS repositories: HERE Notice This website and its content is Copyright © 2016 getMaNGOS.All rights Reserved.getMaNGOS & this website is in no way associated with or endorsed by Blizzard Entertainment® All Activity Home Privacy Policy Community Software by Invision Power Services, Inc. × Existing user? Sign In Sign Up Home Forums Downloads Tracker wiki Blogs Browse Back Browse Join Us History Chat Calendar Member Map Staff Activity Back Activity All Activity Github Activity Bug Tracker Activity WIKI Activity My Activity Streams Back Bug Tracker Activity WIKI Activity Search
error appeared in the error dialog box when you click the Execute button. Error. 1364 "field authentication string doesn't have a default value" First, we have to log in through the command prompt.C:/>mysql -u root -pEnter password : *****mysql>use mysql;ALTER TABLE user CHANGE COLUMN authentication_string authentication_string TEXT NULL COLLATE utf8_bin AFTER plugin;After that, again start the installation configuration wizard from the MySQL Installation menu from Start.Now the process will be successfully complete.Thanks,Veera,System Engineer,Climb Inc, Tokyo.http://www.climb.co.jpveerasek@hotmail.com Posted by Veera at 7:50 PM Labels: mysql error 1364 authentication error 2 comments: odeftaJune 11, 2013 at 2:08 AMSimply AWESOME!ThanksReplyDeleteDinesh SarakSeptember 19, 2015 at 11:19 AMgreat,It works within a minuteThanksReplyDeleteAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Followers Blog Archive ▼ 2011 (5) ► July (1) ▼ June (2) MySQL Authentication String error Lotus Notes for EspressChart ► May (2) ► 2010 (12) ► October (2) ► September (2) ► July (6) ► March (2) About Me Veera View my complete profile