Error 1045 Access Denied for user 'root@localhost' using passworf YES

Hi!!


{From Docs}

>>Error 1045 - Acess denied for 'root@localhost' using password YES

This simply means that your username or password are incorrect. If you have not changed the username, try using 'root' as the username and no password(blank). If that works, then you are ok. Otherwise, you need to find the correct username / password combination OR set the proper permissions for that particular user to that database.

Also check here

http://dev.mysql.com/doc/mysql/en/access-denied.html

If you have lost the password then check out here how to reset root password..

http://dev.mysql.com/doc/mysql/en/resetting-permissions.html



>>Also, MySQLAdministrator starts with "Stored Connection" (which I have entered as being localhost), but I haven't found a manual which explains this input.

If the server connection is successfully established, all of the values filled in the fields of the connection dialog will be saved for future connections

On Windows, connection profiles are stored in C:\Documents and Settings\UserName\Application Data\MySQL directory, where UserName is the name of the current Windows user. On Linux, the files are stored in the ~/.mysqlgui directory. The settings are stored in a file called mysqlx_user_connections.xml. The contents of that file look like this:

   <?xml version="1.0"?>
   <user_connections>
    <last_connection>1</last_connection>
    <password_storage_type>2</password_storage_type>
    <user_connection>
     <connection_name></connection_name>
     <username>root</username>
     <hostname>localhost</hostname>
     <port>3306</port>
     <schema></schema>
     <advanced_options/>
     <storage_path></storage_path>
     <notes></notes>
     <connection_type>0</connection_type>
     <storage_type>2</storage_type>
     <password></password>
    </user_connection>
    ...
 
You can edit the file manually, but take care not to invalidate the XML. When applying changes by editing and saving the file, those changes will show up the next time you open the Connections section of the Options Dialog. You do not need to restart your application for the changes to take effect.

for more check out here
http://dev.mysql.com/doc/administrator/en/mysql-administrator-starting-connection.html

>>Also, when the program dialog asks for Server Host, do you use 'localhost' ? (which is an Apache directory variable) or is it looking for the MySQL/bin directory location?

Server Host  should be the IP address of the machine running mysql server..say you will be connecting from the same mahine where mysql is installed then this will be localhost.. also note that default setting will allow root to connect from the same host where mysql is running..