
准备:要一台配置好一点的电脑。处理器至少双核的,内存4G 最好用独立显卡。 主机系统用WinXP (Win2003) 虚拟机用linux (红帽子4.0)
第一步:主机建立数据库:安装ORACLE数据库;
第二步:安装虚拟机VMware Workstation 7.0;
第三步:主机上安装SecureCRT&WinSCP (主机和虚拟机传输数据的软件);
第四步:上传服务端到虚拟机上,安装MYSQL数据库(虚拟机);
第五步:修改服务器上的一些IP,端口什么的,有必要的话可以做端口转发;
第六步:主机上安装IIS,运行网站(游戏才能用户);
第七步:客户端设置登陆器。
(基本步骤是这样的,要架设成功的话,每一步还有很详细的东西,加分附上详细说明。)
启动虚拟机。不用进入桌面。先准备两个软件。WinSCP3中文版和SecureCRT。WINSCP3设置用二进制。然后上传相关软件
两个软件的密码,都是刚才Linux系统的。123456
上传DBInit_0_31_0180_data_mysql.sql DBInit_0_31_0180_table_mysql.sql tlbbdb_stat.sql
mysql-5.0.45.tar.gz这四个文件。
然后看 *** 作,一行一行复制回车运行。cd /hometar xzvf mysql-5.0.45.tar.gz
cd /home/mysql-5.0.45
./configure --prefix=/usr/local/mysql5.0.45 --with-charset=utf8 --with-extra-charsets=all --enable-thread-safe-client
make 这一步要10分钟,我暂停
好,接着下一个
make install
cp /usr/local/mysql5.0.45/share/mysql/my-small.cnf /etc/my.cnf不管乱码,输入 Y 回车修改/etc/my.cnf在[mysqld] 和 [client]段都加入如下指令即可:
default-character-set=utf8
/usr/local/mysql5.0.45/bin/mysql_install_db/usr/local/mysql5.0.45/bin/mysqld_safe --user=root & 启动mysql服务 回车。然后再回车mysql -u root -p `进入mysql *** 作 密码为空直接回车确认use mysql update user set Password=PASSWORD('donglei') where User='root'`XXXXX为你要设置mysql管理员的密码
GRANT ALL PRIVILEGES ON *.* TO root@"192.168.1.%" IDENTIFIED BY "donglei"insert into mysql.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) value ('192.168.1.%', 'tlbb', 'tlbb1234', '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)insert into mysql.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) value ('192.168.1.%', 'tlbbtools', 'tlbb1234', 'Y','Y','Y','Y','N','Y','N','N','N','N','N','Y','Y','N','N','N','Y','N','Y','N','N','Y','Y','N','N','N','','','','',0,0,0,0)flush privilegescreate database tlbbdbcreate database tlbbdb_statinsert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '192.168.1.%', 'tlbbdb','tlbb', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y')insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '192.168.1.%', 'tlbbdb','tlbbtools', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'Y')insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '192.168.1.%', 'tlbbdb_stat','tlbb', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N')GRANT ALL PRIVILEGES ON *.* TO tlbb@"192.168.1.%" IDENTIFIED BY "tlbb1234"GRANT ALL PRIVILEGES ON *.* TO tlbbtools@"192.168.1.%" IDENTIFIED BY "tlbb1234"exit `退出mysql *** 作导入数据库:cd /home mysql -uroot -pdonglei tlbbdb <DBInit_0_31_0180_table_mysql.sql
mysql -uroot -pdonglei tlbbdb <DBInit_0_31_0180_data_mysql.sql
mysql -uroot -pdonglei tlbbdb_stat <tlbbdb_stat.sql
安装完成。
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)