search

ubccr / mokey

FreeIPA self-service account management portal
BSD 3-Clause "New" or "Revised" License
189 stars 45 forks source link

Just wondering is no missing `;` ? #63

Closed ckc closed 3 years ago

ckc commented 3 years ago 
$ mysql> grant all on mokey.* to [user]@localhost identified by '[pass]'
$ mysql> exit
$ mysql -u root -p mokey < /usr/share/mokey/ddl/schema.sql

MariaDB [(none)]> grant all on mokey.* to [user]@localhost identified by '[pass]'
    -> exit
    -> mysql -u root -p mokey < /usr/share/mokey/ddl/schema.sql
    ->

So I tried end with ; but got error

    -> ;
ERROR 1064 (42000): 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 '[user]@localhost identified by '[pass]'
exit
mysql -u root -p mokey < /usr/share' at line 1

I'm sorry that I often use GUI operations like phpmyadmin

Thanks

ckc commented 3 years ago

I misreading, so be no problem thanks

SomePersonSomeWhereInTheWorld commented 3 years ago

Just a tip that user should be in single quotes:

grant all on mokey.* to '[user]'@localhost identified by '[pass]'