machineA:[real machine]{
os:win xp
ip:192.168.40.220
}
machineB:[in vmware]{
os:Linux xc 2.6.18-164.el5 #1
SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux
ip:192.168.40.29
install iso:rhel-server-5.4-i386-dvd.iso
}
/etc/yum.repos.d/rhel-debuginfo.repo
[rhel-debuginfo]
name=Red Hat Enterprise Linux
#baseurl=http://mirrors.163.com/centos/5/os/i386
baseurl=http://123.58.173.89/centos/5/os/i386
enabled=1
gpgcheck=0
gpgkey=http://123.58.173.89/RPM-GPG-KEY-CentOS-5
yum clean all
yum update
yum search mysql
yum install mysql-server.i386 mysql-connector-odbc.i386 -y
/etc/init.d/mysqld restart
mysql -h localhost -u root -p[ok]
[winxp]mysql -h 192.168.40.29 -u root -p[err:{]
ERROR 1130 (HY000): Host '192.168.40.220' is not allowed to connect to this MySQ
L server
[}]
mysql -h localhost -u root -p[exe sql:{]
use mysql
select host,user from user;
update user set host='192.168.40.220' where host='127.0.0.1';
[}]
/etc/init.d/mysqld restart
[in winxp]mysql -h 192.168.40.29 -u root -p[ok]
[upload]unix-odbc-demo.zip
[unzip]
cp unix-odbc-demo/odbc.ini /etc/odbc.ini
[/etc/odbc.ini:{]
[ub]
Driver = mysql
Description = example
Server = 192.168.40.29
Port = 3306
Database = db_demo
User = root
Password =
[}]
yum install gcc.i386 gcc-c++.i386 -y
g++ -c demo.cc -o demo.o[err:]
{no sql.h ...}
yum search unixODBC
yum install unixODBC-devel.i386 -y
g++ -c demo.cc -o demo.o[ok]
g++ -o demo demo.o -lodbc
[in winXP, login mysqlServer, exec:{]
create database db_demo;
use db_demo;
create table tb_demo(i int);
insert into tb_demo(i) values(99);
insert into tb_demo(i) values(3);
[}]
./demo [err:{]
[unixODBC][MySQL][ODBC 3.51 Driver]Host '192.168.40.29' is not allowed to connect to this MySQL server
[}]
[exec sql:{]
use mysql;
update user set host='192.168.40.29' where host='xc' and user='root';
[}]
/etc/init.d/mysqld restart
./demo[ok,output:{]
cnt=2
[}]
[what is 'xc']hostname[output:]
{xc}