Problems activating your account? Send notification email to: admin@post4vps.com
Host4Fun Budget VPS Hosting
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Syntax Questions
#1
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';

What syntax should I add to change my char set to utf8_general_ci when I create a database?
Code:
CREATE DATABASE db;

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

utf8_general_ci or utf8_unicode_ci? which is better to use in mysql database?

Thanks everyone!
Thank you VirMach and Post4VPS this awesome VPS 9.
Reply
 


Forum Jump:


Users browsing this thread: 1 Guest(s)

Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - SSDBlaze - VPSlices


About Post4VPS

Post4VPS is a forum/destiny where you can Delploy Your Free VPSs just by the Power of Posts.

We Provide VPSs of many locations like Germany,US,Canada,France,London,etc.

We also Provide VPSs of Both Linux and Windows OS.