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

Groups > linux.debian.user > #175390 > unrolled thread

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

Back to article view | Back to linux.debian.user

Contents

  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

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

[Multipart message — attachments visible in raw view] — view raw

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

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.

[toc] | [next] | [standalone]

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Dec 03, 2016 at 11:46:16PM -0700, Nate Homier wrote:
> I followed the Debian wiki for Wordpress.  I got to the part about
> 
> cat ~/wp.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf

Can you show us the file "wp.sql" you used?

My guess is that by copying&pasting you picked up the line numbers from the
wiki page: those don't belong to the SQL commands. But it's just a guess.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iEYEARECAAYFAlhD680ACgkQBcgs9XrR2kZ46gCeM4wW/eLKvEtdBLSwK8k8o3Wt
MtwAn1p7YMWy7hu0bOrRc4luYKZXmPC8
=QQRG
-----END PGP SIGNATURE-----

[toc] | [prev] | [next] | [standalone]

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

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

[toc] | [prev] | [next] | [standalone]

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

[Multipart message — attachments visible in raw view] — view raw

A ha, line numbers!
Toggle line numbers

   1 CREATE DATABASE wordpress;
   2 GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
   3 ON wordpress.*
   4 TO wordpress@localhost
   5 IDENTIFIED BY 'NaTe1973J15!';
   6 FLUSH PRIVILEGES;
​
Now that is very obvious once you know it.  I thought the phrase toggle
line numbers was a SQL thing.  Lol.  Thanks to everybody who helped.  You
must get this sort of thing sometimes.

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web