Access denied for user 'root'@'localhost'


        
            
                Markdown 1.84 KB
                                    
                        | None                    
                
                                        |
    0    0                            

            
                
                                    raw
                    download
                    clone
                    embed
                    print
                
                                    report
                
                
                            
        
        
            $ sudo su
# mysql -u root
Saída 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
mysql> use mysql;
mysql> select user,host,plugin from mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| root             | localhost | mysql_native_password |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| debian-sys-maint | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
MySQL
mysql> create user 'user'@'localhost' identified by 'abcd1234';
mysql> grant all privileges on *.* to 'user'@'localhost';
mysql> update user set plugin="auth_socket" where user='user';
mysql> flush privileges;
mysql> select user,host,plugin from mysql.user;
MariaDB
mysql> create user 'user'@'localhost' identified by 'abcd1234';
mysql> grant all privileges on *.* to 'user'@'localhost';
mysql> update user set plugin="unix_socket" where user='user';
mysql> flush privileges;
mysql> select user,host,plugin from mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| root             | localhost | mysql_native_password |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| debian-sys-maint | localhost | mysql_native_password |
| user_mysql       | localhost | auth_socket           |
+------------------+-----------+-----------------------+
mysql> exit
Test
$ mysql -u user -p