logo
Blog single photo

MySQL Error 1064: You have an error in your SQL syntax


                        

SQL query:
--
-- Database: `information_schema`
--
- - CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
MySQL said:
#1064 - Erreur de syntaxe près de '- - CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8' à la ligne 4
How can i fix it...

Check your phpMyadmin. i think this database already exists..
Or --> check your mysql version ...
Open your information_schema.sql on notepad++ or as u like..

-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 12, 2016 at 10:06 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
see this link ...
(1)   http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064

(2)  http://dev.mysql.com/doc/refman/5.7/en/alter-database.html
Top