Mysql Admin Error
Contents |
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MySQL Administrator :: Mysql Administrator error "Could not find settings" New Topic Advanced Search mysql access denied for user using password yes Re: Mysql Administrator error "Could not find settings" Posted by: Colin
Mysql Access Denied For User 'root'@'localhost'
Hume () Date: November 26, 2006 12:47PM This happens because MySQL Administrator cannot find the location of
Mysql Access Denied For User 'root'@'localhost' (using Password Yes)
your My.ini file. To correct this, go to Control Panel->Administrative Tools->Services and check the Properties entry (right-mouse click) against MySQL. What you are looking for is 'Path to
Mysql Access Denied For User 'root'@'localhost' (using Password No)
executable:'. This probably reads as C:\mysql\bin\mysqld.exe MySQL It needs to be changed to "C:\mysql\bin\mysqld.exe" --defaults-file="C:\WINDOWS\MY.INI" MySQL The only way I have found of doing this is to alter the Registry, using Regedit. The key to be changed is HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MySQL\ImagePath You need to modify the key to read as above, including the quotes. Stop and restart the MySQL access denied for user ''@'localhost' to database 'mysql' service, and MySQL Administrator should then work correctly. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Mysql Administrator error "Could not find settings" Eric Johanson 11/25/2006 03:33PM Re: Mysql Administrator error "Could not find settings" Colin Hume 11/26/2006 12:47PM Re: Mysql Administrator error "Could not find settings" Eric Johanson 12/04/2006 10:03AM Re: Mysql Administrator error "Could not find settings" Colin Hume 12/05/2006 12:14PM Re: Mysql Administrator error "Could not find settings" B Griffin 12/26/2006 08:21PM Re: Mysql Administrator error "Could not find settings" Nikos Skatzis 02/12/2007 09:28AM Re: Mysql Administrator error "Could not find settings" Iula Antonio 08/21/2007 07:22AM Re: Mysql Administrator error "Could not find settings" Rick Duke 02/20/2007 12:52PM Re: Mysql Administrator error "Could not find settings" Wade Bushaw 03/02/2007 08:12PM Re: Mysql Administrator error "Could not find settings" Kees de Haan 03/03/2007 10:10AM Re: Mysql Administrator error "Could not find settings" Ruben BC 05/01/2007 02:12PM Re: Mysql Administrator error "Could not find settings" guy pazi 05/10/2007 12:41AM Re: Mysql Administrator error "Could not find se
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators access denied for user 'root'@'localhost' (using password yes) when trying to connect SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning error 1698 (28000): access denied for user 'root'@'localhost' Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems http://forums.mysql.com/read.php?34,128259,128297 Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections http://dev.mysql.com/doc/en/resetting-permissions.html Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.6Mb PDF (A4) - 35.6Mb PDF (RPM) - 34.6Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.4Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: access denied Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top mysql how to fix Access denied for user 'root'@'localhost' up vote 52 down vote favorite 31 Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | access denied for Database | +--------------------+ | information_schema | | mysql | | performance_schema | | game_data | | test | +--------------------+ Then I try to create a new user and notice something is wrong with the PRIVILEGES. So I deleted the new users, and I guess I removed the 'root' and 'Admin' accidentally. Then I try to create 'root' again, but get Access denied error when doing grant all privileges. mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'password' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) If I login mysql again using $ mysql -u root -p, and show databases, +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ All the other databases are gone. How do I fix mysql now? I cannot cannot find the database 'mysql', cannot create database, create user, anything I try to do will get an error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Should I reinstall mysql using macports? If rein