Hallo
Ich versuche gerade auf Debian 10x64 (buster) die Serverumgebung mit reihe 6 in 64bit zu Installieren. Ich habe dazu mit ps -ef | grep mysql gecheckt ob ein mysql server läuft aber dem ist wohl nicht so. Auch die üblichen Verzeichnisse lassen nicht auf einen MySql-server deuten.
root@ve241:/var/run# ps -ef | grep mysql
root 624 598 0 18:40 pts/0 00:00:00 grep mysql
Ich habe dazu folgendes vorher installiert
Apt-get update
Apt-get upgrade
Apt-get install g++ gcc imagemagick lib32ncurses6 lib32stdc++6 lib32z1 libc6-dev-i386 make patch psmisc rrdtool groff wget lz4 libtinfo5
Neustart.
Wenn ich die Installation so beobachte, kommen ein Haufen Warnungen unterschiedlichster Art und weise. Am Schluss und zwischen durch, wenn es dann bei „MySql wird angefahren“ kommt, kommen dann folgende oder ähnliche Fehler/Warnungen.
Waiting for MySQL
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
pd-admin wurde erfolgreich installiert.
Bitte fuehren Sie nun das Skript /opt/pdadmin/bin/create_reseller.pl
aus, um einen Administrator-Account anzulegen.
root@876/usr/local/pdadmin#
Ich habe die Installation nun auf Debian9/10, Centos7/8 und ubuntu 20.04 versucht, aber es kommt immer dieser Fehler nach der Installation. Ich kann die Weboberfläche starten und alles einstellen und anlegen wie ich möchte aber ich kann mich nicht per phpMyAdmin einloggen, er sagt immer Passwort Fehler, ob root oder user.
Bin mit meinem Latein am ende und hoffe hier auf Hilfe.
lieben Dank sagt Frank
Nachtrag
mysql error.log
2021-08-29T17:16:04.153461Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-08-29T17:16:04.153588Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-08-29T17:16:04.153592Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-08-29T17:16:04.153620Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-08-29T17:16:04.153944Z 0 [Note] /usr/local/pd-admin2/bin/mysqld (mysqld 5.7.35) starting as process 740 ...
2021-08-29T17:16:04.169017Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-08-29T17:16:04.169036Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-08-29T17:16:04.169040Z 0 [Note] InnoDB: Uses event mutexes
2021-08-29T17:16:04.169043Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-08-29T17:16:04.169046Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-29T17:16:04.169970Z 0 [Note] InnoDB: Number of pools: 1
2021-08-29T17:16:04.171658Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-08-29T17:16:04.172312Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-08-29T17:16:04.177273Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-29T17:16:04.179000Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-08-29T17:16:04.194808Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-29T17:16:04.209717Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-29T17:16:04.209759Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-29T17:16:04.241200Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-08-29T17:16:04.241870Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-08-29T17:16:04.241878Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-08-29T17:16:04.242393Z 0 [Note] InnoDB: 5.7.35 started; log sequence number 2860989
2021-08-29T17:16:04.242578Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/ib_buffer_pool
2021-08-29T17:16:04.243114Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-08-29T17:16:04.249080Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-08-29T17:16:04.249092Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-08-29T17:16:04.249095Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2021-08-29T17:16:04.249097Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2021-08-29T17:16:04.250423Z 0 [Warning] CA certificate ca.pem is self signed.
2021-08-29T17:16:04.250452Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-08-29T17:16:04.255655Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210829 19:16:04
2021-08-29T17:16:04.278673Z 0 [Note] Event Scheduler: Loaded 0 events
2021-08-29T17:16:04.278831Z 0 [Note] /usr/local/pd-admin2/bin/mysqld: ready for connections.
Version: '5.7.35' socket: '/usr/local/pd-admin2/var/mysql.run/mysql.sock' port: 0 Source distribution
2021-08-29T17:27:33.494008Z 2 [Note] Aborted connection 2 to db: 'vadmin' user: 'vadmin' host: 'localhost' (Got an error reading communication packets)
2021-08-29T17:28:11.990180Z 3 [Note] Aborted connection 3 to db: 'vadmin' user: 'vadmin' host: 'localhost' (Got an error reading communication packets)
2021-08-29T17:41:45.037980Z 6 [Note] Aborted connection 6 to db: 'vadmin' user: 'vadmin' host: 'localhost' (Got an error reading communication packets)