Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/meta.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 15

Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/header.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 32

Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/left-bar.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 38

Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/right-bar.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 41

Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/banner728-90.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 47

Синтаксис SHOW GRANTS

Главная Страница » Книги по PHP » MySQL уроки для начинающих с нуля » Синтаксис SHOW GRANTS в MySQL


Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/MySQL/menu-t.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 53

SHOW GRANTS FOR user вносит в список команды, который должны быть выданы, чтобы дублировать права пользователя. Например:

mysql> SHOW GRANTS FOR root@localhost;
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO "root"@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+

Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/share.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 77

Warning: include() [function.include]: Failed opening '/var/www/phps/data/www/php-s.ru/inc/footer.inc' for inclusion (include_path='.:/usr/local/zend-5.3/share/pear') in /home/users/n/niyazov/domains/php-s.ru/MySQL/4_33/index.php on line 84