Search for a command to run...
Articles tagged with #mysql
Magento Commerce (EE) offers powerful features, but for many teams, Open Source (CE) is leaner, lighter, and more sustainable. If you're migrating from EE to CE, the Opengento downgrade tool provides a clean, scriptable way to remove proprietary modu...
In case to run multiple versions of MySQL, we can do in several ways. In this article, I'm going to run MySQL multiple versions using Docker & using MariaDB instead of mysql. 1. Install Docker since we're going to use docker, of course we need to ins...
MySQL provides metadata of the database itself, basically just run this on your query. Don't forget to replace database name with yourown database name. SELECT TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)...
Update password can be done via mysql query, simply just execute this query to update customer’s password : UPDATE customer_entity SET password_hash = CONCAT(SHA2('xxxxxxxTypeYourPasswordHere', 256), ':xxxxxxx:1') WHERE email = 'johndoe@example.com';...
Do you face an issue whereas you can't connect to MySQL? Try to check domysqld.sock and mysqld.pid exist or not. If not, inside the docker terminal, run these commands : sudo touch /var/run/mysqld/mysqld.sock sudo touch /var/run/mysqld/mysqld.pid sud...
