0

I am trying to install roundcube. Anyways, this is what I need to enter.

> CREATE DATABASE roundcubemail CHARACTER SET utf8 COLLATE utf8_general_ci;
> CREATE USER roundcube@localhost IDENTIFIED BY 'password'; (THIS IS WHERE THE PROBLEM IS)
> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost;

When I try to enter '' I end up getting ‘ ’ which causes a syntax error.

I am on a minimal install. I am using PHP.

I'm a beginner, so take it easy on me if I am missing an obvious step haha.

Phil
  • 157,677
  • 23
  • 242
  • 245
SeeNTower
  • 1
  • 1
  • 1
    What is "_..the apostrophe that MySQL accepts.._"? What is the Error? What exactly is the code? – FanoFN Aug 10 '20 at 04:48
  • The code is in the opening post. What I mean is that when I try put the password in ' ' this type of apostrophe pops up: ’ which then causes a syntax error. – SeeNTower Aug 10 '20 at 05:16
  • and what about this : `CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';` – GNassro Aug 10 '20 at 05:55
  • What program are you typing these commands into? Are you typing them or copy / pasting from somewhere else? – Phil Aug 10 '20 at 06:03
  • Often times I see `' '` changes to `‘ ’` in Microsoft Words. – FanoFN Aug 10 '20 at 06:06
  • @Phil I am using a CentOS7 machine with a minimal install. I am typing these commands in myself. – SeeNTower Aug 10 '20 at 15:26
  • @GNassro The command itself is fine, but its the ```' '``` that are causing the problems. When I type into the command line, they end up looking like ```‘ ’``` instead of ```' '``` which causes a syntax error. – SeeNTower Aug 10 '20 at 15:28
  • 1
    @SeeNTower we're going to need more details. What application are you typing into? Is it the terminal or something else? How do the apostrophe characters _"end up"_ turning into curly quotes? Do you literally type `'` and what appears on screen is `‘` or does it happen later somehow? Explain the problem in detail with the steps you take. Could you take a screen recording at all (eg, using [Peek](https://github.com/phw/peek)) – Phil Aug 10 '20 at 22:45

0 Answers0