Hej,

Musze zresetować hasło do sql ale wywala mi błąd, kroki jakie podejmuje to:

Stop the MySQL server
/usr/local/etc/rc.d/mysql-server stop
Start the MySQL server without the root password
mysqld_safe --skip-grant-tables &
Connect as root to the MySQL server
mysql -u root
Run the following commands, which will reset the root password:
use mysql;
update user set password=PASSWORD("NEW_PASSWORD") where User='root'; <- po tej komendzie wyskakuje mi blad : ERROR 1348 (HY000): Column 'Password' is not updatable

UPDATE mysql.user SET authentication_string = PASSWORD('NOWE_HASŁO') WHERE User = 'root';

10 minut temu, wojciech74 napisał(a):

UPDATE mysql.user SET authentication_string = PASSWORD('NOWE_HASŁO') WHERE User = 'root';

ERROR 1348 (HY000): Column 'authentication_string' is not updatable

Byłoby prościej gdybyś wersję mysql napisał

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NOWE_HASLO';

2 minuty temu, wojciech74 napisał(a):

Byłoby prościej gdybyś wersję mysql napisał

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NOWE_HASLO';

RROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

wersja:
Server version: 10.11.14-MariaDB FreeBSD Ports

daj FLUSH PRIVILEGES; po zalogowaniu do mysql (mysql -u root) i dopiero wtedy spróbuj zmienić hasło

czyli:

service mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NOWE_HASLO';      << Jedna z tych dwóch
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NOWE_HASLO');  << Jedna z tych dwóch
FLUSH PRIVILEGES;
exit;

40 minut temu, wojciech74 napisał(a):

daj FLUSH PRIVILEGES; po zalogowaniu do mysql (mysql -u root) i dopiero wtedy spróbuj zmienić hasło

czyli:

service mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NOWE_HASLO';      << Jedna z tych dwóch
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NOWE_HASLO');  << Jedna z tych dwóch
FLUSH PRIVILEGES;
exit;

hmmm zrobiłem wszystko jak trzeba czyli:

Stop the MySQL server
/usr/local/etc/rc.d/mysql-server stop
Start the MySQL server without the root password
mysqld_safe --skip-grant-tables &
Connect as root to the MySQL server
mysql -u root
Run the following commands, which will reset the root password:
use mysql;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NOWE_HASLO');
flush privileges;
quit
Stop the MySQL server:
/usr/local/etc/rc.d/mysql-server stop
Start it normally:
/usr/local/etc/rc.d/mysql-server start

Jednak gdy chce się połączyć z baza to nie działa:

2002 - Can't connect to server on 'IP' (10061)

zakomentuj bind w my.cnf/server.cnf

#bind-address = 0.0.0.0

I po tej zmianie, którą napisał @wojciech74 zrestartuj mysql.

17 minut temu, wojciech74 napisał(a):

zakomentuj bind w my.cnf/server.cnf

#bind-address = 0.0.0.0

my conf:

cloudinit_enable="YES"
sshd_enable="YES"
sendmail_enable="NONE"
qemu_guest_agent_enable="YES"
qemu_guest_agent_flags="-d -v -l /var/log/qemu-ga.log"
zfs_enable="YES"
hostname=XXX
defaultrouter=5.183.171.1
ifconfig_vtnet0='inet IP netmask 255.255.255.0'
mysql_enable="YES"
#bind-address = 0.0.0.0

#Resetowalem :)

52 minuty temu, Fenrir napisał(a):

my conf:

cloudinit_enable="YES"
sshd_enable="YES"
sendmail_enable="NONE"
qemu_guest_agent_enable="YES"
qemu_guest_agent_flags="-d -v -l /var/log/qemu-ga.log"
zfs_enable="YES"
hostname=XXX
defaultrouter=5.183.171.1
ifconfig_vtnet0='inet IP netmask 255.255.255.0'
mysql_enable="YES"#bind-address = 0.0.0.0

#Resetowalem :)

Majster to nie ten plik xd

Usr/local/etc/mysql tu edytujesz

A w rc usun ten wpis z bind

46 minut temu, wojciech74 napisał(a):

Majster to nie ten plik xd

Usr/local/etc/mysql tu edytujesz

A w rc usun ten wpis z bind

ahh moj blad.

Problem dalej jest taki sam :)

jezeli loguje sie w putty na roota to wszystko mi dzaila, natomiast w Navi mi nie dziala ;p

a mysql w ogole Ci wystartowalo?

24 minuty temu, wojciech74 napisał(a):

a mysql w ogole Ci wystartowalo?

root@:~ # ps aux | grep mysql

mysql 2214 0.0 2.5 602192 102592 0- I+ 22:51 0:00.35 /usr/local/libex

root 2661 0.0 0.3 26064 12152 1 I+ 22:58 0:00.01 mysql -u root -p

root 3487 0.0 0.1 12876 2544 3 S+ 00:01 0:00.00 grep mysql

z tego co widze, dziala

Status mysql sprawdzasz poleceniem:

service mysql-server status

3 minuty temu, Sevence napisał(a):

Status mysql sprawdzasz poleceniem:

service mysql-server status

root@:~ # service mysql-server status

mysql is not running.

hmm... nie działa ;x

No to dlatego nie możesz się połączyć. Wpisz polecenie: service mysql-server start

Teraz, Sevence napisał(a):

No to dlatego nie możesz się połączyć. Wpisz polecenie: service mysql-server start

no tak, jednak ze podczas odpalania sie nie odpala :)

root@:~ # service mysql-server start

Starting mysql.

root@:~ # service mysql-server status

mysql is not running.

root@:~ #

W takim przypadku zaloguj się do ftp poprzez jakiś program typu winscp i wejdź do katalogu /var/log/mysql - będziesz mieć tam plik mysqld.err otwórz go i prześlij nam w załączniku lub wrzuć jego zawartość jeśli nie jest duża.

1 minutę temu, Sevence napisał(a):

W takim przypadku zaloguj się do ftp poprzez jakiś program typu winscp i wejdź do katalogu /var/log/mysql - będziesz mieć tam plik mysqld.err otwórz go i prześlij nam w załączniku lub wrzuć jego zawartość jeśli nie jest duża.

mysqld.err

2025-12-28 22:27:53 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 4314

2025-12-28 22:27:53 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-28 22:27:53 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-28 22:27:53 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-28 22:27:53 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-28 22:27:53 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-28 22:27:53 0 [Note] InnoDB: End of log at LSN=46980

2025-12-28 22:27:53 0 [Note] InnoDB: 128 rollback segments are active.

2025-12-28 22:27:53 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...

2025-12-28 22:27:53 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.

2025-12-28 22:27:53 0 [Note] InnoDB: log sequence number 46980; transaction id 14

2025-12-28 22:27:53 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool

2025-12-28 22:27:53 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-28 22:27:53 0 [Note] InnoDB: Buffer pool(s) load completed at 251228 22:27:53

2025-12-28 22:27:53 0 [Note] Server socket created on IP: '127.0.0.1', port: '3306'.

2025-12-28 22:27:53 0 [Note] /usr/local/libexec/mariadbd: ready for connections.

Version: '10.11.14-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 3306 FreeBSD Ports

2025-12-28 22:31:59 0 [Note] /usr/local/libexec/mariadbd (initiated by: unknown): Normal shutdown

2025-12-28 22:31:59 0 [Note] InnoDB: FTS optimize thread exiting.

2025-12-28 22:31:59 0 [Note] InnoDB: Starting shutdown...

2025-12-28 22:31:59 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool

2025-12-28 22:31:59 0 [Note] InnoDB: Buffer pool(s) dump completed at 251228 22:31:59

2025-12-28 22:32:00 0 [Note] InnoDB: Shutdown completed; log sequence number 46980; transaction id 15

2025-12-28 22:32:00 0 [Note] /usr/local/libexec/mariadbd: Shutdown complete

2025-12-28 22:32:21 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 1934

2025-12-28 22:32:21 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-28 22:32:21 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-28 22:32:21 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-28 22:32:21 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-28 22:32:21 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-28 22:32:21 0 [Note] InnoDB: End of log at LSN=2106273

2025-12-28 22:32:21 0 [Note] InnoDB: 128 rollback segments are active.

2025-12-28 22:32:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...

2025-12-28 22:32:21 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.

2025-12-28 22:32:21 0 [Note] InnoDB: log sequence number 2106273; transaction id 2565

2025-12-28 22:32:21 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool

2025-12-28 22:32:21 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-28 22:32:21 0 [Note] InnoDB: Buffer pool(s) load completed at 251228 22:32:21

2025-12-28 22:32:21 0 [Note] Server socket created on IP: '127.0.0.1', port: '3306'.

2025-12-28 22:32:21 0 [Note] /usr/local/libexec/mariadbd: ready for connections.

Version: '10.11.14-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 3306 FreeBSD Ports

2025-12-28 22:51:10 0 [Note] /usr/local/libexec/mariadbd (initiated by: unknown): Normal shutdown

2025-12-28 22:51:10 0 [Note] InnoDB: FTS optimize thread exiting.

2025-12-28 22:51:10 0 [Note] InnoDB: Starting shutdown...

2025-12-28 22:51:10 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool

2025-12-28 22:51:10 0 [Note] InnoDB: Buffer pool(s) dump completed at 251228 22:51:10

2025-12-28 22:51:11 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"

2025-12-28 22:51:11 0 [Note] InnoDB: Shutdown completed; log sequence number 2106273; transaction id 2566

2025-12-28 22:51:11 0 [Note] /usr/local/libexec/mariadbd: Shutdown complete

2025-12-28 22:51:39 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 2214

2025-12-28 22:51:39 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-28 22:51:39 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-28 22:51:39 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-28 22:51:39 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-28 22:51:39 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-28 22:51:39 0 [Note] InnoDB: End of log at LSN=2106273

2025-12-28 22:51:39 0 [Note] InnoDB: 128 rollback segments are active.

2025-12-28 22:51:39 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...

2025-12-28 22:51:39 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.

2025-12-28 22:51:39 0 [Note] InnoDB: log sequence number 2106273; transaction id 2565

2025-12-28 22:51:39 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool

2025-12-28 22:51:39 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-28 22:51:39 0 [Note] InnoDB: Buffer pool(s) load completed at 251228 22:51:39

2025-12-28 22:51:39 0 [Note] Server socket created on IP: '127.0.0.1', port: '3306'.

2025-12-28 22:51:39 0 [Note] /usr/local/libexec/mariadbd: ready for connections.

Version: '10.11.14-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 3306 FreeBSD Ports

2025-12-28 22:55:30 5 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

2025-12-28 22:55:43 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 2622

2025-12-28 22:55:43 0 [ERROR] mariadbd: Can't lock aria control file '/var/db/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds

2025-12-28 22:56:14 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/db/mysql/aria_log_control'

2025-12-28 22:56:14 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2025-12-28 22:56:14 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-28 22:56:14 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-28 22:56:14 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-28 22:56:14 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-28 22:56:14 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-28 22:56:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35

2025-12-28 22:56:14 0 [Note] InnoDB: Check that you do not already have another mariadbd process using the same InnoDB data or log files.

2025-12-28 22:56:14 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2025-12-28 22:56:14 0 [Note] InnoDB: Starting shutdown...

2025-12-28 22:56:14 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2025-12-28 22:56:14 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-28 22:56:14 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded

2025-12-28 22:56:14 0 [ERROR] Failed to initialize plugins.

2025-12-28 22:56:14 0 [ERROR] Aborting

2025-12-28 22:57:06 6 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

2025-12-28 23:11:17 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

2025-12-28 23:11:25 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

2025-12-28 23:58:45 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 3249

2025-12-28 23:58:45 0 [ERROR] mariadbd: Can't lock aria control file '/var/db/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds

2025-12-28 23:59:02 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 3424

2025-12-28 23:59:02 0 [ERROR] mariadbd: Can't lock aria control file '/var/db/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds

2025-12-28 23:59:16 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/db/mysql/aria_log_control'

2025-12-28 23:59:16 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2025-12-28 23:59:16 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-28 23:59:16 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-28 23:59:16 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-28 23:59:16 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-28 23:59:16 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-28 23:59:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35

2025-12-28 23:59:16 0 [Note] InnoDB: Check that you do not already have another mariadbd process using the same InnoDB data or log files.

2025-12-28 23:59:16 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2025-12-28 23:59:16 0 [Note] InnoDB: Starting shutdown...

2025-12-28 23:59:16 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2025-12-28 23:59:16 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-28 23:59:16 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded

2025-12-28 23:59:16 0 [ERROR] Failed to initialize plugins.

2025-12-28 23:59:16 0 [ERROR] Aborting

2025-12-28 23:59:33 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/db/mysql/aria_log_control'

2025-12-28 23:59:33 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2025-12-28 23:59:33 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-28 23:59:33 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-28 23:59:33 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-28 23:59:33 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-28 23:59:33 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-28 23:59:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35

2025-12-28 23:59:33 0 [Note] InnoDB: Check that you do not already have another mariadbd process using the same InnoDB data or log files.

2025-12-28 23:59:33 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2025-12-28 23:59:33 0 [Note] InnoDB: Starting shutdown...

2025-12-28 23:59:33 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2025-12-28 23:59:33 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-28 23:59:33 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded

2025-12-28 23:59:33 0 [ERROR] Failed to initialize plugins.

2025-12-28 23:59:33 0 [ERROR] Aborting

2025-12-29 0:31:34 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 4180

2025-12-29 0:31:34 0 [ERROR] mariadbd: Can't lock aria control file '/var/db/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds

2025-12-29 0:32:06 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/db/mysql/aria_log_control'

2025-12-29 0:32:06 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2025-12-29 0:32:06 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-29 0:32:06 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-29 0:32:06 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-29 0:32:06 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-29 0:32:06 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-29 0:32:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35

2025-12-29 0:32:06 0 [Note] InnoDB: Check that you do not already have another mariadbd process using the same InnoDB data or log files.

2025-12-29 0:32:06 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2025-12-29 0:32:06 0 [Note] InnoDB: Starting shutdown...

2025-12-29 0:32:06 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2025-12-29 0:32:06 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-29 0:32:06 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded

2025-12-29 0:32:06 0 [ERROR] Failed to initialize plugins.

2025-12-29 0:32:06 0 [ERROR] Aborting

2025-12-29 0:35:50 0 [Note] Starting MariaDB 10.11.14-MariaDB source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid xCXi+ebYucgvex5UeRoJABWwhg8= as process 4585

2025-12-29 0:35:50 0 [ERROR] mariadbd: Can't lock aria control file '/var/db/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds

2025-12-29 0:36:21 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/db/mysql/aria_log_control'

2025-12-29 0:36:21 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2025-12-29 0:36:21 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-12-29 0:36:21 0 [Note] InnoDB: Number of transaction pools: 1

2025-12-29 0:36:21 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2025-12-29 0:36:21 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-12-29 0:36:21 0 [Note] InnoDB: Completed initialization of buffer pool

2025-12-29 0:36:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35

2025-12-29 0:36:21 0 [Note] InnoDB: Check that you do not already have another mariadbd process using the same InnoDB data or log files.

2025-12-29 0:36:21 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2025-12-29 0:36:21 0 [Note] InnoDB: Starting shutdown...

2025-12-29 0:36:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2025-12-29 0:36:21 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-12-29 0:36:21 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded

2025-12-29 0:36:21 0 [ERROR] Failed to initialize plugins.

2025-12-29 0:36:21 0 [ERROR] Aborting

Wygląda jakbyś już miał uruchomiony jakiś proces, który blokuje uruchomienie.

Spróbuj wpisać tak:

pkill -9 mariadbd && pkill -9 mysqld
service mysql-server start
service mysql-server status

root@:~ # pkill -9 mariadbd && pkill -9 mysqld

root@:~ # service mysql-server start

Starting mysql.

root@:~ # service mysql-server status

mysql is not running.

root@:~ #

Ty instalowałeś mysql czy mariadb? Jaką wersję chcesz zainstalować? Spróbuj po prostu reinstall pakietu całkowicie będzie najszybciej.

pkg delete -y 'mysql*'
pkg delete -y 'mariadb*'
pkg autoremove -y

rm -rf /var/db/mysql
rm -rf /usr/local/etc/mysql
rm -f /usr/local/etc/my.cnf
rm -f /etc/my.cnf

I wtedy instalacja na nowo poprzez pkg jak chcesz mariadb czy tam mysql to sprawdź dostępne pakiety
pkg search mariadb lub pkg search mysql - wyskoczy ci lista dostępnych

Nastepnie instalujesz sobie np.
pkg install mariadb106-server-10.6.23

Dodajesz do auto startu:
ee /etc/rc.conf 

Dopisujesz tam:
mysql_enable="YES"
Klikasz ESC
Nastepnie zapisujesz poprzez przycisk A -> A

Wpisujesz service mysql-server start i powinno śmigać

usuń ib_logfile>>start>> jak nie pomoże to usuń ibtmp>>start>> jak nie pomoże to ib_logfile0>>start

no i zrób reboot maszyny

Czy Ty przypadkiem nie wjebałeś gotowca jakiegoś z innego serwera?

3 minuty temu, wojciech74 napisał(a):

usuń ib_logfile>>start>> jak nie pomoże to usuń ibtmp>>start>> jak nie pomoże to ib_logfile0>>start

no i zrób reboot maszyny

Czy Ty przypadkiem nie wjebałeś gotowca jakiegoś z innego serwera?

Ogólnie to kupiłem maszyne tutaj:
https://www.regalhost.eu/

chciałem sprawdzić czy to legit i wszystko ladnie pieknie dziala tylko że nie mam hasła do Navi.
Aktualnie robie reinstall maszyny bo juz za dużo zmian z bazą było.