Viewing 1 to 10 of 26 items
Archive | MySql RSS feed for this section

MacOS – Update password for root user of MySQL/MariaDB

For some reason, MySQL/MariaDB stopped giving access to the root user. Uninstalled and reinstalled with Homebrew. Fresh install, fresh tables but when you enter mysql -u root -p You get this error: Access denied for user ‘root’@’localhost’ (using password: NO). You reinstalled MySQL/MariaDB many times but it is still asking for a password. Here is  Full Article…


MySQL – Remove all triggers by using the SQL queries

Sometimes you want to remove all existing triggers in your database so that you can create the new one. You can execute the following SQL query to generate all necessary SQL queries to remove the triggers in your database. SELECT Concat(‘DROP TRIGGER ‘, Trigger_Name, ‘;’) FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA = ‘your_database_name’; After that, you can  Full Article…


Mysql – Grant a user permission to only show a view

Here are some SQL queries that you need to execute to grant the permission for existing user to a specific view. The first command: GRANT SELECT ON <database_name>.<view_name> TO <user>@<host>   The second command: GRANT SHOW VIEW ON <database_name>.<view_name> TO <user>@<host>


Mysql – Too many connections

If you see the error "… To many connections…" while you are accessing your website, you can do the following ways: 1. In your mysql my must to run this: Set Global max_connections=2000 I'm using phpMyAdmin and I executed   2. In your my.conf file (usually located in /etc) find the line that says: [mysqld] And somewhere  Full Article…


Create a Cron Job to start MySQL if it Stops

Sometimes server act weird and stop some services due to any issue. I faced this issue with my WordPress demo sites server, where MySQL service stops after running the clean script to remove demo demo sites after three days. So I created a Cron Job on my DigitalOcean Ubuntu Droplet to check if and start MySQL service if its  Full Article…


Magento – “Item (Mage_Catalog_Model_Product) with the same id ”xxx“ already exist”

I have been getting this error when trying to filter a products collection Item (Mage_Catalog_Model_Product) with the same id "7631" already exist and wanted to ask what could ne causing the error since there is only one (visible) product with the same ID inside of Magento. ———————————————————– Here is the solution i did to solve the  Full Article…


Magento – Change Product Type

Suppose you have created or Imported products into the Magento and now you want to change the products type like you have imported the products with the product type Downloadable and now you want this products from Downloadable to Simple then In the Magento admin there is no way to change the product type. If  Full Article…