ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) hatası için denediğim ve sorunu çözdüğüm adımlar,
1-MySQL'i Kapatıyoruz
sudo service mysql stophata alırsanız.
sudo /usr/local/mysql/support-files/mysql.server stop deneyiniz.
2-MySQL'i Güvenli mod ile açıyoruz
sudo mysqld_safe --skip-grant-tables --skip-networking3- MySQL'e bağlanıyoruz
mysql -u root3a- Cavap Olarak
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 25
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
4- MySQL de mysql veritabanına giriyoruz
use mysql4a- Cevap Olarak
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
5-mysql veritabanındaki tabloları listeliyoruz(Bende hata verdi, ama normalde tabloları listelemesi gerekiyor çok önemli değil)
5a- Cevap Olarak
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'snow tables' at line 1
6-mysql veritabanındaki user tablosunu yapısını görüyoruz.
desc user6a- Cevap Olarak
-> ;
+------------------------+-----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(80) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) | NO | | 0 | |
| plugin | char(64) | NO | | | |
| authentication_string | text | NO | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
| is_role | enum('N','Y') | NO | | N | |
+------------------------+-----------------------------------+------+-----+---------+-------+
44 rows in set (0.00 sec)
7-mysql veritabanındaki user tablosundan User,Password,Host bakıyoruz
select User,Password,Host from user;7a- Cevap Olarak
+------+----------+-----------+
| User | Password | Host |
+------+----------+-----------+
| root | 1086 | localhost |
+------+----------+-----------+
8-Şifremizi Değiştiriyoruz.(Şifreyi=1086 Olarak tanımlıyoruz)
UPDATE mysql.user SET Password=PASSWORD('1086') WHERE User='root';
8a- Cevap Olarak
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
9-Kontrol
UPDATE mysql.user SET Password=PASSWORD('1086') WHERE User='root';
9-Cevap
+------+-------------------------------------------+-----------+
| User | Password | Host |
+------+-------------------------------------------+-----------+
| root | *39701EADABB03FE701CC77FC7B9A9667B78595F4 | localhost |
+------+-------------------------------------------+-----------+
1 row in set (0.00 sec)
10- Tazeleme
flush privileges;10a- Cevap Olarak
Query OK, 0 rows affected (0.00 sec)
11- Çıkış
quit12- Durdurup Tekrar Başlatıyoruz.
sudo service mysql stopsudo service mysql start13-Deneme
mysql -u root -pŞifremizi giriyoruz:1086
13a- Cevap Olarak
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 25
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Umarım Faydaı olmuştur.
