110 likes | 271 Views
How to Use MySql in Linux. by CaiYao Nov ,2004. PlatForm. RedHat 9 MySql 3.23.54 phpMyAdmin 2.5.7(depend on Apache). Start the Service. /sbin/service mysqld start (For phpmyadmin) /sbin/service httpd start.
E N D
How to Use MySql in Linux by CaiYao Nov ,2004
PlatForm • RedHat 9 • MySql 3.23.54 • phpMyAdmin 2.5.7(depend on Apache)
Start the Service • /sbin/service mysqld start • (For phpmyadmin) • /sbin/service httpd start
Use C to operate the Database • 1.Initialize • 2.Connect • 3.Operate • 4.Close • 5.Encrypt
Operation • MYSQL_RES *result; • MYSQL_ROW row; • int onlinefriends,userport;
Compile and Run • gcc -o test test.c • -L/usr/lib/mysql -lmysqlclient