3-4 隋过程apache虚拟机+mysql多库实现-linux 学习笔记

mysql>GRANTALLPRIVILEGESON*.*TO't1'@'%'identifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>GRANTALLPRIVILEGESONvfast.*TO't2'@'%'identifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>GRANTALLPRIVILEGESONvfast.aTO't3'@'%'identifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>createdatabasevfast;QueryOK,1rowaffected(0.00sec)mysql>usevfast;createtablea(aint);DatabasechangedQueryOK,0rowsaffected(0.01sec)mysql>insertintoavalues(1);QueryOK,1rowaffected(0.00sec)mysql>GRANTselectONvfast.aTO't4'@'%'identifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>flushprivileges;ALLPRIVILEGESusagemysql>GRANTusageON*.*TO't5'@'%'identifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)[root@wwwmysql-tar]#mysql-ut5-h2-p123WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis9Serverversion:5.0.77-logSourcedistributionType'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||test|+--------------------+2rowsinset(0.00sec)mysql>usetestDatabasechangedmysql>createtablet5(aint);QueryOK,0rowsaffected(0.00sec)mysql>select*frommysql.db\G***************************1.row***************************Host:%Db:testUser:Select_priv:YInsert_priv:YUpdate_priv:YDelete_priv:YCreate_priv:YDrop_priv:YGrant_priv:NReferences_priv:YIndex_priv:YAlter_priv:YCreate_tmp_table_priv:YLock_tables_priv:YCreate_view_priv:YShow_view_priv:YCreate_routine_priv:YAlter_routine_priv:NExecute_priv:N***************************2.row***************************Host:%Db:test\_%User:Select_priv:YInsert_priv:YUpdate_priv:YDelete_priv:YCreate_priv:YDrop_priv:YGrant_priv:NReferences_priv:YIndex_priv:YAlter_priv:YCreate_tmp_table_priv:YLock_tables_priv:YCreate_view_priv:YShow_view_priv:YCreate_routine_priv:YAlter_routine_priv:NExecute_priv:Nrevokemysql>#revokeallprivilegeson*.*from't1'@'%';mysql>#showgrantsfor't1'@'%';dropusermysql>dropuser't1'@'%';QueryOK,0rowsaffected(0.00sec)mysql>showgrantsfor't1'@'%';ERROR1141(42000):Thereisnosuchgrantdefinedforuser't1'onhost'%'passwordmoth1mysql>updatemysql.usersetpassword=password('456')whereuser='t5';QueryOK,1rowaffected(0.00sec)Rowsmatched:1Changed:1Warnings:0mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)[root@wwwmysql-tar]#mysql-ut5-h2-p123ERROR1045(28000):Accessdeniedforuser't5'@'54'(usingpassword:YES)[root@wwwmysql-tar]#mysql-ut5-h2-p456WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis16Serverversion:5.0.77-logSourcedistributionType'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>moth2mysql>GRANTusageON*.*TO't5'@'%'identifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)[root@wwwmysql-tar]#mysql-ut5-h2-p456ERROR1045(28000):Accessdeniedforuser't5'@'54'(usingpassword:YES)[root@wwwmysql-tar]#mysql-ut5-h2-p123WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis18Serverversion:5.0.77-logSourcedistributionType'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>forgetpassword42#/etc/init.d/mysqldstop停止MySQL：[确定]42#mysqld_safe--skip-grant-tables--skip-networking&deleteanoymoususer42#mysql-uroot-p123WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis16Serverversion:5.0.77-logSourcedistributionType'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>#deletefrommysql.userwhereuser='';mysql>#flushprivileges;#######logintestmysql-u-plogin?###########homeworkapache yuminstallapache+php+php-mysql php--->mysql_connect("","username","123");mysql yuminstallmysql-serverapache+php+php-mysql 3VirtualHost DocumentRoot /tmp/bbs1 /tmp/bbs2 /tmp/bbs3 installphpwind mysql-server onbbsondatabase onuserondatabase createdatabase[1,2,3] grant3user user1 database1 user2 database2 user3 database3clientsee3bbsanswer:apache+php23#yuminstallhttpdphpphp-mysql-yapache+php23#vimhttpd.confNameVirtualHost3:80<VirtualHost3:80>#ServerAdminwebmaster@DocumentRoot/www/docs/bbs1/uploadServerName#ErrorLoglogs/-error_log#CustomLoglogs/-access_logcommon</VirtualHost><VirtualHost3:80>#ServerAdminwebmaster@DocumentRoot/www/docs/bbs2/uploadServerName#ErrorLoglogs/-error_log#CustomLoglogs/-access_logcommon</VirtualHost><VirtualHost3:8080>#ServerAdminwebmaster@DocumentRoot"/www/docs/bbs3/upload"ServerName#ErrorLoglogs/-error_log#CustomLoglogs/-access_logcommon</VirtualHost>apache+php23#mkdir-pv/www/docs/bbs{1,2,3}/uploadmkdir:已创建目录“/www/docs/bbs1”mkdir:已创建目录“/www/docs/bbs1/upload”mkdir:已创建目录“/www/docs/bbs2”mkdir:已创建目录“/www/docs/bbs2/upload”mkdir:已创建目录“/www/docs/bbs3”mkdir:已创建目录“/www/docs/bbs3/upload”apache+php23#apache+php23#unzipphpwind.zipapache+php23#pwd/tmp/PHPWind_UTF8_7.3/uploadapache+php23#cp-fr*/www/docs/bbs1/upload/apache+php23#cp-fr*/www/docs/bbs2/upload/apache+php23#cp-fr*/www/docs/bbs/upload/apache+php23#chmod777/www/docs/-Rmysql-servermysql-server42#yuminstallmysql-server-ymysql-server42#mysqlWelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis22Serverversion:5.0.77-logSourcedistributionType'help;'or'\h'forhelp.T