Goaskle.com Support Department Goaskle.com Help Desk База знаний Web hosting Database
MySQL
Предлагаемые статьи Базы знаний:

База знаний Web hosting Database MySQL

Статьи в этом разделе:

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...

292
(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

824
(5)
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...

203
(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 -- ?

error become from SQL file from these strings ( this error very popular in magento 2 databases): CREATE ALGORITHM=UNDEFINED DEFINER= need to replace it with DEFINER = CURRENT_USER OR Create new DB use...

116
(1)
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...

55
(0)