Skip to main content

MySQL, MariaDB


Wordpress: Sessions löschen

DELETE
FROM `wp_options`
WHERE option_name LIKE '_wp_session%'

Datenbank kopieren

mysql> CREATE DATABASE testdb_copy;  
mysql> SHOW DATABASES;  

mysqldump -u root -p testdb > D:\Database_backup\testdb.sql  

mysql -u root -p testdb_copy < D:\Database_backup\testdb.sql  

mysql> SHOW TABLES;  

Zugriff von außen

$ nano /etc/mysql/my.cnf

OR

$ sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Change the value of the bind-address from 127.0.0.1 to 0.0.0.0 so that MariaDB server accepts connections on all host IPv4 interfaces.

bind-address = 0.0.0.0

Save and close the file when you are finished. Then, restart the MariaDB service to apply the changes:

$ sudo systemctl restart mariadb

You can now verify the MariaDB listening status with the following command: