You need to set the password for `root@localhost` to be blank. There are two ways:

 1. The MySQL [`SET PASSWORD`](http://dev.mysql.com/doc/refman/5.0/en/set-password.html) command:

        SET PASSWORD FOR root@localhost=PASSWORD(&#39;&#39;); -- MySQL 5.x
        SET PASSWORD FOR root@localhost=&#39;&#39;; -- MySQL 8.x

 2. Using the command-line [`mysqladmin`](http://dev.mysql.com/doc/en/mysqladmin.html) tool:

        mysqladmin -u root -pType_in_your_current_password_here password &#39;&#39;


I have also been through this problem,

First i tried setting my password of root to blank using command :
   
    SET PASSWORD FOR root@localhost=PASSWORD(&#39;&#39;);

But don&#39;t be happy , PHPMYADMIN uses 127.0.0.1 not localhost , i know you would say both are same but that is not the case , use the command mentioned underneath and you are done.

    SET PASSWORD FOR root@127.0.0.1=PASSWORD(&#39;&#39;);

Just replace localhost with 127.0.0.1 and you are done .

I would like a ScrollView to start all the way at the bottom. Any methods?

Android: ScrollView force to bottom

I have heard a lot of people talking recently about _middleware_, but what is the exact definition of middleware? When I look into middleware, I find a lot of information and some definitions, but while reading these information and definitions, it seems that mostly all &#39;wares&#39; are in the middle of something. So, are all things middleware?

Or do you have an example of a ware that isn&#39;t middleware?

What is middleware exactly?

I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That&#39;s why phpmyadmin is giving an error:

` #1045 - Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO) `







How to remove MySQL root password

<p>I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That's why phpmyadmin is giving an error:</p>
<p><code>#1045 - Access denied for user 'root'@'localhost' (using password: NO)</code></p>


Where can I find the MySQL&#39;s logs (errors, queries, etc.) in the phpMyAdmin interface?

Where can I find MySQL logs in phpMyAdmin?

Say that I have a long, expensive query, packed with conditions, searching a large number of rows. I also have one particular condition, like a company id, that will limit the number of rows that need to be searched considerably, narrowing it down to dozens from hundreds of thousands.

Does it make any difference to MySQL performance whether I do this:

     SELECT * FROM clients WHERE 
           (firstname LIKE :foo OR lastname LIKE :foo OR phone LIKE :foo) AND 
           (firstname LIKE :bar OR lastname LIKE :bar OR phone LIKE :bar) AND 
           company = :ugh

or this:


     SELECT * FROM clients WHERE 
           company = :ugh AND
           (firstname LIKE :foo OR lastname LIKE :foo OR phone LIKE :foo) AND 
           (firstname LIKE :bar OR lastname LIKE :bar OR phone LIKE :bar) 


Does the order of conditions in a WHERE clause affect MySQL performance?

This is what I tried:

    $ easy_install-2.6 -d /home/user/lib/python2.6 MySQLdb  
    Searching for MySQLdb  
    Reading http://pypi.python.org/simple/MySQLdb/  
    Couldn&#39;t find index page for &#39;MySQLdb&#39; (maybe misspelled?)  
    Scanning index of all packages (this may take a while)  
    Reading http://pypi.python.org/simple/  
    No local packages or download links found for MySQLdb  
    error: Could not find suitable distribution for Requirement.parse(&#39;MySQLdb&#39;)  



Why can&#39;t easy_install find MySQLdb?

I&#39;ve been using indexes on my MySQL databases for a while now but never properly *learnt* about them. Generally I put an index on any fields that I will be searching or selecting using a `WHERE` clause but sometimes it doesn&#39;t seem so black and white.

**What are the best practices for MySQL indexes?**

Example situations/dilemmas:

* If a table has six columns and all of them are searchable, should I index all of them or none of them?

* What are the negative performance impacts of indexing?

* If I have a VARCHAR 2500 column which is searchable from parts of my site, should I index it?



MySQL indexes - what are the best practices?

I&#39;ve been working on writing SQL to create a MySQL database with several default options, including character set and collation.  Is it possible to set the default storage engine for tables in this database to InnoDB? 

I&#39;ve been looking through the MySQL 5.1 manual and I&#39;ve found the statement `ENGINE=innodb` which would be appended to a `CREATE TABLE` statement, but I haven&#39;t found anything related to a `CREATE DATABASE` statement.  

Is there a normal way to do this as part of the database creation, or does it need to be specified on a table-by-table basis?


How can I set default storage engine used by MySQL?

I&#39;m trying to setup up MySQL on mac os 10.6 using Homebrew by `brew install mysql 5.1.52`.

Everything goes well and I am also successful with the `mysql_install_db`.  
However when I try to connect to the server using:

    /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password &#39;mypass&#39;

I get: 

&lt;pre&gt;
/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at &#39;localhost&#39; 
failed error: &#39;Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)&#39;&lt;/pre&gt;

I&#39;ve tried to access `mysqladmin or mysql using -u root -proot` as well,  
but it doesn&#39;t work with or without password. 

This is a brand new installation on a brand new machine and as far as I know the new installation must be accessible without a root password. I also tried:

    /usr/local/Cellar/mysql/5.1.52/bin/mysql_secure_installation

but I also get 

&lt;pre&gt;
ERROR 1045 (28000): Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)&lt;/pre&gt;



brew install mysql on macOS

Any ideas? 

    SELECT * INTO OUTFILE &#39;/home/myacnt/docs/mysqlCSVtest.csv&#39;
    FIELDS TERMINATED BY &#39;,&#39; OPTIONALLY ENCLOSED BY &#39;*&#39;
    LINES TERMINATED BY &#39;\n&#39;
    FROM tbl_property 
    WHERE managerGroupID = {$managerGroupID}

Error:

    Access denied for user &#39;asdfsdf&#39;@&#39;localhost&#39; (using password: YES)

MYSQL into outfile &quot;access denied&quot; - but my user has &quot;ALL&quot; access.. and the folder is CHMOD 777

I&#39;ve looked at a number of similar questions and so I&#39;m demonstrating that I&#39;ve checked the basics. Though of course, that doesn&#39;t mean I haven&#39;t missed something totally obvious. :-)

My question is: why am I denied access on a user with the privileges to do what I&#39;m trying to do and where I have already typed the password and been granted access? (For the sake of completeness, I tried typing the wrong password just to make sure that MySQL client would deny me access at program start.)

Background:

Logged in to the shell of the machine running the MySQL server via ssh, I log in as root:

    [myname@host ~]$ mysql -u root -p -hlocalhost
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 62396
    Server version: 5.5.18-log MySQL Community Server (GPL)
    
    Type &#39;help;&#39; or &#39;\h&#39; for help. Type &#39;\c&#39; to clear the current input statement.

    mysql&gt; 

Awesome. My reading of the answers to similar questions suggests that I should make sure the the privileges are current with what is in the grant tables

    mysql&gt; FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)

    mysql&gt; 

Next make sure I am who I think I am:

    mysql&gt; SELECT user();
    +----------------+
    | user()         |
    +----------------+
    | root@localhost |
    +----------------+
    1 row in set (0.00 sec)

...and really *really* make sure:

    mysql&gt; SELECT current_user();
    +----------------+
    | current_user() |
    +----------------+
    | root@localhost |
    +----------------+
    1 row in set (0.00 sec)

    mysql&gt; 

So far so good. Now what privileges do I have?

    mysql&gt; SHOW GRANTS FOR &#39;root&#39;@&#39;localhost&#39;;
    +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Grants for root@localhost                                                                                                                                                                                                                                                                                                                                                                                                        |
    +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO &#39;root&#39;@&#39;localhost&#39; IDENTIFIED BY PASSWORD &#39;[OBSCURED]&#39; WITH GRANT OPTION |
    +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    1 row in set (0.00 sec)

Now that&#39;s a little hard to read, so lets try this way (you will also get to see that there is a non-localhost &#39;root&#39; user):

    mysql&gt; SELECT * FROM mysql.user WHERE User=&#39;root&#39;\G
    *************************** 1. row ***************************
                     Host: localhost
                     User: root
                 Password: *[OBSCURED]
              Select_priv: Y
              Insert_priv: Y
              Update_priv: Y
              Delete_priv: Y
              Create_priv: Y
                Drop_priv: Y
              Reload_priv: Y
            Shutdown_priv: Y
             Process_priv: Y
                File_priv: Y
               Grant_priv: Y
          References_priv: Y
               Index_priv: Y
               Alter_priv: Y
             Show_db_priv: Y
               Super_priv: Y
    Create_tmp_table_priv: Y
         Lock_tables_priv: Y
             Execute_priv: Y
          Repl_slave_priv: Y
         Repl_client_priv: Y
         Create_view_priv: Y
           Show_view_priv: Y
      Create_routine_priv: Y
       Alter_routine_priv: Y
         Create_user_priv: Y
               Event_priv: Y
             Trigger_priv: Y
                 ssl_type: 
               ssl_cipher: 
              x509_issuer: 
             x509_subject: 
            max_questions: 0
              max_updates: 0
          max_connections: 0
     max_user_connections: 0
    *************************** 2. row ***************************
                     Host: [HOSTNAME].com
                     User: root
                 Password: *[OBSCURED]
              Select_priv: Y
              Insert_priv: Y
              Update_priv: Y
              Delete_priv: Y
              Create_priv: Y
                Drop_priv: Y
              Reload_priv: Y
            Shutdown_priv: Y
             Process_priv: Y
                File_priv: Y
               Grant_priv: Y
          References_priv: Y
               Index_priv: Y
               Alter_priv: Y
             Show_db_priv: Y
               Super_priv: Y
    Create_tmp_table_priv: Y
         Lock_tables_priv: Y
             Execute_priv: Y
          Repl_slave_priv: Y
         Repl_client_priv: Y
         Create_view_priv: Y
           Show_view_priv: Y
      Create_routine_priv: Y
       Alter_routine_priv: Y
         Create_user_priv: Y
               Event_priv: Y
             Trigger_priv: Y
                 ssl_type: 
               ssl_cipher: 
              x509_issuer: 
             x509_subject: 
            max_questions: 0
              max_updates: 0
          max_connections: 0
     max_user_connections: 0
     2 rows in set (0.00 sec)

Awesome! MySQL thinks that I am root@localhost and root@localhost has all those privileges. That means I ought to be able to do what I want, right?

    mysql&gt; GRANT ALL PRIVILEGES ON *.* TO &#39;steves&#39;@&#39;[hostname].com&#39; IDENTIFIED BY &#39;[OBSCURED]&#39; WITH GRANT OPTION;
    ERROR 1045 (28000): Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: YES)

How could I have screwed up something this basic?

Side note: for anyone who wants to suggest that I not have a user named root with all privileges, that&#39;s great and something I&#39;ll consider doing once I can give another user some privileges.

Thank you!

Access denied for user &#39;root&#39;@&#39;localhost&#39; while attempting to grant privileges. How do I grant privileges?

This is a tricky one, I have the following output:

&gt; mysqldump: Got error: 1045: Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: YES) when trying to connect

When attempting to export my database with `mysqldump` on Windows XP. The username is root, the password is correct and contains only alphanumeric characters. I have tried different cases, with/without quotes, specifying using `-u` and `-p`, specifying using `--user=` and `--password=` and other methods of specifying user/passwords etc, specifying the host (it&#39;s all local) and even specifying the database using `--databases` instead of just blank.  The error is always the same when using a password and always the same except the &quot;NO&quot; message when without.  I have tried many fixes found through searches with no success.  One fix suggested inspecting mysql.conf, but the Windows build doesn&#39;t seem to have one.  The credentials (and indeed commandline parameters) work perfectly with mysql.exe - this problem only seems to be affecting mysqldump.exe.

mysqldump Error 1045 Access denied despite correct passwords etc

I am facing problem with mysql non root/admin user, I am following the below steps for creating user and its privileges, correct me if i am doing wrong,

i am installing `mysql` on `RHEL 5.7 64bit`, packages are mentioned below, once i done the `rpm install` we are 

 1. creating mysql db using `mysql_install_db`, then 
 2. starting the mysql service then 
 3. using `mysql_upgrade` also we are doing to the server.

After this process i can login as `root` but with a non-root user I am not able to log into the server:

    [root@clustertest3 ~]# rpm -qa | grep MySQL
    MySQL-client-advanced-5.5.21-1.rhel5
    MySQL-server-advanced-5.5.21-1.rhel5

    
    [root@clustertest3 ~]# cat /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    
    # Disabling symbolic-links is recommended to prevent assorted security risks;
    # to do so, uncomment this line:
    # symbolic-links=0
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
    [root@clustertest3 ~]# ls -ld /var/lib/mysql/mysql.sock
    srwxrwxrwx 1 mysql mysql 0 Nov  30 11:09 /var/lib/mysql/mysql.sock
    
    mysql&gt; CREATE USER &#39;golden&#39;@&#39;%&#39; IDENTIFIED BY &#39;password&#39;;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql&gt; GRANT ALL PRIVILEGES ON * . * TO &#39;golden&#39;@&#39;%&#39;;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql&gt; FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql&gt; SELECT USER(),CURRENT_USER();
    +----------------+----------------+
    | USER()         | CURRENT_USER() |
    +----------------+----------------+
    | root@localhost | root@localhost |
    +----------------+----------------+
    1 row in set (0.00 sec)

    [root@clustertest3 ~]# mysql -ugolden -p
    Enter password:
    ERROR 1045 (28000): Access denied for user &#39;golden&#39;@&#39;localhost&#39; (using password: YES)

This is the problem I am facing, is there any solution to this?

Content Type	Original Author	Original Content on Stackoverflow
Question	nectar	View Question on Stackoverflow
Solution 1 - Mysql	Dario	View Answer on Stackoverflow
Solution 2 - Mysql	Faiz Akhtar	View Answer on Stackoverflow

How to remove MySQL root password

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

What is middleware exactly?

Android: ScrollView force to bottom

Attributions