MySQL stopped

taker18

taker18

Verified User
Joined
Oct 18, 2021
Messages
141
Location
USA
I was looking to create a backup for one of my sites but by mistake created a backup for the system. than right away no access to all my sites MySQLd stopped I am still able to access direct admin panel.
at the : View Log: /var/log/directadmin/errortaskq.log I found this message:
2022:01:28-01:58:05: Unknown mysql password format: '$A$005$m.iem%qm
' b1>Y!4DSjdcS8D87yxMeLHgOYvX0u88E0vO5e4q7RnFAtkLC/.'

2022:01:28-02:10:01: service mysqld wasn't running, starting mysqld
2022:01:28-02:10:06: service mysqld didn't start, re-starting mysqld
2022:01:28-02:10:11: unable to stat ./data/admin/admin.conf.temp for filesize after write: euid:114
2022:01:28-02:10:11: Unable to write ./data/admin/admin.conf: Unable to stat ./data/admin/admin.conf.temp for filesize after write<br>
ConfigFile::removeFile(./data/admin/admin.conf) filename does not match<br>

Please excuse me if not showing the right Error Message, can youtell where i can get the the error messages.
ok now please i need some help all sites are down
 
Creating backup does not effect your sql server.
taker18 said:
View Log: /var/log/directadmin/errortaskq.log I found this message:
2022:01:28-01:58:05: Unknown mysql password format: '$A$005$m.iem%qm
' b1>Y!4DSjdcS8D87yxMeLHgOYvX0u88E0vO5e4q7RnFAtkLC/.'
Click to expand...
This is the problem maybe , try to not use fancy characters in your password.

Did you try to rebuild your mysq ?
 
that might be correct, this morning came to my mind to change the DB passwords of each site. but I found a whole another issue that I am not able to log on to the DA panel itself. sounds like while I was trouble shooting did something wrong. I tried to change the password
(passwd admin) on my terminal still not login why I am not able to log in
 
taker18 said:
I checked for Err with :
/var/lib/mysql/`hostname`.err
result: -bash: /var/lib/mysql/server.hostname.com.err: Permission denied
Click to expand...
Try:
less /var/lib/mysql/server.hostname.com.err
where the server.hostname.com part is replaced by your real hostame. You should then be able to view the content of that file.

taker18 said:
(passwd admin) on my terminal
Click to expand...
That does only change da password (and admins ftp) but not them mysql password.

To change the mysql root pass, you might want to check this:

Troubleshooting | Directadmin Docs

DirectAdmin Knowledge Base
docs.directadmin.com
 
Richard G said:
Try:
less /var/lib/mysql/server.hostname.com.err
where the server.hostname.com part is replaced by your real hostame. You should then be able to view the content of that file.


That does only change da password (and admins ftp) but not them mysql password.

To change the mysql root pass, you might want to check this:

Troubleshooting | Directadmin Docs

DirectAdmin Knowledge Base
docs.directadmin.com
Click to expand...
Thank @Richard G and @Active8 for your great help. Regarding the troubleshooting in the Troubleshooting | Directadmin Docs is what was used early and sounds like I locked myself out. not sure how. now the main issue that I did something my DA panel that is not accepting the password, it with SSH. now, what should I do. I have a backup which i will keep as last resort. that will waste some work that was not backed up. let's try our best and thank you all for the help.
this is what I got from the less /var/lib/mysql/server.hostname.com.err:

2022-01-02T17:34:35.553783Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data


2022-01-02T17:34:35.719856Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


2022-01-02T17:34:35.719961Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled


2022-01-02T17:34:35.719980Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.35) starting as process 53837 ...


2022-01-02T17:34:35.722716Z 0 [Note] InnoDB: PUNCH HOLE support available


2022-01-02T17:34:35.722733Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins


2022-01-02T17:34:35.722736Z 0 [Note] InnoDB: Uses event mutexes


2022-01-02T17:34:35.722738Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier


2022-01-02T17:34:35.722741Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11


2022-01-02T17:34:35.722743Z 0 [Note] InnoDB: Using Linux native AIO


2022-01-02T17:34:35.722867Z 0 [Note] InnoDB: Number of pools: 1


2022-01-02T17:34:35.722917Z 0 [Note] InnoDB: Using CPU crc32 instructions


2022-01-02T17:34:35.723791Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M


2022-01-02T17:34:35.728713Z 0 [Note] InnoDB: Completed initialization of buffer pool


2022-01-02T17:34:35.729783Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().


2022-01-02T17:34:35.741004Z 0 [Note] InnoDB: Highest supported file format is Barracuda.


2022-01-02T17:34:35.746586Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables


2022-01-02T17:34:35.746620Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...


2022-01-02T17:34:35.757327Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.


2022-01-02T17:34:35.757860Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.


2022-01-02T17:34:35.757867Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.


2022-01-02T17:34:35.758075Z 0 [Note] InnoDB: Waiting for purge to start


2022-01-02T17:34:35.808259Z 0 [Note] InnoDB: 5.7.35 started; log sequence number 2748441


2022-01-02T17:34:35.808469Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool


2022-01-02T17:34:35.808580Z 0 [Note] Plugin 'FEDERATED' is disabled.


2022-01-02T17:34:35.809668Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220102 17:34:35


2022-01-02T17:34:35.812512Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.


2022-01-02T17:34:35.812522Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.


2022-01-02T17:34:35.812527Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.


2022-01-02T17:34:35.812530Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.


2022-01-02T17:34:35.813071Z 0 [Warning] CA certificate ca.pem is self signed.


2022-01-02T17:34:35.813105Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.


2022-01-02T17:34:35.813849Z 0 [Note] Server hostname (bind-address): '*'; port: 3306


2022-01-02T17:34:35.813960Z 0 [Note] IPv6 is available.


2022-01-02T17:34:35.813971Z 0 [Note] - '::' resolves to '::';


2022-01-02T17:34:35.813991Z 0 [Note] Server socket created on IP: '::'.


2022-01-02T17:34:35.821453Z 0 [Note] Event Scheduler: Loaded 0 events
 
well, I had to restore from my old backup. one mistake I did is fancy characters like $%@$ with the passwords are not good, and I did this thank you all
 
You must log in or register to reply here.
Back
Top