Post4VPS Forum | Free VPS Provider

Full Version: Syntax Questions
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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!