غیر فعال کردن استارت آپ سریع در ویندوز ۸ و ۱۰

How to disable fast startup in Windows 8 and 10

Go to Control Panel > Hardware and Sound > Power Options > System Setting > Choose what the power buttons do and uncheck the Turn on fast startup box.

استفاده از فونت فارسی در mysql بصورت پیش فرض

To set the default to UTF-8, you want to add the following to my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

ایجاد کاربر جدید در Mysql و دادن مجوز ها

mysql> create user ‘newuser’@’localhost’ identified by ‘password’;

mysql>grant all privileges on * . * to ‘newuser’@’localhost’;

mysql>flush privileges;

mysql>grant [type of permission] on [database name] . [table name] to ‘userName’@’localhost’;

mysql>revoke [type of permission] on [database name] . [table name] from ‘userName’@’localhost’;

mysql>drop user ‘userName’@’localhost’;

type of permissions: all privileges – creat – drop – delete – insert – select – update – grant option