Post4VPS Forum | Free VPS Provider
Syntax Questions - Printable Version

+- Post4VPS Forum | Free VPS Provider (https://post4vps.com)
+-- Forum: Geek World (https://post4vps.com/Forum-Geek-World)
+--- Forum: Scripting & Programming (https://post4vps.com/Forum-Scripting-Programming)
+--- Thread: Syntax Questions (/Thread-Syntax-Questions)



Syntax Questions - Vuluts - 02-05-2018

Greetings to everyone!
I do have some questions about syntax, currently using Debian Linux OS.

What is the difference with this two syntax in MySQL?
Code:
GRANT ALL PRIVILEGES ON database.* TO 'user'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES;
- and -
GRANT ALL PRIVILEGES ON `database`.* TO 'admin'@'localhost';

How can I make a installation script to simply install all the prerequisites?

utf8_general_ci or utf8_unicode_ci? which is more complex to use in mysql database?

Thanks everyone!