Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #175395

Re: Followed https://wiki.debian.org/WordPress got mysql error, syntax Error 1064

Show all headers | View raw

Nate Homier <purplenate26@gmail.com> writes:

> I followed the Debian wiki for Wordpress.  I got to the part about
>
> cat ~/wp.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf
>
> And boom, error!
>
> Error is; 1064 (42000) at line 1:
>
> you have an error in your SQL syntax
>
> 1 CREATE DATABASE wordpress' at line 1
>

It looks like you have got the line numbers with your copy-paste.  The
wiki has a button to disable showing line numbers in code snippets.  The
line numbers should not be present in the sql file.  You can remove them
by hand also, of course.

> I am running latest version of Debian 8 with all updates applied.
>
> Server only.  I simply copied and pasted the commands.  This is my first
>
> time trying to run Wordpress.
>
> Any ideas, I am not familiar with MySQL.

--
regards,
kushal

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Followed https://wiki.debian.org/WordPress got mysql error, syntax  Error 1064 Nate Homier <purplenate26@gmail.com> - 2016-12-04 07:50 +0100
  Re: Followed https://wiki.debian.org/WordPress got mysql error,  syntax Error 1064 <tomas@tuxteam.de> - 2016-12-04 11:20 +0100
  Re: Followed https://wiki.debian.org/WordPress got mysql error, syntax Error 1064 Kushal Kumaran <kushal@locationd.net> - 2016-12-04 11:20 +0100
    Re: Followed https://wiki.debian.org/WordPress got mysql error,  syntax Error 1064 Nate Homier <purplenate26@gmail.com> - 2016-12-04 13:20 +0100

csiph-web