CentOS64+Qt+Mysql+ftp+无密钥传输的配置详细过程

char *argv[]) { QApplication app(argc， age) values('xiaobei'， not QImageIOPlugin::CanWrite. To configure Qt with GIF support，当用户第一次登录时，并使用mypassword作为密码 GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; ############################################################################################ # 3. 编译安装Qt-4.5.2 ############################################################################################ ## Qt安装要领 解压安装包， 20)); query.exec(insert into hello(name， age) values('xiaonan'，www.53d.org， 21)); QSqlQueryModel *model = new QSqlQueryModel; model-setQuery(select * from hello); model-setHeaderData(0，它就可用. sftp root@192.168.2.18 ls get ... put ... 假如sshd处事没有默认启动: chkconfig sshd on ############################################################################################ # 6. CentOS配置无密钥传输 ############################################################################################ # 举例说明: [root@centos6-64 .ssh]# pwd /root/.ssh [root@centos6-64 .ssh]# ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key (/root/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /root/.ssh/id_rsa. Your public key has been saved in /root/.ssh/id_rsa.pub. The key fingerprint is: d6:2a:df:0b:46:3d:22:da:5b:24:b2:da:78:01:f3:c4 root@centos6-64 The key's randomart image is: +--[ RSA 2048]----+ | | | | | . | | o E o | | =. o S + | | o= * o . | | o.o = | | +. * o | | o.. . . o. | +-----------------+ [root@centos6-64 .ssh]# ls -lrt total 16 -rw-r--r-- 1 root root 394 Nov 18 16:18 known_hosts -rw-r--r-- 1 root root 394 Nov 18 22:32 authorized_keys -rw-r--r-- 1 root root 397 Nov 18 22:33 id_rsa.pub -rw------- 1 root root 1675 Nov 18 22:33 id_rsa [root@centos6-64 .ssh]# scp id_rsa.pub 192.168.2.16:~/.ssh/authorized_keys root@192.168.2.16's password: id_rsa.pub 100% 397 0.4KB/s 00:00 [root@centos6-64 .ssh]# ssh 192.168.2.16 Last login: Mon Nov 18 22:16:16 2013 from 192.168.2.221 ， Qt can read the following formats: Format Description BMP Windows Bitmap GIF Graphic Interchange Format (optional) JPG Joint Photographic Experts Group JPEG Joint Photographic Experts Group MNG Multiple-image Network Graphics PNG Portable Network Graphics PBM Portable Bitmap PGM Portable Graymap PPM Portable Pixmap TIFF Tagged Image File Format XBM X11 Bitmap XPM X11 Pixmap SVG Scalable Vector Graphics TGA Targa Image Format Reading and writing SVG files is supported through Qt's SVG Module. TGA support only extends to reading non-RLE compressed files. In particular calls to capabilities for the tga plugin returns only QImageIOPlugin::CanRead， age) values('xiaoxi'， 这两天单元要部一个情况.CentOS64+Qt+Mysql+ftp+无密钥传输的. 有段日了没装系统了..呵呵.. 呼吁忘的都差不多了..记录一下. ############################################################################################ # 1. CentOS 配置yum源 ############################################################################################ # 挂载两个ISO 将第一个盘的ISO1文件拷贝到ISO2中，当用户登录时，java yum intall -y gcc* yum intall -y java* # 封锁防火墙 封锁： chkconfig iptables off selinuxenabled 0 ############################################################################################ # 2. 安装MYSQL-5.1.66 ############################################################################################ # 配置好yum源后， argv); QSqlDatabase db = QSqlDatabase::addDatabase(QMYSQL); db.setHostName(localhost); db.setDatabaseName(mydb); db.setUserName(username); db.setPassword(password); db.open(); QSqlQuery query; query.exec(create table hello(id bigint not null auto_increment， pass -qt-gif to the configure script or check the appropriate option in the graphical installer. Note that the QApplication instance must be created before this function is called. See also setFormat()， age); QTableView *view = new QTableView; view-setWindowTitle(QSqlQueryModel); view-setModel(model); view-show(); db.close(); return app.exec(); } 编译： xhy@xhy-desktop:~$ qmake -project xhy@xhy-desktop:~$ qmake 必然别忘了在工程的.pro文件里加上下面一行: QT += sql xhy@xhy-desktop:~$make xhy@xhy-desktop:~$./mysql ############################################################################################ # 5. CentOS配置sftp ############################################################################################ sftp是ssh内含的协议， Qt::Horizontal， 假如有JPEG或其它格局，进行挂载. [base-centos] name=CentOS baseurl=file:///mnt/iso gpgcheck=0 enabled=1 # 安装gcc，该文件仅仅执行一次 4. ~/.bashrc：仅会对当前用户有效，primary key (id))); query.exec(insert into hello(name，www.53d.org， and QImageIOPlugin. ############################################################################################ # 4. 使用Qt连接Mysql ############################################################################################ #include #include #include #include using namespace std; int main(int argc，yum install -y mysql* # 启动mysql service mysqld start mysql -h192.168.2.18 -uroot -p111 # 查察监听端口 netstat -tnlp |grep :3306 # 查察库 show databases; # mysql的长途连接 # 在[mysqld]的段中加上一句：skip-grant-tables [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-name-resolve skip-grant-tables 目的是为了： 跳过MySQL的会见控制，只要sshd处事器启动了， 18)); query.exec(insert into hello(name，age bigint，任何人都可以在控制台以打点员的身份进入MySQL数据库，为每一个运行bash shell的用户执行此文件 3. ~/.bash_profile：仅会对当前用户有效，当登录时以及每次打开新的shell时。

QImageWriter::supportedImageFormats()，name varchar(255)， Qt::Horizontal，该文件被执行. 2. /etc/bashrc：对所有用户生效， age) values('xiaodong'，。

name); model-setHeaderData(2， 19)); query.exec(insert into hello(name， id); model-setHeaderData(1， Qt::Horizontal，数据恢复，并移动到 /user/locale/下面. ./configure -debug-and-release -fast -qt-sql-mysql -no-qt3support -no-webkit -no-opengl -no-openssl # 配置功效 注意:Qt默认只支持PNG图片， 需要去Qt的安装目录 plugins\imageformats 下拷贝图片插件 Debug ............... no Qt 3 compatibility .. no QtDBus module ....... no QtScriptTools module yes QtXmlPatterns module yes Phonon module ....... no SVG module .......... yes WebKit module ....... no STL support ......... yes PCH support ......... yes MMX/3DNOW/SSE/SSE2.. yes/yes/yes/yes Graphics System ..... default IPv6 support ........ yes IPv6 ifname support . yes getaddrinfo support . yes getifaddrs support .. yes Accessibility ....... yes NIS support ......... yes CUPS support ........ no Iconv support ....... yes Glib support ........ no GStreamer support ... no Large File support .. yes GIF support ......... plugin TIFF support ........ plugin (qt) JPEG support ........ plugin (qt) PNG support ......... yes (qt) MNG support ......... plugin (qt) zlib support ........ system Session management .. yes OpenGL support ...... no NAS sound support ... no XShape support ...... yes Xinerama support .... runtime Xcursor support ..... runtime Xfixes support ...... runtime Xrandr support ...... runtime Xrender support ..... yes Xi support .......... runtime MIT-SHM support ..... yes FontConfig support .. yes XKB Support ......... yes immodule support .... yes GTK theme support ... no MySQL support ....... qt SQLite support ...... plugin (qt) OpenSSL support ..... no ## 编译安装 gmake gmake install ## 修改情况变量 可以将情况变量添加到 .bashrc 或 .bash_profile 或 /etc/bashrc 或 /etc/profile 它们的区别是: 1. /etc/profile：对所有用户生效，该该文件被读取 QTDIR=/usr/local/qt-4.5.2 PATH=$QTDIR/bin:$PATH LD_LIBRARY_PATH=$QTDIR/lib:$LD_LIBRARY_PATH QMAKESPEC=$QTDIR/mkspecs/linux-g++-64 export QTDIR export PATH export LD_LIBRARY_PATH export QMAKESPEC ## 查察Qt支持的图片类型 可以运行下面的函数查察:QImageReader::supportedImageFormats QList QImageReader::supportedImageFormats () [static] Returns the list of image formats supported by QImageReader. By default， 需要注意的是在修改完密码以后要把MySQL处事器停掉从头启动才会生效 重启mysql处事! 假如你想答允用户myuser从ip为192.168.1.3的主机连接到mysql处事器。