Goaskle.com Support Department Goaskle.com Help Desk Knowledgebase Web hosting Database
MySQL
Suggested knowledgebase articles:

Knowledgebase Web hosting Database MySQL

Articles in this category

How to fix issue in mysql import CREATE ALGORITHM=UNDEFINED DEFINER=?

error become  CREATE ALGORITHM=UNDEFINED DEFINER= need to replace it with DEFINER = CURRENT_USER Also its possible to replace all strings with DEFINER = `your_db_user`@`localhost` with...

1,488
(4)
How to fix error in mysql: ERROR 1452 (23000) CONSTRAINT in magento 2 ?

use this command to find the rows that need to be deleted: select * from orders where cid not in (select distinct id from customers); Also you can check in sql file who have rights to database

1,434
(9)
How to reset root password in mariadb or mysql server v5.6+?

/etc/init.d/mysql stop mysqld_safe --skip-grant-tables & mysql -u root   use mysql; update user set authentication_string=PASSWORD("mynewpassword") where User='root'; flush privileges; quit   /etc...

743
(1)
How to fix -- ERROR 1227 (42000) at line 728: Access denied; you need (at least one of) the SUPER privilege(s) for this operation -- ?

First create backup / export of database using these steps: 1. Enter to SSH. 2. Run command: database dump: mysqldump --add-drop-table -u your_user -p your_db > ~/your_host_db_20151001.sql (insert ...

927
(2)
How to replace text in field using mysql request?

UPDATE table_name SET field = REPLACE(field, 'foo', 'bar') WHERE INSTR(field, 'foo') > 0; example: UPDATE `catalog_product_entity_text` SET value = REPLACE(value, 'Textold', 'Text new') W...

636
(0)
In Mysql. How to check exist or not records in table related to other table?

If you need to find all records on one table related to other which have no related records in ohter table mysql request: SELECT `contract_uid` FROM `_jomres_contracts` WHERE `dat...

540
(0)
How to get list of records between dates using mysql?

Just use this sql code for your requests and you will get records included into period between these dates (including start and end dates): SELECT * FROM events WHERE event_date BETWEEN DATE("2023-01-...

110
(0)