Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

UbuntuÎÞÍø»·¾³mysql°²×°ÅäÖÃÎÊÌâ½â¾ö

Ò»¡¢mysql°²×°ÅäÖÃ
root@xmlinuxer-server:/media/WinF/LAMP#groupadd mysql
root@xmlinuxer-server:/media/WinF/LAMP#useradd -g mysql mysql
root@xmlinuxer-server:/media/WinF/LAMP#tar -zxvf mysql-5.0.33.tar.gz
root@xmlinuxer-server:/media/WinF/LAMP#cd mysql-5.0.33
root@xmlinuxer-server:/media/WinF/LAMP/mysql-5.0.33#./configure --prefix=/opt/app/mysql5 --without-debug --without-bench --with-charset=utf8 --with-extra-charsets=all --with-plugins=fthightman --enable-thread-safe-client
Èç¹û³öÏÖÁËÒÔÏ´íÎó£º
checking for tgetent in -ltermcap... no
checking for termcap functions library… configure: error: No curses/termcap library found
˵Ã÷ curses/termcap ¿âûÓа²×°
apt-cache search curses | grep lib
°²×° libncurses5-dev £¬È»ºóÖØÐÂÔËÐÐÅäÖÃ
apt-get install libncurses5-dev
»òÕß·½·¨¶þ
È¥ÏÂÔØÒ»¸öncurses-5.6.tar.gz£¬
wget http://ftp.gnu.org/pub/gnu/ncurses/ncurses-5.6.tar.gz
tar zxvf ncurses-5.6.tar.gz
cd ncurses-5.6
./configure –prefix=/usr –with-shared –without-debug
make
make install clean
È»ºóÔÙÖØÐ±àÒëMysql½øÐа²×°¡£
root@xmlinuxer-server:/media/WinF/LAMP/mysql-5.0.33#make
root@xmlinuxer-server:/media/WinF/LAMP/mysql-5.0.33#make install
root@xmlinuxer-server:/media/WinF/LAMP/mysql-5.0.33#cp support-files/my-medium.cnf /etc/my.cnf //¸´ÖÆÊý¾Ý¿âmysqlµÄÅäÖÃÎļþ
root@xmlinuxer-server:/media/WinF/LAMP/mysql-5.0.33#cp support-files/mysql.server /etc/init.d/mysql
Ubuntu ϵͳÏÂÃ²ËÆÃ»ÓÐ/etc/rc.dÕâĿ¼ àÅ ÆäËûµÄLinuxϵͳ¿ÉÄÜÊÇ/etc/rc.d/init.d/mysql
root@xmlinuxer-server:/media/WinF/LAMP/mysql-5.0.33#cd /opt/app/mysql5
root@xmlinuxer-server:/opt/app/mysql5#bin/mysql_install_db --user=mysql
root@xmlinuxer-server:/opt/app/mysql5#chown -R root . //²»ÒªÉÙÁ˺óÃæÄǸö“.”¿©
root@xmlinuxer-server:/opt/app/mysql5#chown -R mysql var
root@xmlinuxer-server:/opt/app/mysql5#chgrp -R mysql .
root@xmlinuxer-server:/opt/app/mysql5/share/mysql# service mysql start
³ÌÐò ’service’ ÒѰüº¬ÔÚÒÔÏÂÈí¼þ°üÖУº
* debian-helper-scripts
*


Ïà¹ØÎĵµ£º

MySqlÓû§´´½¨¡¢ÊÚȨÒÔ¼°É¾³ý(תÌù)

he create user command:
mysql
> CREATE
 
USER
 yy IDENTIFIED 
BY
 
'
123
'
;
yy±íʾÄãÒª½¨Á¢µÄÓû§Ãû£¬ºóÃæµÄ123±íʾÃÜÂë
ÉÏÃæ½¨Á¢µÄÓû§¿ÉÒÔÔÚÈκεط½µÇ½¡£
Èç¹ûÒªÏÞÖÆÔڹ̶¨µØÖ·µÇ½£¬±ÈÈçlocalhost µÇ½£º
mysql
> CREATE
 
USER
 yy@localhost
&n ......

¡¾Õª×ÔCSDNÂÛ̳¡¿mysqlÃüÁîÐг£ÓÃÃüÁî

mysqlÃüÁîÐг£ÓÃÃüÁî
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ ......

hibernate mysql ²åÈëÖÐÎÄ´íÎó

 Ê¹ÓÃhibernate mysql ²åÈëÖÐÎÄ´íÎó£º
 Ô­ÒòÖ®Ò»ÊÇ£º
  mysql µÄ×Ö·û±àÂëºÍhibernate´«µÝµÄ±àÂë²»Ò»Ñù£¬
  ÀýÈ磺
  mysql ½¨¿âµÄʱºò¿ÉÒÔÉèÖñàÂë:
  CREATE DATABASE db DEFAULT CHARACTER SET utf8;
 hibernate Á¬½ÓmysqlµÄ±àÂ룺
 jdbc:mysql://127.0.0.1:3306/db?useU ......

ORACLE Óë mysql µÄÇø±ð

 1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ² ......

ASP.NET ²Ù×÷MySQLÊý¾Ý¿âµÄ·½·¨ËµÃ÷

using System;
using System.Data;
using System.Diagnostics;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
namespace System
{
 /// <summary>
 /// Description of MySqlDBUtil.
 /// </summary>
 public class MySqlDBUtil
 {
  &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ