Breaking News: Grepper is joining You.com. Read the official announcement!

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDENTIFIED BY RANDOM PASSWORD' at line 1

Benja answered on September 7, 2022 Popularity 10/10 Helpfulness 4/10

answer ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDENTIFIED BY RANDOM PASSWORD' at line 1

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDENTIFIED BY RANDOM PASSWORD' at line 1

Comment

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: line manual near random sql syntax version

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Benja

0 Answers Avg Quality 2/10

Closely Related Answers

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'E' at line 1

Comment

For example :

In the php file that I wrote this code in the database...

I didn't put the comma ( , ) before [$id]

public function delete($id)
     {
       $db = new DataBase();	
       $post = $db->select('SELECT * FROM posts WHERE id = ?;' [$id])->fetch();
       $this->removeImage($post['image']);
       $db->delete('posts', $id);
       $this->redirectBack();
     }

This code is correct :

public function delete($id)
     {
       $db = new DataBase();	
       $post = $db->select('SELECT * FROM posts WHERE id = ?;' , [$id])->fetch();
       $this->removeImage($post['image']);
       $db->delete('posts', $id);
       $this->redirectBack();
     }

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: line

Link to this answer
Share Copy Link

Contributed on Sep 04 2023

for prog

0 Answers Avg Quality 2/10

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDENTIFIED BY RANDOM PASSWORD' at line 1

Contents

More Related Answers

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDENTIFIED BY RANDOM PASSWORD' at line 1

Closely Related Answers

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'E' at line 1

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.