Форум пользователей MySQL

-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1.3
-- <a href="http://www.phpmyadmin.net">http://www.phpmyadmin.net</a>
--
-- Host: dbserver1.way.info:12355
-- Generation Time: Feb 15, 2012 at 03:35 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.23

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mysql`
--

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `User` char(16) collate utf8_bin NOT NULL default '',
  `Password` varchar(41) collate utf8_bin NOT NULL default '',
  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_user_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL default '0',
  `max_updates` int(11) unsigned NOT NULL default '0',
  `max_connections` int(11) unsigned NOT NULL default '0',
  `max_user_connections` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`) VALUES
('127.0.0.151', 'root', '*882EAEFBBF5773A705C20883E60AC1EDAC6F30A1', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);

-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1.3
-- <a href="http://www.phpmyadmin.net">http://www.phpmyadmin.net</a>
--
-- Host: dbserver1.way.info:12355
-- Generation Time: Feb 15, 2012 at 03:45 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.23

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `information_schema`
--

-- --------------------------------------------------------

--
-- Table structure for table `USER_PRIVILEGES`
--

CREATE TEMPORARY TABLE `USER_PRIVILEGES` (
  `GRANTEE` varchar(81) NOT NULL default '',
  `TABLE_CATALOG` varchar(512) default NULL,
  `PRIVILEGE_TYPE` varchar(64) NOT NULL default '',
  `IS_GRANTABLE` varchar(3) NOT NULL default ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Dumping data for table `USER_PRIVILEGES`
--

INSERT INTO `USER_PRIVILEGES` (`GRANTEE`, `TABLE_CATALOG`, `PRIVILEGE_TYPE`, `IS_GRANTABLE`) VALUES
('''root''@''127.0.0.151''', NULL, 'SELECT', 'YES'),
('''root''@''127.0.0.151''', NULL, 'INSERT', 'YES'),
('''root''@''127.0.0.151''', NULL, 'UPDATE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'DELETE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'CREATE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'DROP', 'YES'),
('''root''@''127.0.0.151''', NULL, 'RELOAD', 'YES'),
('''root''@''127.0.0.151''', NULL, 'SHUTDOWN', 'YES'),
('''root''@''127.0.0.151''', NULL, 'PROCESS', 'YES'),
('''root''@''127.0.0.151''', NULL, 'FILE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'REFERENCES', 'YES'),
('''root''@''127.0.0.151''', NULL, 'INDEX', 'YES'),
('''root''@''127.0.0.151''', NULL, 'ALTER', 'YES'),
('''root''@''127.0.0.151''', NULL, 'SHOW DATABASES', 'YES'),
('''root''@''127.0.0.151''', NULL, 'SUPER', 'YES'),
('''root''@''127.0.0.151''', NULL, 'CREATE TEMPORARY TABLES', 'YES'),
('''root''@''127.0.0.151''', NULL, 'LOCK TABLES', 'YES'),
('''root''@''127.0.0.151''', NULL, 'EXECUTE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'REPLICATION SLAVE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'REPLICATION CLIENT', 'YES'),
('''root''@''127.0.0.151''', NULL, 'CREATE VIEW', 'YES'),
('''root''@''127.0.0.151''', NULL, 'SHOW VIEW', 'YES'),
('''root''@''127.0.0.151''', NULL, 'CREATE ROUTINE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'ALTER ROUTINE', 'YES'),
('''root''@''127.0.0.151''', NULL, 'CREATE USER', 'YES');