Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

Tutaj można zadać pytanie, jeśli Linuksa widzi się pierwszy raz w życiu ;)
ribbon94
Piegowaty Guziec
Piegowaty Guziec
Posty: 11
Rejestracja: 12 lip 2018, 21:26

Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

Post autor: ribbon94 » 17 lip 2018, 21:41

witam kożystam z ubuntu 16.04 php 7.0 apache 2
mam taki blad /var/log/mysql/error.log

Kod: Zaznacz cały

2018-07-17T17:48:06.094101Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-17T17:48:06.094175Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-17T17:48:06.269109Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-17T17:48:06.271289Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-0ubuntu0.16.04.1) starting as process 309 ...
2018-07-17T17:48:06.276795Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-17T17:48:06.276837Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-17T17:48:06.276844Z 0 [Note] InnoDB: Uses event mutexes
2018-07-17T17:48:06.276852Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-17T17:48:06.276857Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-17T17:48:06.276862Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-17T17:48:06.277172Z 0 [Note] InnoDB: Number of pools: 1
2018-07-17T17:48:06.277317Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-07-17T17:48:06.279648Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-17T17:48:06.289683Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-17T17:48:06.292299Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-17T17:48:06.305172Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-17T17:48:06.339640Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-17T17:48:06.339713Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-17T17:48:06.358049Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-17T17:48:06.359341Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-17T17:48:06.359364Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-17T17:48:06.359728Z 0 [Note] InnoDB: Waiting for purge to start
2018-07-17T17:48:06.409890Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 27483096
2018-07-17T17:48:06.410172Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-17T17:48:06.410300Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-17T17:48:06.411212Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180717 13:48:06
2018-07-17T17:48:06.416293Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-17T17:48:06.416316Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-17T17:48:06.416346Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-17T17:48:06.416373Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-17T17:48:06.424319Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-17T17:48:06.424495Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.22-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-17T17:48:07.098389Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-17T18:09:43.511356Z 31 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:11:57.485395Z 33 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:12:00.277732Z 35 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:41:48.677957Z 49 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:41:48.761061Z 51 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:41:49.425799Z 53 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:41:53.451395Z 55 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:41:53.616183Z 57 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:41:54.527906Z 59 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:25.042416Z 67 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:25.419651Z 69 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:25.670171Z 71 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:26.121297Z 73 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:26.989314Z 75 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:27.482286Z 77 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:28.162157Z 79 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:53:28.335354Z 81 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:10:57.180768Z 105 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:10:57.488341Z 107 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:10:57.580197Z 109 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:33.736825Z 116 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:33.915044Z 118 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:33.966016Z 120 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:35.259681Z 122 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:35.746972Z 124 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:40.776311Z 126 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:26:41.947656Z 128 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:27:36.231523Z 130 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T19:27:54.890683Z 132 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
i chyba to blokuje mi dostep strony względem bazy bo loga same strony var/ww/ nie ma baza strony korzysta z usera otservv
http://195.242.117.68/index.php
Awatar użytkownika
mario_7
Administrator
Administrator
Posty: 7520
Rejestracja: 30 sie 2006, 13:11
Płeć: Mężczyzna
Wersja Ubuntu: 18.04
Środowisko graficzne: GNOME
Architektura: x86_64

Re: Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

Post autor: mario_7 » 17 lip 2018, 23:53

Dostęp czego do czego jest blokowany?
Czytelnia - poczytaj, Google - poszukaj
ribbon94
Piegowaty Guziec
Piegowaty Guziec
Posty: 11
Rejestracja: 12 lip 2018, 21:26

Re: Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

Post autor: ribbon94 » 18 lip 2018, 09:41

juz chyba wiem co jest przyczyna coś złe się zainstalowało z mysql podacie mi komedy do unistalu wszystkich pakietów
mysql
phpmyadmin
apache
i jak sprawdzić co jeszcze, moze razem przejdziemy wszystkie etapy instalacji bo juz chyba 3 razy instalowałem system na nowo i na nowo instalowałem wszystkie pakiety i cały czas coś jest nie tak
i nastepnym krokiem jak je wszystkie poprawnie instalowac korzystałem juz z rożnych poradników ale 3 dzien walcze z konfiguracja var/ww/ bo klient otservera z home/otserv/ laczy się poprawnie z baza bo wszystko tutaj hula
Awatar użytkownika
Tomfoc
Przebojowy Jelonek
Przebojowy Jelonek
Posty: 1772
Rejestracja: 30 lis 2011, 21:14
Płeć: Mężczyzna
Wersja Ubuntu: 18.04
Środowisko graficzne: GNOME
Architektura: x86_64

Re: Access denied for user 'phpmyadmin'@'localhost' (using password: YES)

Post autor: Tomfoc » 18 lip 2018, 09:45

W regulaminie Forum jest mowa o poszanowaniu języka polskiego. Skończ z tym bełkotem.
Laptop: Lenovo Ideapad 300, CPU: Intel® Core™ i5-6200U CPU @ 2.30GHz × 4, GPU: Intel® HD Graphics 520 (Skylake GT2), RAM: 8 GB, HDD: 500 GB
ODPOWIEDZ

Wróć do „Przedszkole Linuksa”